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:a77a7865-2b14-4146-9b44-60cf16a6c1cc Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 101482 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (101482,6,'{"status":"ok","response":{"player":{"pid":101482,"title":"Henry Thomas Crocombe","short_name":"H T Crocombe","first_name":"Henry Thomas Crocombe","last_name":"","middle_name":"","birthdate":"2001-09-20","birthplace":"Eastbourne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/henrycrocombe\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":22,"innings":11,"notout":8,"runs":30,"balls":28,"highest":12,"run100":0,"run50":0,"run4":2,"run6":1,"average":"10.00","strike":"107.14","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":15,"notout":8,"runs":149,"balls":159,"highest":47,"run100":0,"run50":0,"run4":14,"run6":0,"average":"21.28","strike":"93.71","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":38,"innings":54,"notout":13,"runs":427,"balls":1072,"highest":54,"run100":0,"run50":1,"run4":55,"run6":0,"average":"10.41","strike":"39.83","catches":11,"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":22,"balls":360,"overs":60,"runs":609,"wickets":22,"bestinning":"3\/31","bestmatch":"3\/31","econ":"10.15","average":"27.68","strike":"16.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":24,"balls":1090,"overs":181.4,"runs":1103,"wickets":32,"bestinning":"4\/47","bestmatch":"4\/47","econ":"6.07","average":"34.46","strike":"34.0","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":38,"innings":62,"balls":4666,"overs":777.4,"runs":2945,"wickets":78,"bestinning":"4\/22","bestmatch":"6\/71","econ":"3.78","average":"37.75","strike":"59.8","wicket4i":6,"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":"8f2a7cd2ce2384baed9b64a3b610fa52","modified":"2025-07-14 12:01:11","datetime":"2025-07-14 12:01:11","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":101482,"title":"Henry Thomas Crocombe","short_name":"H T Crocombe","first_name":"Henry Thomas Crocombe","last_name":"","middle_name":"","birthdate":"2001-09-20","birthplace":"Eastbourne, United Kingdom","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Left Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/henrycrocombe\/","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":22,"innings":11,"notout":8,"runs":30,"balls":28,"highest":12,"run100":0,"run50":0,"run4":2,"run6":1,"average":"10.00","strike":"107.14","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":15,"notout":8,"runs":149,"balls":159,"highest":47,"run100":0,"run50":0,"run4":14,"run6":0,"average":"21.28","strike":"93.71","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":38,"innings":54,"notout":13,"runs":427,"balls":1072,"highest":54,"run100":0,"run50":1,"run4":55,"run6":0,"average":"10.41","strike":"39.83","catches":11,"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":22,"balls":360,"overs":60,"runs":609,"wickets":22,"bestinning":"3\/31","bestmatch":"3\/31","econ":"10.15","average":"27.68","strike":"16.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":24,"innings":24,"balls":1090,"overs":181.4,"runs":1103,"wickets":32,"bestinning":"4\/47","bestmatch":"4\/47","econ":"6.07","average":"34.46","strike":"34.0","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":38,"innings":62,"balls":4666,"overs":777.4,"runs":2945,"wickets":78,"bestinning":"4\/22","bestmatch":"6\/71","econ":"3.78","average":"37.75","strike":"59.8","wicket4i":6,"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":"8f2a7cd2ce2384baed9b64a3b610fa52","modified":"2025-07-14 12:01:11","datetime":"2025-07-14 12:01:11","api_version":"3.0"}', Modified = GetDate() WHERE Id = 101482 AND DataTypeId = 6 END
Player profile of Henry Thomas Crocombe, England
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday3rd Test

EnglandEngland387/10 (112.3 ov) & 192/10 (62.1 ov)

India387/10 (119.2 ov) & *112/8 (39.3 ov)

 Day 5 - Session 1, India need 81 runs to win.
LIVEToday1st Youth Test

England Under-19sEngland Under-19s*334/6 (85.2 ov)

India Under-19s540/10 (112.5 ov)

 Day 3 - England Under-19s trail by 206 runs.
LIVEToday3rd Test

West IndiesWest Indies143/10 (52.1 ov)

Australia225/10 (70.3 ov) & *99/6 (29 ov)

 Stumps : Day 2 - Australia lead by 181 runs.
LIVEToday1st Unofficial Test

Australia AAustralia A*241/4 (87 ov)

Sri Lanka A272/10 (82 ov)

 Stumps : Day 2 - Australia A trail by 31 runs.
LIVEToday1st T20I

ZimbabweZimbabwe*76/3 (13.2 ov)

South Africa

 South Africa elected to bowl
LIVETodayMatch 3

Koln CCKoln CC*84/7 (9.4 ov)

Lenkerbeck Marl

 Lenkerbeck Marl elected to bowl
CancelledTodayMatch 14

Gauhati Town ClubGauhati Town Club71/2 (8.5 ov)

Bud CC

 Match abandoned
Scheduled14 July Match 4

SC Krefeld SpartansSC Krefeld Spartans

Grey Caps Aachen

 
Scheduled14 July Match 5

Grey Caps AachenGrey Caps Aachen

Lenkerbeck Marl

 
Scheduled14 July Match 12

Gujrat CCGujrat CC

Royal Lions CC

 
Scheduled15 July Match 15

Nabarang ClubNabarang Club

City Cricket Club

 
Scheduled15 July Match 6

SC Krefeld SpartansSC Krefeld Spartans

Lenkerbeck Marl

 
Scheduled15 July Match 16

Gauhati Town ClubGauhati Town Club

Bud CC

 
Scheduled15 July Match 16

Karaikal KniightsKaraikal Kniights

Ruby White Town legends

 
Scheduled15 July Match 7

SC Krefeld SpartansSC Krefeld Spartans

Koln CC

 
Scheduled15 July Match 8

Grey Caps AachenGrey Caps Aachen

Koln CC

 
Scheduled15 July Match 17

Yanam RoyalsYanam Royals

Ossudu Accord Warriors

 
Scheduled15 July Match 9

Lenkerbeck MarlLenkerbeck Marl

VFB Gelsenkirchen

 
CricDirect Cricket News, Results and Stats
 

Henry Thomas Crocombe

NationalityEngland
RoleBowler
Born20 Sep 2001 (23)
Batting StyleRight Hand Bat
Bowling StyleLeft Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 22 11 8 30 12 10.00 28 107.14 - -
List A 24 15 8 149 47 21.28 159 93.71 - -
1st Class 38 54 13 427 54 10.41 1072 39.83 - 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 22 22 60 609 22 3/31 27.68 10.15 16.3 - -
List A 24 24 181.4 1103 32 4/47 34.46 6.07 34.0 2 -
1st Class 38 62 777.4 2945 78 4/22 37.75 3.78 59.8 6 -
× Close