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:5dac15d8-abeb-402b-b198-0ed116dfb399 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 45405 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (45405,6,'{"status":"ok","response":{"player":{"pid":45405,"title":"Zeeshan Ashraf","short_name":"Zeeshan Ashraf","first_name":"Zeeshan Ashraf","last_name":"","middle_name":"","birthdate":"1992-05-11","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":72,"innings":68,"notout":5,"runs":1087,"balls":879,"highest":73,"run100":0,"run50":6,"run4":114,"run6":38,"average":"17.25","strike":"123.66","catches":25,"stumpings":3,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":35,"innings":35,"notout":1,"runs":968,"balls":1070,"highest":166,"run100":1,"run50":6,"run4":134,"run6":12,"average":"28.47","strike":"90.46","catches":18,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":37,"innings":64,"notout":0,"runs":1963,"balls":3180,"highest":145,"run100":7,"run50":5,"run4":262,"run6":40,"average":"30.67","strike":"61.72","catches":17,"stumpings":1,"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":72,"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":35,"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},"firstclass":{"match_id":0,"inning_id":0,"matches":37,"innings":1,"balls":6,"overs":1,"runs":1,"wickets":0,"bestinning":"","bestmatch":"","econ":"1.00","average":"","strike":"","wicket4i":0,"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":"a7377cf254d7ca0991c10af3d292cfbf","modified":"2025-06-11 10:53:37","datetime":"2025-06-11 10:53:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":45405,"title":"Zeeshan Ashraf","short_name":"Zeeshan Ashraf","first_name":"Zeeshan Ashraf","last_name":"","middle_name":"","birthdate":"1992-05-11","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":72,"innings":68,"notout":5,"runs":1087,"balls":879,"highest":73,"run100":0,"run50":6,"run4":114,"run6":38,"average":"17.25","strike":"123.66","catches":25,"stumpings":3,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":35,"innings":35,"notout":1,"runs":968,"balls":1070,"highest":166,"run100":1,"run50":6,"run4":134,"run6":12,"average":"28.47","strike":"90.46","catches":18,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":37,"innings":64,"notout":0,"runs":1963,"balls":3180,"highest":145,"run100":7,"run50":5,"run4":262,"run6":40,"average":"30.67","strike":"61.72","catches":17,"stumpings":1,"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":72,"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":35,"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},"firstclass":{"match_id":0,"inning_id":0,"matches":37,"innings":1,"balls":6,"overs":1,"runs":1,"wickets":0,"bestinning":"","bestmatch":"","econ":"1.00","average":"","strike":"","wicket4i":0,"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":"a7377cf254d7ca0991c10af3d292cfbf","modified":"2025-06-11 10:53:37","datetime":"2025-06-11 10:53:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 45405 AND DataTypeId = 6 END
Player profile of Zeeshan Ashraf, Pakistan
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVETodayMatch 5

South Africa ASouth Africa A*324/7 (102 ov)

West Indies A220/10 (68.1 ov)

 Stumps : Day 2 - South Africa A lead by 104 runs.
LIVETodayMatch 1

Czechia WomenCzechia Women*72/4 (13.4 ov)

Gibraltar Women161/0 (20 ov)

 Czechia Women need 90 runs in 38 remaining balls
LIVETodayMatch 10

Solapur Smashers WomenSolapur Smashers Women169/2 (20 ov)

Raigad Royals Women*54/4 (8 ov)

 Raigad Royals Women need 116 runs in 12.0 remaining overs
LIVETodayMatch 12

Bharat RangersBharat Rangers166/5 (20 ov)

Nagpur Heroz

 Innings Break : Bharat Rangers elected to bat
LIVETodayFinal

South AfricaSouth Africa

Australia*41/2 (16.1 ov)

 Day 1 - Session 1, South Africa elected to bowl
LIVETodayMatch 7

Anmol Kings HalarAnmol Kings Halar*132/4 (16.4 ov)

JMD Kutch Riders

 Anmol Kings Halar elected to bat
LIVETodayMatch 4

Netherlands WomenNetherlands Women*75/3 (12.2 ov)

United States of America Women

 United States of America Women elected to bowl
LIVETodayMatch 37

CFS Pinnacle ProCFS Pinnacle Pro*33/0 (1.3 ov)

East Londoners

 CFS Pinnacle Pro elected to bat
ScheduledTodayMatch 31

Cameroon WomenCameroon Women

Brazil Women

 
ScheduledTodayMatch 32

Zimbabwe HPC WomenZimbabwe HPC Women

Sierra Leone Women

 
Scheduled11 June Match 2

Gibraltar WomenGibraltar Women

Austria Women

 
Scheduled11 June Match 38

CFS Pinnacle ProCFS Pinnacle Pro

Gagan

 
Scheduled11 June Match 18

Durham WomenDurham Women

Warwickshire Women

 
Scheduled11 June Match 12

Kolhapur TuskersKolhapur Tuskers

Puneri Bappa

 
Scheduled11 June Match 8

Lyca Kovai KingsLyca Kovai Kings

Siechem Madurai Panthers

 
Scheduled11 June 1st ODI

West Indies WomenWest Indies Women

South Africa Women

 
Scheduled11 June Match 8

Aryan Sorath LionsAryan Sorath Lions

Zalwad Strikers

 
Scheduled11 June Match 13

Pagariya StrikersPagariya Strikers

NECO Master Blaster

 
CricDirect Cricket News, Results and Stats
 

Zeeshan Ashraf

NationalityPakistan
Role
Born11 May 1992 (33)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 72 68 5 1087 73 17.25 879 123.66 - 6
List A 35 35 1 968 166 28.47 1070 90.46 1 6
1st Class 37 64 - 1963 145 30.67 3180 61.72 7 5

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 72 - - - - - - - - - -
List A 35 - - - - - - - - - -
1st Class 37 1 1 1 - - - 1.00 - - -
× Close