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:3dafe973-08e8-4eb5-a70a-59c01f4a1fad Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 93516 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (93516,6,'{"status":"ok","response":{"player":{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":2,"notout":2,"runs":5,"balls":5,"highest":3,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"100.00","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":22,"innings":14,"notout":3,"runs":117,"balls":141,"highest":21,"run100":0,"run50":0,"run4":13,"run6":0,"average":"10.63","strike":"82.97","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":68,"innings":97,"notout":32,"runs":788,"balls":2047,"highest":46,"run100":0,"run50":0,"run4":92,"run6":8,"average":"12.12","strike":"38.49","catches":17,"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":7,"innings":6,"balls":95,"overs":15.5,"runs":167,"wickets":4,"bestinning":"3\/29","bestmatch":"3\/29","econ":"10.54","average":"41.75","strike":"23.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":22,"innings":22,"balls":1126,"overs":187.4,"runs":935,"wickets":32,"bestinning":"3\/27","bestmatch":"3\/27","econ":"4.98","average":"29.21","strike":"35.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":68,"innings":123,"balls":12889,"overs":2148.1,"runs":6184,"wickets":219,"bestinning":"5\/20","bestmatch":"9\/91","econ":"2.87","average":"28.23","strike":"58.8","wicket4i":9,"wicket5i":4,"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":"67af5c2cea539819a7a5d8052d273c48","modified":"2025-06-10 16:09:01","datetime":"2025-06-10 16:09:01","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":93516,"title":"Ethan Bamber","short_name":"ER Bamber","first_name":"Ethan Bamber","last_name":"","middle_name":"","birthdate":"1998-12-17","birthplace":"Westminster, Middlesex","country":"en","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":23794,"recent_appearance":1515965400,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/etbamber","instagram_profile":"https:\/\/www.instagram.com\/etbamber\/","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":2,"notout":2,"runs":5,"balls":5,"highest":3,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"100.00","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":22,"innings":14,"notout":3,"runs":117,"balls":141,"highest":21,"run100":0,"run50":0,"run4":13,"run6":0,"average":"10.63","strike":"82.97","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":68,"innings":97,"notout":32,"runs":788,"balls":2047,"highest":46,"run100":0,"run50":0,"run4":92,"run6":8,"average":"12.12","strike":"38.49","catches":17,"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":7,"innings":6,"balls":95,"overs":15.5,"runs":167,"wickets":4,"bestinning":"3\/29","bestmatch":"3\/29","econ":"10.54","average":"41.75","strike":"23.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":22,"innings":22,"balls":1126,"overs":187.4,"runs":935,"wickets":32,"bestinning":"3\/27","bestmatch":"3\/27","econ":"4.98","average":"29.21","strike":"35.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":68,"innings":123,"balls":12889,"overs":2148.1,"runs":6184,"wickets":219,"bestinning":"5\/20","bestmatch":"9\/91","econ":"2.87","average":"28.23","strike":"58.8","wicket4i":9,"wicket5i":4,"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":"67af5c2cea539819a7a5d8052d273c48","modified":"2025-06-10 16:09:01","datetime":"2025-06-10 16:09:01","api_version":"3.0"}', Modified = GetDate() WHERE Id = 93516 AND DataTypeId = 6 END
Player profile of Ethan Bamber, 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 78

NetherlandsNetherlands*116/4 (24.4 ov)

Nepal236/9 (50 ov)

 Netherlands need 121 runs in 25.2 remaining overs
LIVETodayMatch 11

Puneri BappaPuneri Bappa149/7 (20 ov)

Eagle Nashik Titans*16/1 (2.1 ov)

 Eagle Nashik Titans need 134 runs in 17.5 remaining overs
LIVETodayMatch 7

Salem SpartansSalem Spartans179/8 (20 ov)

Trichy Grand Chola*9/1 (0.4 ov)

 Trichy Grand Chola need 171 runs in 19.2 remaining overs
LIVEToday2nd Semi Final

SOBO Mumbai FalconsSOBO Mumbai Falcons*30/1 (3 ov)

Namo Bandra Blasters130/10 (20 ov)

 SOBO Mumbai Falcons need 101 runs in 17.0 remaining overs
LIVETodayMatch 6

Dita Gohilwad TitansDita Gohilwad Titans184/5 (20 ov)

JMD Kutch Riders*23/0 (3 ov)

 JMD Kutch Riders need 162 runs in 17.0 remaining overs
LIVETodayMatch 11

Nagpur HerozNagpur Heroz*38/3 (5.4 ov)

Nagpur Titans

 Nagpur Titans elected to bowl
LIVETodayMatch 34

Old BrentwoodsOld Brentwoods188/4 (10 ov)

Havering XI*60/5 (6.4 ov)

 Havering XI need 129 runs in 20 remaining balls
LIVETodayMatch 3

Soca KingsSoca Kings

Scarlet Ibis Scorchers

 Toss delayed due to rain
ScheduledTodayMatch 35

East LondonersEast Londoners

Havering XI

 
Scheduled10 June 3rd T20I

EnglandEngland

West Indies

 
Scheduled10 June Match 4

Leatherback StrikersLeatherback Strikers

Chicago Steelpan Players

 
Scheduled11 June Match 1

IndonesiaIndonesia

Cambodia

 
Scheduled11 June Match 2

Nagpur Titans WomenNagpur Titans Women

NECO Master Blaster Women

 
Scheduled11 June Match 9

Ratnagiri Jets WomenRatnagiri Jets Women

Pune Warriors Women

 
Scheduled11 June Match 29

Nigeria WomenNigeria Women

Uganda Women

 
Scheduled11 June Match 30

Rwanda WomenRwanda Women

Tanzania Women

 
Scheduled11 June Match 1

Czechia WomenCzechia Women

Gibraltar Women

 
CricDirect Cricket News, Results and Stats
 

Ethan Bamber

NationalityEngland
RoleAll Rounder
Born17 Dec 1998 (26)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 7 2 2 5 3 - 5 100.00 - -
List A 22 14 3 117 21 10.63 141 82.97 - -
1st Class 68 97 32 788 46 12.12 2047 38.49 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 7 6 15.5 167 4 3/29 41.75 10.54 23.7 - -
List A 22 22 187.4 935 32 3/27 29.21 4.98 35.1 - -
1st Class 68 123 2148.1 6184 219 5/20 28.23 2.87 58.8 9 4
× Close