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:48ed0bb3-5ddc-453c-a28e-72d8e75ed4ed Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 94269 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (94269,6,'{"status":"ok","response":{"player":{"pid":94269,"title":"Subham Ghosh","short_name":"SS Ghosh","first_name":"Subham Ghosh","last_name":"","middle_name":"","birthdate":"1998-10-07","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":14,"innings":11,"notout":2,"runs":104,"balls":111,"highest":24,"run100":0,"run50":0,"run4":4,"run6":2,"average":"11.55","strike":"93.69","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":13,"innings":9,"notout":3,"runs":71,"balls":114,"highest":21,"run100":0,"run50":0,"run4":2,"run6":0,"average":"11.83","strike":"62.28","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":9,"innings":15,"notout":2,"runs":288,"balls":715,"highest":55,"run100":0,"run50":1,"run4":43,"run6":2,"average":"22.15","strike":"40.27","catches":10,"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":14,"innings":8,"balls":126,"overs":21,"runs":163,"wickets":3,"bestinning":"1\/19","bestmatch":"1\/19","econ":"7.76","average":"54.33","strike":"42.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":13,"innings":10,"balls":312,"overs":52,"runs":280,"wickets":4,"bestinning":"3\/47","bestmatch":"3\/47","econ":"5.38","average":"70.00","strike":"78.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":9,"innings":13,"balls":606,"overs":101,"runs":305,"wickets":9,"bestinning":"3\/106","bestmatch":"3\/106","econ":"3.01","average":"33.88","strike":"67.3","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":"dc3cf07e0bfda8df610bc112103ff326","modified":"2025-07-14 01:34:41","datetime":"2025-07-14 01:34:41","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":94269,"title":"Subham Ghosh","short_name":"SS Ghosh","first_name":"Subham Ghosh","last_name":"","middle_name":"","birthdate":"1998-10-07","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":14,"innings":11,"notout":2,"runs":104,"balls":111,"highest":24,"run100":0,"run50":0,"run4":4,"run6":2,"average":"11.55","strike":"93.69","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":13,"innings":9,"notout":3,"runs":71,"balls":114,"highest":21,"run100":0,"run50":0,"run4":2,"run6":0,"average":"11.83","strike":"62.28","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":9,"innings":15,"notout":2,"runs":288,"balls":715,"highest":55,"run100":0,"run50":1,"run4":43,"run6":2,"average":"22.15","strike":"40.27","catches":10,"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":14,"innings":8,"balls":126,"overs":21,"runs":163,"wickets":3,"bestinning":"1\/19","bestmatch":"1\/19","econ":"7.76","average":"54.33","strike":"42.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":13,"innings":10,"balls":312,"overs":52,"runs":280,"wickets":4,"bestinning":"3\/47","bestmatch":"3\/47","econ":"5.38","average":"70.00","strike":"78.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":9,"innings":13,"balls":606,"overs":101,"runs":305,"wickets":9,"bestinning":"3\/106","bestmatch":"3\/106","econ":"3.01","average":"33.88","strike":"67.3","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":"dc3cf07e0bfda8df610bc112103ff326","modified":"2025-07-14 01:34:41","datetime":"2025-07-14 01:34:41","api_version":"3.0"}', Modified = GetDate() WHERE Id = 94269 AND DataTypeId = 6 END
Player profile of Subham Ghosh, India
<>
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) & *58/4 (17.4 ov)

 Stumps : Day 4 - India need 135 runs to win.
LIVEToday1st Youth Test

England Under-19sEngland Under-19s*230/5 (60 ov)

India Under-19s540/10 (112.5 ov)

 Stumps : Day 2 - England Under-19s trail by 310 runs.
LIVEToday3rd Test

West IndiesWest Indies143/10 (52.1 ov)

Australia225/10 (70.3 ov) & *79/6 (22.4 ov)

 Day 2 - Session 3, Australia lead by 161 runs.
LIVEToday1st Unofficial Test

Australia AAustralia A*28/0 (13 ov)

Sri Lanka A272/10 (82 ov)

 Day 2 - Australia A trail by 244 runs.
LIVETodayMatch 6

Guyana Amazon WarriorsGuyana Amazon Warriors138/7 (20 ov)

Dubai Capitals*19/1 (3 ov)

 Dubai Capitals need 120 runs in 17.0 remaining overs
LIVETodayFinal

Washington FreedomWashington Freedom

MI New York*166/7 (18.4 ov)

 Washington Freedom elected to bowl
Scheduled14 July Match 13

91 Yard Club91 Yard Club

Nabarang Club

 
Scheduled14 July Match 1

VFB GelsenkirchenVFB Gelsenkirchen

Koln CC

 
Scheduled14 July Match 14

Gauhati Town ClubGauhati Town Club

Bud CC

 
Scheduled14 July Match 2

VFB GelsenkirchenVFB Gelsenkirchen

SC Krefeld Spartans

 
Scheduled14 July 1st T20I

ZimbabweZimbabwe

South Africa

 
Scheduled14 July Match 3

Koln CCKoln CC

Lenkerbeck Marl

 
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

 
CricDirect Cricket News, Results and Stats
 

Subham Ghosh

NationalityIndia
RoleAll Rounder
Born07 Oct 1998 (26)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 14 11 2 104 24 11.55 111 93.69 - -
List A 13 9 3 71 21 11.83 114 62.28 - -
1st Class 9 15 2 288 55 22.15 715 40.27 - 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 14 8 21 163 3 1/19 54.33 7.76 42.0 - -
List A 13 10 52 280 4 3/47 70.00 5.38 78.0 - -
1st Class 9 13 101 305 9 3/106 33.88 3.01 67.3 - -
× Close