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:b1e64a05-73ae-4c2e-bf4c-52f35abc08fd Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 50666 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (50666,6,'{"status":"ok","response":{"player":{"pid":50666,"title":"Harry Dearden","short_name":"HE Dearden","first_name":"Harry Dearden","last_name":"","middle_name":"","birthdate":"1997-05-07","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":22,"innings":21,"notout":3,"runs":348,"balls":332,"highest":61,"run100":0,"run50":1,"run4":24,"run6":8,"average":"19.33","strike":"104.81","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":10,"notout":0,"runs":341,"balls":379,"highest":91,"run100":0,"run50":3,"run4":48,"run6":0,"average":"34.10","strike":"89.97","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":45,"innings":78,"notout":2,"runs":1629,"balls":3680,"highest":87,"run100":0,"run50":8,"run4":230,"run6":5,"average":"21.43","strike":"44.26","catches":29,"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":22,"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":10,"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":45,"innings":9,"balls":129,"overs":21.3,"runs":116,"wickets":2,"bestinning":"1\/0","bestmatch":"1\/0","econ":"5.39","average":"58.00","strike":"64.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":"906c7ed696a7ca72b4a3ecfa32a04cd3","modified":"2025-06-10 10:23:29","datetime":"2025-06-10 10:23:29","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":50666,"title":"Harry Dearden","short_name":"HE Dearden","first_name":"Harry Dearden","last_name":"","middle_name":"","birthdate":"1997-05-07","birthplace":"","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":22,"innings":21,"notout":3,"runs":348,"balls":332,"highest":61,"run100":0,"run50":1,"run4":24,"run6":8,"average":"19.33","strike":"104.81","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":10,"innings":10,"notout":0,"runs":341,"balls":379,"highest":91,"run100":0,"run50":3,"run4":48,"run6":0,"average":"34.10","strike":"89.97","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":45,"innings":78,"notout":2,"runs":1629,"balls":3680,"highest":87,"run100":0,"run50":8,"run4":230,"run6":5,"average":"21.43","strike":"44.26","catches":29,"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":22,"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":10,"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":45,"innings":9,"balls":129,"overs":21.3,"runs":116,"wickets":2,"bestinning":"1\/0","bestmatch":"1\/0","econ":"5.39","average":"58.00","strike":"64.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":"906c7ed696a7ca72b4a3ecfa32a04cd3","modified":"2025-06-10 10:23:29","datetime":"2025-06-10 10:23:29","api_version":"3.0"}', Modified = GetDate() WHERE Id = 50666 AND DataTypeId = 6 END
Player profile of Harry Dearden, England
<>
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 25

Uganda WomenUganda Women99/6 (20 ov)

Tanzania Women*79/9 (17.5 ov)

 Tanzania Women need 21 runs in 13 remaining balls
LIVETodayMatch 26

Nigeria WomenNigeria Women107/10 (19.3 ov)

Malawi Women*37/5 (13.1 ov)

 Malawi Women need 71 runs in 41 remaining balls
LIVETodayMatch 5

CzechiaCzechia*6/1 (1.2 ov)

Norway174/6 (20 ov)

 Czechia need 169 runs in 18.4 remaining overs
LIVETodayMatch 10

Kolhapur TuskersKolhapur Tuskers

Satara Warriors*135/6 (17.2 ov)

 Satara Warriors elected to bat
LIVETodayMatch 31

Old BrentwoodsOld Brentwoods224/2 (10 ov)

Gagan*177/7 (9.3 ov)

 Gagan need 48 runs in 3 remaining balls
LIVEToday1st Semi Final

Eagle Thane StrikersEagle Thane Strikers*85/4 (16 ov)

Mumbai South Central Maratha Royals

 Eagle Thane Strikers elected to bat
LIVETodayMatch 10

NECO Master BlasterNECO Master Blaster

Orange Tigers*105/3 (14 ov)

 NECO Master Blaster elected to bowl
LIVETodayMatch 78

NetherlandsNetherlands

Nepal*20/0 (4.1 ov)

 Netherlands elected to bowl
LIVETodayMatch 3

Netherlands WomenNetherlands Women

United States of America Women

 Toss delayed due to rain
LIVETodayMatch 32

Old BrentwoodsOld Brentwoods

East Londoners

 Old Brentwoods elected to bowl
Scheduled10 June Match 27

Zimbabwe HPC WomenZimbabwe HPC Women

Cameroon Women

 
Scheduled10 June Match 28

Brazil WomenBrazil Women

Rwanda Women

 
Scheduled10 June Match 6

NorwayNorway

Austria

 
Scheduled10 June Match 33

GaganGagan

East Londoners

 
Scheduled10 June Match 11

Puneri BappaPuneri Bappa

Eagle Nashik Titans

 
Scheduled10 June Match 7

Salem SpartansSalem Spartans

Trichy Grand Chola

 
Scheduled10 June 2nd Semi Final

SOBO Mumbai FalconsSOBO Mumbai Falcons

Namo Bandra Blasters

 
CricDirect Cricket News, Results and Stats
 

Harry Dearden

NationalityEngland
RoleBatter
Born07 May 1997 (28)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 22 21 3 348 61 19.33 332 104.81 - 1
List A 10 10 - 341 91 34.10 379 89.97 - 3
1st Class 45 78 2 1629 87 21.43 3680 44.26 - 8

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 22 - - - - - - - - - -
List A 10 - - - - - - - - - -
1st Class 45 9 21.3 116 2 1/0 58.00 5.39 64.5 - -
× Close