System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'StatusId'. Invalid column name 'ErrorLog'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Etoz.ConnectData.DataAccess.ExecuteQuery(String query) in c:\inetpub\wwwroot\cricdirect.com\api\v6\App_Code\db\data_access.cs:line 117 ClientConnectionId:027dcad2-12d7-4d12-96e8-747c37c7dea9 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 95303 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (95303,6,'{"status":"ok","response":{"player":{"pid":95303,"title":"Qasim Akram","short_name":"Qasim Akram","first_name":"Qasim Akram","last_name":"","middle_name":"","birthdate":"2002-12-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/qasimakram07\/","twitter_profile":"https:\/\/x.com\/qasim_akram1122","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":4,"innings":3,"notout":0,"runs":41,"balls":45,"highest":20,"run100":0,"run50":0,"run4":6,"run6":0,"average":"13.66","strike":"91.11","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":70,"innings":58,"notout":8,"runs":1050,"balls":849,"highest":64,"run100":0,"run50":5,"run4":101,"run6":27,"average":"21.00","strike":"123.67","catches":29,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":59,"innings":56,"notout":7,"runs":1588,"balls":1675,"highest":131,"run100":2,"run50":9,"run4":155,"run6":25,"average":"32.40","strike":"94.80","catches":24,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":50,"notout":8,"runs":1893,"balls":3061,"highest":138,"run100":6,"run50":7,"run4":279,"run6":16,"average":"45.07","strike":"61.84","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"t20i":{"match_id":0,"inning_id":0,"matches":4,"innings":2,"balls":23,"overs":3.5,"runs":23,"wickets":3,"bestinning":"2\/5","bestmatch":"2\/5","econ":"6.00","average":"7.66","strike":"7.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":70,"innings":43,"balls":669,"overs":111.3,"runs":770,"wickets":35,"bestinning":"3\/6","bestmatch":"3\/6","econ":"6.90","average":"22.00","strike":"19.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":59,"innings":53,"balls":1863,"overs":310.3,"runs":1737,"wickets":47,"bestinning":"6\/26","bestmatch":"6\/26","econ":"5.59","average":"36.95","strike":"39.6","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":49,"balls":2944,"overs":490.4,"runs":1741,"wickets":43,"bestinning":"5\/51","bestmatch":"5\/60","econ":"3.54","average":"40.48","strike":"68.4","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"392d5c05c1c9897bdb79ae6f042bd6b7","modified":"2025-06-20 16:27:10","datetime":"2025-06-20 16:27:10","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":95303,"title":"Qasim Akram","short_name":"Qasim Akram","first_name":"Qasim Akram","last_name":"","middle_name":"","birthdate":"2002-12-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"https:\/\/www.facebook.com\/qasimakram07\/","twitter_profile":"https:\/\/x.com\/qasim_akram1122","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":4,"innings":3,"notout":0,"runs":41,"balls":45,"highest":20,"run100":0,"run50":0,"run4":6,"run6":0,"average":"13.66","strike":"91.11","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":70,"innings":58,"notout":8,"runs":1050,"balls":849,"highest":64,"run100":0,"run50":5,"run4":101,"run6":27,"average":"21.00","strike":"123.67","catches":29,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":59,"innings":56,"notout":7,"runs":1588,"balls":1675,"highest":131,"run100":2,"run50":9,"run4":155,"run6":25,"average":"32.40","strike":"94.80","catches":24,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":50,"notout":8,"runs":1893,"balls":3061,"highest":138,"run100":6,"run50":7,"run4":279,"run6":16,"average":"45.07","strike":"61.84","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"","innings":"","notout":"","runs":"","balls":"","highest":"","run100":"","run50":"","run4":"","run6":"","average":"","strike":"","catches":"","stumpings":""}},"bowling":{"t20i":{"match_id":0,"inning_id":0,"matches":4,"innings":2,"balls":23,"overs":3.5,"runs":23,"wickets":3,"bestinning":"2\/5","bestmatch":"2\/5","econ":"6.00","average":"7.66","strike":"7.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":70,"innings":43,"balls":669,"overs":111.3,"runs":770,"wickets":35,"bestinning":"3\/6","bestmatch":"3\/6","econ":"6.90","average":"22.00","strike":"19.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":59,"innings":53,"balls":1863,"overs":310.3,"runs":1737,"wickets":47,"bestinning":"6\/26","bestmatch":"6\/26","econ":"5.59","average":"36.95","strike":"39.6","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":49,"balls":2944,"overs":490.4,"runs":1741,"wickets":43,"bestinning":"5\/51","bestmatch":"5\/60","econ":"3.54","average":"40.48","strike":"68.4","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"392d5c05c1c9897bdb79ae6f042bd6b7","modified":"2025-06-20 16:27:10","datetime":"2025-06-20 16:27:10","api_version":"3.0"}', Modified = GetDate() WHERE Id = 95303 AND DataTypeId = 6 END
Player profile of Qasim Akram, Pakistan
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

Sri LankaSri Lanka485/10 (131.2 ov)

Bangladesh495/10 (153.4 ov) & *177/3 (57 ov)

 Stumps : Day 4 - Bangladesh lead by 187 runs.
LIVEToday1st Test

EnglandEngland

India*276/3 (69.5 ov)

 Day 1 - Session 3, England elected to bowl
LIVETodayMatch 11

Diamond DazzlersDiamond Dazzlers*10/1 (2 ov)

Alembic Warriors

 Rain Delay : Alembic Warriors elected to bowl
LIVETodayEliminator

Raigad RoyalsRaigad Royals

Kolhapur Tuskers*111/4 (15.5 ov)

 Raigad Royals elected to bowl
LIVETodayMatch 19

Lux Shyam Kolkata TigersLux Shyam Kolkata Tigers160/8 (20 ov)

Shrachi Rarh Tigers*73/2 (9.2 ov)

 Shrachi Rarh Tigers need 88 runs in 10.4 remaining overs
LIVETodayMatch 32

Warwickshire WomenWarwickshire Women172/6 (20 ov)

The Blaze*104/4 (14.1 ov)

 The Blaze need 69 runs in 35 remaining balls
LIVEToday6th T20I

ScotlandScotland193/5 (20 ov)

Nepal*67/4 (8.1 ov)

 Nepal need 127 runs in 11.5 remaining overs
LIVETodayMatch 17

Bhopal LeopardsBhopal Leopards

Gwalior Cheetahs*29/1 (3 ov)

 Rain Delay : Gwalior Cheetahs elected to bat
LIVETodayFinal

Anmol Kings HalarAnmol Kings Halar142/10 (19.4 ov)

JMD Kutch Riders*45/2 (7.2 ov)

 JMD Kutch Riders need 98 runs in 12.4 remaining overs
LIVETodayMatch 10

BohemiansBohemians122/4 (10 ov)

Prague Tigers*80/3 (4.4 ov)

 Prague Tigers need 43 runs in 32 remaining balls
LIVETodayFinal

Tally RangersTally Rangers

ACE KRM Panthers*110/3 (11 ov)

 ACE KRM Panthers elected to bat
LIVETodayMatch 28

Chicago Steelpan PlayersChicago Steelpan Players*0/0 ( ov)

SAMP Army Cocrico Cavaliers

 Rain Delay : SAMP Army Cocrico Cavaliers elected to bowl
Scheduled20 June Match 65

NorthamptonshireNorthamptonshire

Nottinghamshire

 
Scheduled20 June Match 67

GlamorganGlamorgan

Somerset

 
Scheduled20 June Match 69

DurhamDurham

Yorkshire

 
Scheduled20 June Match 64

SurreySurrey

Middlesex

 
Scheduled20 June Match 66

GloucestershireGloucestershire

Hampshire

 
Scheduled20 June Match 68

EssexEssex

Kent

 
CricDirect Cricket News, Results and Stats
 

Qasim Akram

NationalityPakistan
RoleAll Rounder
Born01 Dec 2002 (22)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 4 3 - 41 20 13.66 45 91.11 - -
T20I 70 58 8 1050 64 21.00 849 123.67 - 5
List A 59 56 7 1588 131 32.40 1675 94.80 2 9
1st Class 34 50 8 1893 138 45.07 3061 61.84 6 7

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20i 4 2 3.5 23 3 2/5 7.66 6.00 7.6 - -
T20 70 43 111.3 770 35 3/6 22.00 6.90 19.1 - -
List A 59 53 310.3 1737 47 6/26 36.95 5.59 39.6 - 1
1st Class 34 49 490.4 1741 43 5/51 40.48 3.54 68.4 1 1
× Close