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:9f36f1bd-6c62-4ee5-bd7d-a8d604582ddc Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 90243 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (90243,6,'{"status":"ok","response":{"player":{"pid":90243,"title":"Srinivas Sharath","short_name":"Srinivas Sharath","first_name":"Srinivas Sharath","last_name":"","middle_name":"","birthdate":"1996-03-01","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":5,"notout":1,"runs":66,"balls":63,"highest":29,"run100":0,"run50":0,"run4":6,"run6":1,"average":"16.50","strike":"104.76","catches":3,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":12,"innings":10,"notout":2,"runs":212,"balls":293,"highest":55,"run100":0,"run50":1,"run4":14,"run6":4,"average":"26.50","strike":"72.35","catches":12,"stumpings":2,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":26,"innings":40,"notout":6,"runs":1353,"balls":3156,"highest":100,"run100":1,"run50":9,"run4":135,"run6":7,"average":"39.79","strike":"42.87","catches":95,"stumpings":6,"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":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":12,"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":26,"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},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"9aa037e5bda5f584386eaa3d9ae0695d","modified":"2025-07-24 21:20:04","datetime":"2025-07-24 21:20:04","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":90243,"title":"Srinivas Sharath","short_name":"Srinivas Sharath","first_name":"Srinivas Sharath","last_name":"","middle_name":"","birthdate":"1996-03-01","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":5,"notout":1,"runs":66,"balls":63,"highest":29,"run100":0,"run50":0,"run4":6,"run6":1,"average":"16.50","strike":"104.76","catches":3,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":12,"innings":10,"notout":2,"runs":212,"balls":293,"highest":55,"run100":0,"run50":1,"run4":14,"run6":4,"average":"26.50","strike":"72.35","catches":12,"stumpings":2,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":26,"innings":40,"notout":6,"runs":1353,"balls":3156,"highest":100,"run100":1,"run50":9,"run4":135,"run6":7,"average":"39.79","strike":"42.87","catches":95,"stumpings":6,"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":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":12,"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":26,"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},"t10":{"match_id":"0","inning_id":"0","matches":"0","innings":"","balls":"","overs":"0","runs":"","wickets":"","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"","wicket5i":"","wicket10m":""}}},"etag":"9aa037e5bda5f584386eaa3d9ae0695d","modified":"2025-07-24 21:20:04","datetime":"2025-07-24 21:20:04","api_version":"3.0"}', Modified = GetDate() WHERE Id = 90243 AND DataTypeId = 6 END
Player profile of Srinivas Sharath, India
<>
CricDirect Cricket News, Results and Stats
 

Srinivas Sharath

NationalityIndia
Role
Born01 Mar 1996 (29)
Batting StyleRight Hand Bat

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 7 5 1 66 29 16.50 63 104.76 - -
List A 12 10 2 212 55 26.50 293 72.35 - 1
1st Class 26 40 6 1353 100 39.79 3156 42.87 1 9

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 7 - - - - - - - - - -
List A 12 - - - - - - - - - -
1st Class 26 - - - - - - - - - -
× Close