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:bbe01480-4a7d-4d4a-9754-364113528d5f Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53241 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53241,6,'{"status":"ok","response":{"player":{"pid":53241,"title":"Asim Kamal","short_name":"Asim Kamal","first_name":"Asim Kamal","last_name":"","middle_name":"","birthdate":"1976-05-31","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":12,"innings":20,"notout":1,"runs":717,"balls":1518,"highest":99,"run100":0,"run50":8,"run4":104,"run6":6,"average":"37.73","strike":"47.23","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":8,"innings":7,"notout":1,"runs":151,"balls":111,"highest":49,"run100":0,"run50":0,"run4":18,"run6":3,"average":"25.16","strike":"136.03","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":36,"innings":31,"notout":4,"runs":850,"balls":0,"highest":63,"run100":0,"run50":6,"run4":0,"run6":0,"average":"31.48","strike":"","catches":12,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":134,"innings":217,"notout":21,"runs":6683,"balls":0,"highest":164,"run100":11,"run50":42,"run4":0,"run6":0,"average":"34.09","strike":"","catches":94,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"10","notout":"6","runs":"13","balls":"20","highest":"6","run100":"0","run50":"0","run4":"0","run6":"1","average":"3.25","strike":"65.00","catches":"5","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":12,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":8,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":36,"innings":0,"balls":12,"overs":2,"runs":30,"wickets":0,"bestinning":"","bestmatch":"","econ":"15.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":134,"innings":0,"balls":135,"overs":22.3,"runs":95,"wickets":2,"bestinning":"1\/6","bestmatch":"","econ":"4.22","average":"47.50","strike":"67.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"15","balls":"153","overs":"25.3","runs":"189","wickets":"18","bestinning":"4\/10","bestmatch":"4\/10","econ":"7.41","average":"10.50","strike":"8.50","wicket4i":"2","wicket5i":"0","wicket10m":"0"}}},"etag":"b5a235a6a1c1dfaf0b6ff1df1502e69b","modified":"2025-06-14 16:40:09","datetime":"2025-06-14 16:40:09","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53241,"title":"Asim Kamal","short_name":"Asim Kamal","first_name":"Asim Kamal","last_name":"","middle_name":"","birthdate":"1976-05-31","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":12,"innings":20,"notout":1,"runs":717,"balls":1518,"highest":99,"run100":0,"run50":8,"run4":104,"run6":6,"average":"37.73","strike":"47.23","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":8,"innings":7,"notout":1,"runs":151,"balls":111,"highest":49,"run100":0,"run50":0,"run4":18,"run6":3,"average":"25.16","strike":"136.03","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":36,"innings":31,"notout":4,"runs":850,"balls":0,"highest":63,"run100":0,"run50":6,"run4":0,"run6":0,"average":"31.48","strike":"","catches":12,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":134,"innings":217,"notout":21,"runs":6683,"balls":0,"highest":164,"run100":11,"run50":42,"run4":0,"run6":0,"average":"34.09","strike":"","catches":94,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"10","notout":"6","runs":"13","balls":"20","highest":"6","run100":"0","run50":"0","run4":"0","run6":"1","average":"3.25","strike":"65.00","catches":"5","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":12,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":8,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":36,"innings":0,"balls":12,"overs":2,"runs":30,"wickets":0,"bestinning":"","bestmatch":"","econ":"15.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":134,"innings":0,"balls":135,"overs":22.3,"runs":95,"wickets":2,"bestinning":"1\/6","bestmatch":"","econ":"4.22","average":"47.50","strike":"67.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"15","innings":"15","balls":"153","overs":"25.3","runs":"189","wickets":"18","bestinning":"4\/10","bestmatch":"4\/10","econ":"7.41","average":"10.50","strike":"8.50","wicket4i":"2","wicket5i":"0","wicket10m":"0"}}},"etag":"b5a235a6a1c1dfaf0b6ff1df1502e69b","modified":"2025-06-14 16:40:09","datetime":"2025-06-14 16:40:09","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53241 AND DataTypeId = 6 END
Player profile of Asim Kamal, Pakistan
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVETodayFinal

Solapur Smashers WomenSolapur Smashers Women

Pune Warriors Women*112/3 (16 ov)

 Solapur Smashers Women elected to bowl
LIVETodayMatch 7

Servotech Siliguri StrikersServotech Siliguri Strikers133/8 (20 ov)

Rashmi Medinipur Wizards*105/1 (15 ov)

 Rashmi Medinipur Wizards need 29 runs in 30 remaining balls
LIVETodayMatch 11

Dindigul DragonsDindigul Dragons*128/1 (10.5 ov)

Siechem Madurai Panthers150/8 (20 ov)

 Dindigul Dragons need 23 runs in 55 remaining balls
LIVETodayMatch 51

DerbyshireDerbyshire*174/3 (16.5 ov)

Leicestershire196/5 (20 ov)

 Derbyshire need 23 runs in 19 remaining balls
LIVEToday2nd ODI

West Indies WomenWest Indies Women

South Africa Women*211/5 (40.5 ov)

 West Indies Women elected to bowl
LIVETodayMatch 5

Indore Pink PanthersIndore Pink Panthers183/7 (20 ov)

Jabalpur Lions*88/2 (8.5 ov)

 Jabalpur Lions need 96 runs in 11.1 remaining overs
LIVETodayMatch 9

Hutton-WHutton-W72/6 (10 ov)

Gunnersbury-W*76/3 (6 ov)

 Match completed
LIVETodayMatch 5

Czechia WomenCzechia Women88/5 (10 ov)

Croatia Women*26/1 (2 ov)

 Croatia Women need 63 runs in 48 remaining balls
LIVETodayMatch 11

Leatherback StrikersLeatherback Strikers

SAMP Army Cocrico Cavaliers*97/2 (6 ov)

 Leatherback Strikers elected to bowl
LIVETodayMatch 10

Upminster-WUpminster-W

Gunnersbury-W

 Upminster-W won the toss and elected to field
Cancelled14 June Match 5

IndonesiaIndonesia*26/0 (4 ov)

Cambodia210/4 (20 ov)

 Match Abandoned
CancelledToday2nd T20I

IrelandIreland

West Indies

 Match Abandoned
CancelledTodayMatch 13

Anmol Kings HalarAnmol Kings Halar

JMD Kutch Riders0/0 ( ov)

 Match Abandoned
ScheduledTodayMatch 50

GlamorganGlamorgan

Sussex

 
ScheduledTodayMatch 3

Thunder Cats-BThunder Cats-B

Gulf Cable

 
Scheduled14 June Match 52

WarwickshireWarwickshire

Nottinghamshire

 
Scheduled14 June Match 12

Chicago Steelpan PlayersChicago Steelpan Players

Scarlet Ibis Scorchers

 
Scheduled14 June Match 3

San Francisco UnicornsSan Francisco Unicorns

Los Angeles Knight Riders

 
CricDirect Cricket News, Results and Stats
 

Asim Kamal

NationalityPakistan
RoleBowler
Born31 May 1976 (49)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 12 20 1 717 99 37.73 1518 47.23 - 8
T20I 8 7 1 151 49 25.16 111 136.03 - -
List A 36 31 4 850 63 31.48 - - - 6
1st Class 134 217 21 6683 164 34.09 - - 11 42

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 12 - - - - - - - - - -
T20 8 - - - - - - - - - -
List A 36 - 2 30 - - - 15.00 - - -
1st Class 134 - 22.3 95 2 1/6 47.50 4.22 67.5 - -
× Close