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:2ecebcda-9690-4275-83ea-2894a4eb5ce1 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 54407 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (54407,6,'{"status":"ok","response":{"player":{"pid":54407,"title":"Rajagopal Sathish","short_name":"R Sathish","first_name":"Rajagopal Sathish","last_name":"","middle_name":"","birthdate":"1981-01-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":67,"innings":53,"notout":15,"runs":722,"balls":560,"highest":41,"run100":0,"run50":0,"run4":62,"run6":23,"average":"19.00","strike":"128.92","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":57,"innings":49,"notout":16,"runs":1297,"balls":0,"highest":91,"run100":0,"run50":7,"run4":0,"run6":0,"average":"39.30","strike":"","catches":38,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":41,"innings":60,"notout":7,"runs":1859,"balls":0,"highest":204,"run100":5,"run50":5,"run4":0,"run6":0,"average":"35.07","strike":"","catches":41,"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":67,"innings":37,"balls":541,"overs":90.1,"runs":633,"wickets":24,"bestinning":"3\/12","bestmatch":"3\/12","econ":"7.02","average":"26.37","strike":"22.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":57,"innings":0,"balls":1323,"overs":220.3,"runs":980,"wickets":39,"bestinning":"4\/16","bestmatch":"4\/16","econ":"4.44","average":"25.12","strike":"33.9","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":41,"innings":0,"balls":1654,"overs":275.4,"runs":650,"wickets":17,"bestinning":"3\/18","bestmatch":"","econ":"2.35","average":"38.23","strike":"97.2","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":"4cc3c63e2a2fbfdaf1e0e8abfc4800ba","modified":"2025-06-20 12:12:41","datetime":"2025-06-20 12:12:41","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":54407,"title":"Rajagopal Sathish","short_name":"R Sathish","first_name":"Rajagopal Sathish","last_name":"","middle_name":"","birthdate":"1981-01-14","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":67,"innings":53,"notout":15,"runs":722,"balls":560,"highest":41,"run100":0,"run50":0,"run4":62,"run6":23,"average":"19.00","strike":"128.92","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":57,"innings":49,"notout":16,"runs":1297,"balls":0,"highest":91,"run100":0,"run50":7,"run4":0,"run6":0,"average":"39.30","strike":"","catches":38,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":41,"innings":60,"notout":7,"runs":1859,"balls":0,"highest":204,"run100":5,"run50":5,"run4":0,"run6":0,"average":"35.07","strike":"","catches":41,"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":67,"innings":37,"balls":541,"overs":90.1,"runs":633,"wickets":24,"bestinning":"3\/12","bestmatch":"3\/12","econ":"7.02","average":"26.37","strike":"22.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":57,"innings":0,"balls":1323,"overs":220.3,"runs":980,"wickets":39,"bestinning":"4\/16","bestmatch":"4\/16","econ":"4.44","average":"25.12","strike":"33.9","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":41,"innings":0,"balls":1654,"overs":275.4,"runs":650,"wickets":17,"bestinning":"3\/18","bestmatch":"","econ":"2.35","average":"38.23","strike":"97.2","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":"4cc3c63e2a2fbfdaf1e0e8abfc4800ba","modified":"2025-06-20 12:12:41","datetime":"2025-06-20 12:12:41","api_version":"3.0"}', Modified = GetDate() WHERE Id = 54407 AND DataTypeId = 6 END
Player profile of Rajagopal Sathish, India
<>
CricDirect Cricket News, Results and Stats
 

Rajagopal Sathish

NationalityIndia
RoleBatter
Born14 Jan 1981 (44)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 67 53 15 722 41 19.00 560 128.92 - -
List A 57 49 16 1297 91 39.30 - - - 7
1st Class 41 60 7 1859 204 35.07 - - 5 5

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 67 37 90.1 633 24 3/12 26.37 7.02 22.5 - -
List A 57 - 220.3 980 39 4/16 25.12 4.44 33.9 1 -
1st Class 41 - 275.4 650 17 3/18 38.23 2.35 97.2 - -
× Close