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:e125bce2-5a63-4f0f-93d7-bb5be7ae5dfa Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 779 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (779,6,'{"status":"ok","response":{"player":{"pid":779,"title":"Rajat Bhatia","short_name":"R Bhatia","first_name":"Rajat Bhatia","last_name":"","middle_name":"","birthdate":"1979-10-22","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":146,"innings":95,"notout":37,"runs":1251,"balls":1079,"highest":107,"run100":1,"run50":1,"run4":85,"run6":43,"average":"21.56","strike":"115.94","catches":46,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":119,"innings":105,"notout":31,"runs":3038,"balls":0,"highest":106,"run100":3,"run50":19,"run4":0,"run6":0,"average":"41.05","strike":"","catches":45,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":112,"innings":157,"notout":25,"runs":6482,"balls":0,"highest":212,"run100":17,"run50":30,"run4":0,"run6":0,"average":"49.10","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":146,"innings":137,"balls":2520,"overs":420,"runs":3020,"wickets":111,"bestinning":"4\/15","bestmatch":"4\/15","econ":"7.19","average":"27.20","strike":"22.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":119,"innings":0,"balls":3931,"overs":655.1,"runs":2945,"wickets":93,"bestinning":"5\/17","bestmatch":"5\/17","econ":"4.49","average":"31.66","strike":"42.2","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":112,"innings":0,"balls":9989,"overs":1664.5,"runs":3832,"wickets":137,"bestinning":"5\/29","bestmatch":"","econ":"2.30","average":"27.97","strike":"72.9","wicket4i":0,"wicket5i":1,"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":"17a3df02c0581555c0e2e851d0dc28b0","modified":"2025-06-07 05:14:07","datetime":"2025-06-07 05:14:07","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":779,"title":"Rajat Bhatia","short_name":"R Bhatia","first_name":"Rajat Bhatia","last_name":"","middle_name":"","birthdate":"1979-10-22","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":146,"innings":95,"notout":37,"runs":1251,"balls":1079,"highest":107,"run100":1,"run50":1,"run4":85,"run6":43,"average":"21.56","strike":"115.94","catches":46,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":119,"innings":105,"notout":31,"runs":3038,"balls":0,"highest":106,"run100":3,"run50":19,"run4":0,"run6":0,"average":"41.05","strike":"","catches":45,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":112,"innings":157,"notout":25,"runs":6482,"balls":0,"highest":212,"run100":17,"run50":30,"run4":0,"run6":0,"average":"49.10","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":146,"innings":137,"balls":2520,"overs":420,"runs":3020,"wickets":111,"bestinning":"4\/15","bestmatch":"4\/15","econ":"7.19","average":"27.20","strike":"22.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":119,"innings":0,"balls":3931,"overs":655.1,"runs":2945,"wickets":93,"bestinning":"5\/17","bestmatch":"5\/17","econ":"4.49","average":"31.66","strike":"42.2","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":112,"innings":0,"balls":9989,"overs":1664.5,"runs":3832,"wickets":137,"bestinning":"5\/29","bestmatch":"","econ":"2.30","average":"27.97","strike":"72.9","wicket4i":0,"wicket5i":1,"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":"17a3df02c0581555c0e2e851d0dc28b0","modified":"2025-06-07 05:14:07","datetime":"2025-06-07 05:14:07","api_version":"3.0"}', Modified = GetDate() WHERE Id = 779 AND DataTypeId = 6 END
Player profile of Rajat Bhatia, India
CricDirect Cricket News, Results and Stats
 

Rajat Bhatia

NationalityIndia
RoleAll Rounder
Born22 Oct 1979 (45)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 146 95 37 1251 107 21.56 1079 115.94 1 1
List A 119 105 31 3038 106 41.05 - - 3 19
1st Class 112 157 25 6482 212 49.10 - - 17 30

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 146 137 420 3020 111 4/15 27.20 7.19 22.7 1 -
List A 119 - 655.1 2945 93 5/17 31.66 4.49 42.2 1 1
1st Class 112 - 1664.5 3832 137 5/29 27.97 2.30 72.9 - 1
× Close