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:356a5f31-3f14-4f12-9fa6-f5a51a742102 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90826 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90826,6,'{"status":"ok","response":{"player":{"pid":90826,"title":"Bilal Shah","short_name":"Bilal Shah","first_name":"Bilal Shah","last_name":"","middle_name":"","birthdate":"1998-03-24","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"notout":1,"runs":1,"balls":1,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"100.00","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"notout":1,"runs":1,"balls":1,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"100.00","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":5,"notout":3,"runs":2,"balls":9,"highest":2,"run100":0,"run50":0,"run4":0,"run6":0,"average":"1.00","strike":"22.22","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":2,"innings":4,"notout":2,"runs":1,"balls":13,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"0.50","strike":"7.69","catches":0,"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":{"t20i":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"balls":12,"overs":2,"runs":18,"wickets":0,"bestinning":"","bestmatch":"","econ":"9.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"balls":12,"overs":2,"runs":18,"wickets":0,"bestinning":"","bestmatch":"","econ":"9.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":7,"balls":312,"overs":52,"runs":339,"wickets":11,"bestinning":"3\/75","bestmatch":"3\/75","econ":"6.51","average":"30.81","strike":"28.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":2,"innings":4,"balls":168,"overs":28,"runs":88,"wickets":0,"bestinning":"","bestmatch":"","econ":"3.14","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":"8008849ff2c2bca3699939f521a3d5d4","modified":"2025-06-07 17:08:01","datetime":"2025-06-07 17:08:01","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":90826,"title":"Bilal Shah","short_name":"Bilal Shah","first_name":"Bilal Shah","last_name":"","middle_name":"","birthdate":"1998-03-24","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"notout":1,"runs":1,"balls":1,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"100.00","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"notout":1,"runs":1,"balls":1,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"100.00","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":5,"notout":3,"runs":2,"balls":9,"highest":2,"run100":0,"run50":0,"run4":0,"run6":0,"average":"1.00","strike":"22.22","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":2,"innings":4,"notout":2,"runs":1,"balls":13,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"0.50","strike":"7.69","catches":0,"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":{"t20i":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"balls":12,"overs":2,"runs":18,"wickets":0,"bestinning":"","bestmatch":"","econ":"9.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":1,"innings":1,"balls":12,"overs":2,"runs":18,"wickets":0,"bestinning":"","bestmatch":"","econ":"9.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":7,"balls":312,"overs":52,"runs":339,"wickets":11,"bestinning":"3\/75","bestmatch":"3\/75","econ":"6.51","average":"30.81","strike":"28.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":2,"innings":4,"balls":168,"overs":28,"runs":88,"wickets":0,"bestinning":"","bestmatch":"","econ":"3.14","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":"8008849ff2c2bca3699939f521a3d5d4","modified":"2025-06-07 17:08:01","datetime":"2025-06-07 17:08:01","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90826 AND DataTypeId = 6 END
Player profile of Bilal Shah, Pakistan
<>
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 Lions*192/3 (46 ov)

India A348/10 (89.3 ov)

 Stumps : Day 2 - England Lions trail by 156 runs.
LIVEToday3rd ODI

England WomenEngland Women*40/1 (5.1 ov)

West Indies Women106/8 (21 ov)

 England Women need 66 runs in 15.5 remaining overs
LIVETodayMatch 6

Raigad RoyalsRaigad Royals*82/8 (12 ov)

Puneri Bappa202/4 (20 ov)

 Raigad Royals need 121 runs in 48 remaining balls
LIVETodayMatch 3

Nellai Royal KingsNellai Royal Kings*147/5 (18 ov)

Trichy Grand Chola157/8 (20 ov)

 Nellai Royal Kings need 11 runs in 12 remaining balls
LIVETodayMatch 16

SOBO Mumbai FalconsSOBO Mumbai Falcons*57/3 (5 ov)

Eagle Thane Strikers151/8 (20 ov)

 SOBO Mumbai Falcons need 95 runs in 15.0 remaining overs
LIVETodayMatch 5

Pagariya StrikersPagariya Strikers*118/3 (12.3 ov)

Bharat Rangers169/9 (20 ov)

 Pagariya Strikers need 52 runs in 45 remaining balls
LIVETodayMatch 13

NevisNevis0/0 (0.0 ov)

St Kitts115/10 (20 ov)

 Innings Break : Nevis need 116 runs in 20.0 remaining overs
LIVETodayMatch 5

Upminster-WUpminster-W*0/0 ( ov)

Gunnersbury-W

 Match Start Delay : Gunnersbury-W elected to bowl
LIVETodayMatch 24

Tally RangersTally Rangers

Cochin Hurricanes

  Tally Rangers won the toss and elected to bat
Cancelled07 June Match 13

Triumph Knights MNETriumph Knights MNE*20/1 (3 ov)

Namo Bandra Blasters192/7 (20 ov)

 Match abandoned
CancelledTodayMatch 1

Upminster-WUpminster-W0/0 ( ov)

Hutton-W66/0 (6 ov)

 Match abandoned due to rain
CancelledTodayMatch 4

Nagpur TitansNagpur Titans

NECO Master Blaster

 Match Abandoned
CancelledTodayMatch 1

Netherlands WomenNetherlands Women

United States of America Women

 Match abandoned due to rain
CancelledTodayMatch 15

The BlazeThe Blaze

Somerset Women0/0 ( ov)

 Match Abandoned
ScheduledTodayMatch 30

NottinghamshireNottinghamshire

Worcestershire

 
Scheduled07 June Match 14

Combined IslandsCombined Islands

Anguilla

 
Scheduled07 June Match 15

Virgin IslandsVirgin Islands

Antigua and Barbuda

 
Scheduled08 June 3rd Place Play-off

China WomenChina Women

Philippines Women

 
CricDirect Cricket News, Results and Stats
 

Bilal Shah

NationalityPakistan
RoleBatter
Born24 Mar 1998 (27)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 1 1 1 1 1 - 1 100.00 - -
T20I 1 1 1 1 1 - 1 100.00 - -
List A 8 5 3 2 2 1.00 9 22.22 - -
1st Class 2 4 2 1 1 0.50 13 7.69 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20i 1 1 2 18 - - - 9.00 - - -
T20 1 1 2 18 - - - 9.00 - - -
List A 8 7 52 339 11 3/75 30.81 6.51 28.3 - -
1st Class 2 4 28 88 - - - 3.14 - - -
× Close