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:caeb9121-ae51-42fe-89fe-fd47ba417648 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 44943 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (44943,6,'{"status":"ok","response":{"player":{"pid":44943,"title":"Batin Shah","short_name":"Batin Shah","first_name":"Batin Shah","last_name":"","middle_name":"","birthdate":"1991-05-10","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Afghanistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":15,"innings":8,"notout":5,"runs":93,"balls":62,"highest":43,"run100":0,"run50":0,"run4":9,"run6":5,"average":"31.00","strike":"150.00","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":7,"notout":4,"runs":26,"balls":33,"highest":11,"run100":0,"run50":0,"run4":2,"run6":0,"average":"8.66","strike":"78.78","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":19,"notout":0,"runs":244,"balls":332,"highest":43,"run100":0,"run50":0,"run4":13,"run6":22,"average":"12.84","strike":"73.49","catches":8,"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":15,"innings":14,"balls":283,"overs":47.1,"runs":452,"wickets":12,"bestinning":"2\/29","bestmatch":"2\/29","econ":"9.58","average":"37.66","strike":"23.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":10,"balls":441,"overs":73.3,"runs":435,"wickets":12,"bestinning":"3\/56","bestmatch":"3\/56","econ":"5.91","average":"36.25","strike":"36.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":20,"balls":1283,"overs":213.5,"runs":884,"wickets":19,"bestinning":"3\/28","bestmatch":"4\/66","econ":"4.13","average":"46.52","strike":"67.5","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":"9bf672217c59bba74549dc206bc9073c","modified":"2025-06-08 17:12:02","datetime":"2025-06-08 17:12:02","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":44943,"title":"Batin Shah","short_name":"Batin Shah","first_name":"Batin Shah","last_name":"","middle_name":"","birthdate":"1991-05-10","birthplace":"","country":"af","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Afghanistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":15,"innings":8,"notout":5,"runs":93,"balls":62,"highest":43,"run100":0,"run50":0,"run4":9,"run6":5,"average":"31.00","strike":"150.00","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":7,"notout":4,"runs":26,"balls":33,"highest":11,"run100":0,"run50":0,"run4":2,"run6":0,"average":"8.66","strike":"78.78","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":19,"notout":0,"runs":244,"balls":332,"highest":43,"run100":0,"run50":0,"run4":13,"run6":22,"average":"12.84","strike":"73.49","catches":8,"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":15,"innings":14,"balls":283,"overs":47.1,"runs":452,"wickets":12,"bestinning":"2\/29","bestmatch":"2\/29","econ":"9.58","average":"37.66","strike":"23.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":10,"balls":441,"overs":73.3,"runs":435,"wickets":12,"bestinning":"3\/56","bestmatch":"3\/56","econ":"5.91","average":"36.25","strike":"36.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":20,"balls":1283,"overs":213.5,"runs":884,"wickets":19,"bestinning":"3\/28","bestmatch":"4\/66","econ":"4.13","average":"46.52","strike":"67.5","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":"9bf672217c59bba74549dc206bc9073c","modified":"2025-06-08 17:12:02","datetime":"2025-06-08 17:12:02","api_version":"3.0"}', Modified = GetDate() WHERE Id = 44943 AND DataTypeId = 6 END
Player profile of Batin Shah, Afghanistan
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday2nd Unofficial Test

England LionsEngland Lions327/10 (89 ov)

India A348/10 (89.3 ov) & *60/1 (14 ov)

 Drinks Break : Day 3 - Session 3, India A lead by 81 runs.
LIVETodayMatch 5

Scorchers WomenScorchers Women

Dragons Women*245/6 (43.5 ov)

 Scorchers Women elected to bowl
LIVETodayMatch 77

ScotlandScotland323/6 (50 ov)

Nepal*163/5 (32 ov)

 Nepal need 161 runs in 18.0 remaining overs
LIVETodayMatch 17

Surrey WomenSurrey Women143/1 (12.5 ov)

Durham Women141/5 (20 ov)

 Surrey Women won by 9 wickets
LIVEToday2nd T20I

EnglandEngland*87/2 (10 ov)

West Indies196/6 (20 ov)

 England need 104 runs in 10.0 remaining overs
LIVETodayMatch 34

KentKent*158/2 (17.1 ov)

Hampshire177/7 (20 ov)

 Kent need 20 runs in 17 remaining balls
LIVETodayMatch 7

Ratnagiri JetsRatnagiri Jets*39/1 (4 ov)

Satara Warriors159/8 (20 ov)

 Ratnagiri Jets need 121 runs in 16.0 remaining overs
LIVETodayMatch 5

IDream Tiruppur TamizhansIDream Tiruppur Tamizhans*77/1 (10 ov)

Dindigul Dragons93/10 (16.2 ov)

 IDream Tiruppur Tamizhans need 17 runs in 10.0 remaining overs
LIVETodayMatch 31

YorkshireYorkshire213/7 (20 ov)

Leicestershire*14/0 (2.4 ov)

 Leicestershire need 200 runs in 17.2 remaining overs
LIVETodayMatch 5

South Africa ASouth Africa A

West Indies A

 Not Covered Live
LIVETodayMatch 20

Aakash Tigers MWSAakash Tigers MWS136/9 (20 ov)

SOBO Mumbai Falcons*36/0 (4.1 ov)

 SOBO Mumbai Falcons need 101 runs in 15.5 remaining overs
LIVETodayMatch 3

Anmol Kings HalarAnmol Kings Halar*35/2 (3.3 ov)

Dita Gohilwad Titans137/10 (19.5 ov)

 Anmol Kings Halar need 103 runs in 16.3 remaining overs
LIVETodayMatch 7

NECO Master BlasterNECO Master Blaster199/6 (20 ov)

Nagpur Heroz*5/0 (1 ov)

 Nagpur Heroz need 195 runs in 19.0 remaining overs
LIVETodayMatch 16

NevisNevis*106/6 (15.3 ov)

Combined Islands

 Nevis elected to bat
LIVETodayMatch 32

SussexSussex*179/3 (19.0 ov)

Glamorgan

 Sussex elected to bat
LIVETodayMatch 36

WarwickshireWarwickshire*153/4 (16.3 ov)

Derbyshire

 Derbyshire elected to bowl
Scheduled08 June Match 25

GATGAT

SBS CC

 
Scheduled08 June Match 17

Antigua and BarbudaAntigua and Barbuda

Anguilla

 
CricDirect Cricket News, Results and Stats
 

Batin Shah

NationalityAfghanistan
RoleBowler
Born10 May 1991 (34)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 15 8 5 93 43 31.00 62 150.00 - -
List A 10 7 4 26 11 8.66 33 78.78 - -
1st Class 13 19 - 244 43 12.84 332 73.49 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 15 14 47.1 452 12 2/29 37.66 9.58 23.5 - -
List A 10 10 73.3 435 12 3/56 36.25 5.91 36.7 - -
1st Class 13 20 213.5 884 19 3/28 46.52 4.13 67.5 - -
× Close