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:35c7ab09-1cf6-4aa6-9ef9-4d88e3e4716b Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 49833 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (49833,6,'{"status":"ok","response":{"player":{"pid":49833,"title":"Khalid Usman","short_name":"Khalid Usman","first_name":"Khalid Usman","last_name":"","middle_name":"","birthdate":"1986-03-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":{"t20":{"match_id":0,"inning_id":0,"matches":92,"innings":62,"notout":25,"runs":604,"balls":494,"highest":38,"run100":0,"run50":0,"run4":53,"run6":18,"average":"16.32","strike":"122.26","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":132,"innings":97,"notout":23,"runs":1800,"balls":2075,"highest":91,"run100":0,"run50":9,"run4":146,"run6":43,"average":"24.32","strike":"86.74","catches":63,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":127,"innings":201,"notout":39,"runs":4899,"balls":0,"highest":139,"run100":3,"run50":31,"run4":639,"run6":55,"average":"30.24","strike":"","catches":71,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"6","innings":"2","notout":"0","runs":"13","balls":"18","highest":"8","run100":"0","run50":"0","run4":"0","run6":"1","average":"6.50","strike":"72.22","catches":"4","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":92,"innings":88,"balls":1734,"overs":289,"runs":1999,"wickets":83,"bestinning":"5\/26","bestmatch":"5\/26","econ":"6.91","average":"24.08","strike":"20.8","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":132,"innings":128,"balls":6346,"overs":1057.4,"runs":4881,"wickets":179,"bestinning":"6\/15","bestmatch":"6\/15","econ":"4.61","average":"27.26","strike":"35.4","wicket4i":3,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":127,"innings":213,"balls":20418,"overs":3403,"runs":9600,"wickets":363,"bestinning":"8\/63","bestmatch":"11\/104","econ":"2.82","average":"26.44","strike":"56.2","wicket4i":16,"wicket5i":14,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"6","innings":"2","balls":"18","overs":"3","runs":"33","wickets":"1","bestinning":"1\/15","bestmatch":"1\/15","econ":"11.00","average":"33.00","strike":"18.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"5866c69f4a8436c8ff5545213b2e20f6","modified":"2025-06-18 14:42:54","datetime":"2025-06-18 14:42:54","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":49833,"title":"Khalid Usman","short_name":"Khalid Usman","first_name":"Khalid Usman","last_name":"","middle_name":"","birthdate":"1986-03-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","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":{"t20":{"match_id":0,"inning_id":0,"matches":92,"innings":62,"notout":25,"runs":604,"balls":494,"highest":38,"run100":0,"run50":0,"run4":53,"run6":18,"average":"16.32","strike":"122.26","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":132,"innings":97,"notout":23,"runs":1800,"balls":2075,"highest":91,"run100":0,"run50":9,"run4":146,"run6":43,"average":"24.32","strike":"86.74","catches":63,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":127,"innings":201,"notout":39,"runs":4899,"balls":0,"highest":139,"run100":3,"run50":31,"run4":639,"run6":55,"average":"30.24","strike":"","catches":71,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"6","innings":"2","notout":"0","runs":"13","balls":"18","highest":"8","run100":"0","run50":"0","run4":"0","run6":"1","average":"6.50","strike":"72.22","catches":"4","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":92,"innings":88,"balls":1734,"overs":289,"runs":1999,"wickets":83,"bestinning":"5\/26","bestmatch":"5\/26","econ":"6.91","average":"24.08","strike":"20.8","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":132,"innings":128,"balls":6346,"overs":1057.4,"runs":4881,"wickets":179,"bestinning":"6\/15","bestmatch":"6\/15","econ":"4.61","average":"27.26","strike":"35.4","wicket4i":3,"wicket5i":4,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":127,"innings":213,"balls":20418,"overs":3403,"runs":9600,"wickets":363,"bestinning":"8\/63","bestmatch":"11\/104","econ":"2.82","average":"26.44","strike":"56.2","wicket4i":16,"wicket5i":14,"wicket10m":2,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"6","innings":"2","balls":"18","overs":"3","runs":"33","wickets":"1","bestinning":"1\/15","bestmatch":"1\/15","econ":"11.00","average":"33.00","strike":"18.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"5866c69f4a8436c8ff5545213b2e20f6","modified":"2025-06-18 14:42:54","datetime":"2025-06-18 14:42:54","api_version":"3.0"}', Modified = GetDate() WHERE Id = 49833 AND DataTypeId = 6 END
Player profile of Khalid Usman, 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 Lanka

Bangladesh*484/9 (151 ov)

 Stumps : Day 2 - Bangladesh elected to bat
LIVETodayMatch 6

Dragons WomenDragons Women

Scorchers Women

 Not covered Live
LIVETodayMatch 28

Surrey WomenSurrey Women171/9 (20 ov)

Lancashire Women*11/1 (2.1 ov)

 Lancashire Women need 161 runs in 17.5 remaining overs
LIVETodayMatch 7

Pruthvi PanthersPruthvi Panthers

A4 Power Strikers

 Match delayed due to rain
LIVETodayMatch 27

Kolhapur TuskersKolhapur Tuskers

Satara Warriors

 Toss delayed due to wet outfield
LIVETodayMatch 15

Harbour DiamondsHarbour Diamonds

Lux Shyam Kolkata Tigers

 Toss delayed due to rain
LIVETodayMatch 16

Siechem Madurai PanthersSiechem Madurai Panthers*26/2 (3.5 ov)

Nellai Royal Kings

 Nellai Royal Kings elected to bowl
LIVEToday4th T20I

ScotlandScotland

Netherlands*85/2 (8.4 ov)

 Scotland elected to bowl
LIVETodayMatch 13

Jabalpur LionsJabalpur Lions

Chamble Ghariyals*14/1 (1.4 ov)

 Chamble Ghariyals elected to bat
LIVETodayMatch 20

JMD Kutch RidersJMD Kutch Riders

Zalwad Strikers*53/3 (8.5 ov)

 Zalwad Strikers elected to bat
LIVETodayMatch 5

BermudaBermuda

Cayman Islands*9/3 (1.5 ov)

 Bermuda elected to bowl
LIVETodayMatch 4

Munster RedsMunster Reds*0/0 (0.0 ov)

Northern Knights

 Northern Knights elected to bowl
Cancelled18 June Match 13

Adamas Howrah Warriors WomensAdamas Howrah Warriors Womens

Lux Shyam Kolkata Tigers Womens

 Match abandoned due to rain
CancelledTodayMatch 14

Shrachi Rarh TigersShrachi Rarh Tigers

Rashmi Medinipur Wizards

 Match abandoned due to rain
CancelledTodayMatch 14

Murshidabd Kueens WomensMurshidabd Kueens Womens

Servotech Siliguri Strikers Womens

 Match abandoned due to rain
CancelledTodayMatch 26

Raigad RoyalsRaigad Royals111/6 (14 ov)

Eagle Nashik Titans

 Match abondoned due to rain
ScheduledTodayFinal

Prague Spartans CCPrague Spartans CC

Vinohrady CC

 
Scheduled18 June Match 22

Leatherback StrikersLeatherback Strikers

Soca Kings

 
CricDirect Cricket News, Results and Stats
 

Khalid Usman

NationalityPakistan
RoleAll Rounder
Born01 Mar 1986 (39)
Batting StyleRight Hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 92 62 25 604 38 16.32 494 122.26 - -
List A 132 97 23 1800 91 24.32 2075 86.74 - 9
1st Class 127 201 39 4899 139 30.24 - - 3 31

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 92 88 289 1999 83 5/26 24.08 6.91 20.8 - 1
List A 132 128 1057.4 4881 179 6/15 27.26 4.61 35.4 3 4
1st Class 127 213 3403 9600 363 8/63 26.44 2.82 56.2 16 14
× Close