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:a2eeab7c-8d89-4975-a8ee-1fb52f544716 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 95357 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (95357,6,'{"status":"ok","response":{"player":{"pid":95357,"title":"Arshad Hayat","short_name":"Arshad Hayat","first_name":"Arshad Hayat","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"cz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Czech Republic"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":7,"innings":2,"notout":0,"runs":2,"balls":7,"highest":2,"run100":0,"run50":0,"run4":0,"run6":0,"average":"1.00","strike":"28.57","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":2,"notout":0,"runs":2,"balls":7,"highest":2,"run100":0,"run50":0,"run4":0,"run6":0,"average":"1.00","strike":"28.57","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"11","innings":"8","notout":"2","runs":"87","balls":"58","highest":"27","run100":"0","run50":"0","run4":"3","run6":"6","average":"14.50","strike":"150.00","catches":"2","stumpings":"0"}},"bowling":{"t20i":{"match_id":0,"inning_id":0,"matches":7,"innings":5,"balls":60,"overs":10,"runs":103,"wickets":5,"bestinning":"2\/15","bestmatch":"2\/15","econ":"10.30","average":"20.60","strike":"12.00","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":5,"balls":60,"overs":10,"runs":103,"wickets":5,"bestinning":"2\/15","bestmatch":"2\/15","econ":"10.30","average":"20.60","strike":"12.00","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"11","innings":"11","balls":"120","overs":"20","runs":"139","wickets":"20","bestinning":"3\/13","bestmatch":"3\/13","econ":"6.95","average":"6.95","strike":"6.00","wicket4i":"1","wicket5i":"0","wicket10m":"0"}}},"etag":"a31029e409e7b447156a47541e25e6c3","modified":"2025-06-07 17:19:05","datetime":"2025-06-07 17:19:05","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":95357,"title":"Arshad Hayat","short_name":"Arshad Hayat","first_name":"Arshad Hayat","last_name":"","middle_name":"","birthdate":"","birthplace":"","country":"cz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Czech Republic"},"batting":{"t20i":{"match_id":0,"inning_id":0,"matches":7,"innings":2,"notout":0,"runs":2,"balls":7,"highest":2,"run100":0,"run50":0,"run4":0,"run6":0,"average":"1.00","strike":"28.57","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":2,"notout":0,"runs":2,"balls":7,"highest":2,"run100":0,"run50":0,"run4":0,"run6":0,"average":"1.00","strike":"28.57","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"11","innings":"8","notout":"2","runs":"87","balls":"58","highest":"27","run100":"0","run50":"0","run4":"3","run6":"6","average":"14.50","strike":"150.00","catches":"2","stumpings":"0"}},"bowling":{"t20i":{"match_id":0,"inning_id":0,"matches":7,"innings":5,"balls":60,"overs":10,"runs":103,"wickets":5,"bestinning":"2\/15","bestmatch":"2\/15","econ":"10.30","average":"20.60","strike":"12.00","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":5,"balls":60,"overs":10,"runs":103,"wickets":5,"bestinning":"2\/15","bestmatch":"2\/15","econ":"10.30","average":"20.60","strike":"12.00","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"11","innings":"11","balls":"120","overs":"20","runs":"139","wickets":"20","bestinning":"3\/13","bestmatch":"3\/13","econ":"6.95","average":"6.95","strike":"6.00","wicket4i":"1","wicket5i":"0","wicket10m":"0"}}},"etag":"a31029e409e7b447156a47541e25e6c3","modified":"2025-06-07 17:19:05","datetime":"2025-06-07 17:19:05","api_version":"3.0"}', Modified = GetDate() WHERE Id = 95357 AND DataTypeId = 6 END
Player profile of Arshad Hayat, Czech Republic
<>
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*58/1 (7.3 ov)

West Indies Women106/8 (21 ov)

 England Women need 48 runs in 13.3 remaining overs
LIVETodayMatch 6

Raigad RoyalsRaigad Royals103/10 (13.1 ov)

Puneri Bappa202/4 (20 ov)

 Puneri Bappa won by 99 runs
LIVETodayMatch 16

SOBO Mumbai FalconsSOBO Mumbai Falcons*76/4 (6.3 ov)

Eagle Thane Strikers151/8 (20 ov)

 SOBO Mumbai Falcons need 76 runs in 13.3 remaining overs
LIVETodayMatch 5

Pagariya StrikersPagariya Strikers*138/3 (14 ov)

Bharat Rangers169/9 (20 ov)

 Pagariya Strikers need 32 runs in 36 remaining balls
LIVETodayMatch 13

NevisNevis*29/0 (3 ov)

St Kitts115/10 (20 ov)

 Nevis need 87 runs in 17.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

 
Scheduled08 June Match 5

Solapur Smashers WomenSolapur Smashers Women

Raigad Royals Women

 
CricDirect Cricket News, Results and Stats
 

Arshad Hayat

NationalityCzech Republic
RoleAll Rounder
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 7 2 - 2 2 1.00 7 28.57 - -
T20I 7 2 - 2 2 1.00 7 28.57 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20i 7 5 10 103 5 2/15 20.60 10.30 12.00 - -
T20 7 5 10 103 5 2/15 20.60 10.30 12.00 - -
× Close