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:1421230a-d58c-43df-bba8-ef6744ecd49d Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53415 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53415,6,'{"status":"ok","response":{"player":{"pid":53415,"title":"Usman Ashraf","short_name":"Usman Ashraf","first_name":"Usman Ashraf","last_name":"","middle_name":"","birthdate":"1989-12-15","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"notout":0,"runs":0,"balls":1,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"0.00","strike":"0.00","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":11,"innings":9,"notout":3,"runs":175,"balls":215,"highest":37,"run100":0,"run50":0,"run4":13,"run6":3,"average":"29.16","strike":"81.39","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":12,"innings":22,"notout":1,"runs":364,"balls":761,"highest":86,"run100":0,"run50":1,"run4":46,"run6":3,"average":"17.33","strike":"47.83","catches":2,"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":{"t20":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"balls":10,"overs":1.4,"runs":14,"wickets":0,"bestinning":"","bestmatch":"","econ":"8.40","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":11,"innings":10,"balls":343,"overs":57.1,"runs":332,"wickets":6,"bestinning":"3\/39","bestmatch":"3\/39","econ":"5.80","average":"55.33","strike":"57.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":12,"innings":14,"balls":876,"overs":146,"runs":490,"wickets":19,"bestinning":"4\/38","bestmatch":"4\/38","econ":"3.35","average":"25.78","strike":"46.1","wicket4i":1,"wicket5i":0,"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":"db6e876668049ea8970db35dd6917743","modified":"2025-07-27 14:27:48","datetime":"2025-07-27 14:27:48","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53415,"title":"Usman Ashraf","short_name":"Usman Ashraf","first_name":"Usman Ashraf","last_name":"","middle_name":"","birthdate":"1989-12-15","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"notout":0,"runs":0,"balls":1,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"0.00","strike":"0.00","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":11,"innings":9,"notout":3,"runs":175,"balls":215,"highest":37,"run100":0,"run50":0,"run4":13,"run6":3,"average":"29.16","strike":"81.39","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":12,"innings":22,"notout":1,"runs":364,"balls":761,"highest":86,"run100":0,"run50":1,"run4":46,"run6":3,"average":"17.33","strike":"47.83","catches":2,"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":{"t20":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"balls":10,"overs":1.4,"runs":14,"wickets":0,"bestinning":"","bestmatch":"","econ":"8.40","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":11,"innings":10,"balls":343,"overs":57.1,"runs":332,"wickets":6,"bestinning":"3\/39","bestmatch":"3\/39","econ":"5.80","average":"55.33","strike":"57.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":12,"innings":14,"balls":876,"overs":146,"runs":490,"wickets":19,"bestinning":"4\/38","bestmatch":"4\/38","econ":"3.35","average":"25.78","strike":"46.1","wicket4i":1,"wicket5i":0,"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":"db6e876668049ea8970db35dd6917743","modified":"2025-07-27 14:27:48","datetime":"2025-07-27 14:27:48","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53415 AND DataTypeId = 6 END
Player profile of Usman Ashraf, Pakistan
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday4th Test

EnglandEngland669/10 (157.1 ov)

India358/10 (114.1 ov) & *314/4 (113 ov)

 Day 5 - Session 2, India lead by 3 runs.
LIVETodayMatch 18

United Arab EmiratesUnited Arab Emirates162/9 (20 ov)

Uganda170/7 (20 ov)

 Uganda won by 8 runs
LIVETodayFinal

BahrainBahrain189/3 (20 ov)

Malawi95/10 (17.3 ov)

 Bahrain won by 94 runs
LIVEToday1st Semi-Final

The Blaze WomenThe Blaze Women143/10 (19.1 ov)

Warwickshire Women163/8 (20 ov)

 Warwickshire Women won by 20 runs
LIVETodayMatch 12

South Africa ChampionsSouth Africa Champions241/6 (20 ov)

Australia Champions*146/10 (16.4 ov)

 Australia Champions need 96 runs in 20 remaining balls
LIVETodayFinal

Villianur Mohit KingsVillianur Mohit Kings

Mahe Megalo Strikers*89/4 (12.2 ov)

 Villianur Mohit Kings elected to bowl
LIVETodayFinal

Gauhati Town ClubGauhati Town Club*9/0 (0.5 ov)

Guwahati Giants87/2 (6 ov)

 Gauhati Town Club need 79 runs in 31 remaining balls
LIVETodayMatch 2

West Indies Women Under-19sWest Indies Women Under-19s

United States of America Women Under-19s*44/0 (6.5 ov)

 West Indies Women Under-19s elected to bowl
LIVETodayFinal

Alby Zalmi CFAlby Zalmi CF

Huddinge

 Huddinge elected to bat
CancelledTodayFinal

AustriaAustria182/3 (16 ov)

Romania

 Match abandoned due to rain
CancelledTodayMatch 5

Navarang ClubNavarang Club0/0 ( ov)

City Cricket Club58/1 (6 ov)

 Match abandoned due to rain
Scheduled27 July Final

Surrey WomenSurrey Women

TBA

 
Scheduled27 July Match 13

India ChampionsIndia Champions

England Champions

 
Scheduled27 July Match 29

Chennai Kings CAChennai Kings CA

Tally Rangers

 
Scheduled28 July 1st Semi-Final

Maxx Cricket ClubMaxx Cricket Club

Sky Warriors Cricket

 
Scheduled28 July 2nd Semi-Final

MR KB PutrajayaMR KB Putrajaya

Fatemi Resources Cricket Club

 
Scheduled28 July Match 1

Gauhati Town ClubGauhati Town Club

Bud CC

 
Scheduled28 July Match 15

Band-e-Amir DragonsBand-e-Amir Dragons

Boost Defenders

 
CricDirect Cricket News, Results and Stats
 

Usman Ashraf

NationalityPakistan
RoleBatter
Born15 Dec 1989 (35)
Batting StyleRight Hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 1 1 - - - 0.00 1 0.00 - -
List A 11 9 3 175 37 29.16 215 81.39 - -
1st Class 12 22 1 364 86 17.33 761 47.83 - 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 1 1 1.4 14 - - - 8.40 - - -
List A 11 10 57.1 332 6 3/39 55.33 5.80 57.1 - -
1st Class 12 14 146 490 19 4/38 25.78 3.35 46.1 1 -
× Close