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:61c9e98e-9f97-4c62-8656-cf89621aac0e Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 125 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (125,6,'{"status":"ok","response":{"player":{"pid":125,"title":"Ravindra Jadeja","short_name":"R Jadeja","first_name":"Ravindra Jadeja","last_name":"","middle_name":"","birthdate":"1988-12-06","birthplace":"Navagam-Khed, Saurashtra","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ImRavindraJadeja\/","twitter_profile":"https:\/\/mobile.twitter.com\/imjadeja","instagram_profile":"https:\/\/www.instagram.com\/ravindra.jadeja","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":81,"innings":120,"notout":22,"runs":3406,"balls":6155,"highest":175,"run100":4,"run50":22,"run4":334,"run6":70,"average":"34.75","strike":"55.33","catches":46,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":204,"innings":137,"notout":51,"runs":2806,"balls":3284,"highest":87,"run100":0,"run50":13,"run4":205,"run6":54,"average":"32.62","strike":"85.44","catches":76,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":74,"innings":41,"notout":17,"runs":515,"balls":405,"highest":46,"run100":0,"run50":0,"run4":39,"run6":14,"average":"21.45","strike":"127.16","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":346,"innings":252,"notout":101,"runs":3985,"balls":3046,"highest":77,"run100":0,"run50":5,"run4":296,"run6":141,"average":"26.39","strike":"130.82","catches":141,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":257,"innings":181,"notout":63,"runs":3855,"balls":4442,"highest":134,"run100":2,"run50":18,"run4":281,"run6":81,"average":"32.66","strike":"86.78","catches":98,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":138,"innings":204,"notout":30,"runs":7559,"balls":13070,"highest":331,"run100":13,"run50":39,"run4":780,"run6":132,"average":"43.44","strike":"57.83","catches":97,"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":{"test":{"match_id":0,"inning_id":0,"matches":81,"innings":152,"balls":18755,"overs":3125.5,"runs":7970,"wickets":324,"bestinning":"7\/42","bestmatch":"10\/110","econ":"2.54","average":"24.59","strike":"57.8","wicket4i":13,"wicket5i":15,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":204,"innings":196,"balls":10116,"overs":1686,"runs":8180,"wickets":231,"bestinning":"5\/33","bestmatch":"5\/33","econ":"4.85","average":"35.41","strike":"43.7","wicket4i":7,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":74,"innings":71,"balls":1356,"overs":226,"runs":1612,"wickets":54,"bestinning":"3\/15","bestmatch":"3\/15","econ":"7.13","average":"29.85","strike":"25.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":346,"innings":314,"balls":5702,"overs":950.2,"runs":7251,"wickets":235,"bestinning":"5\/16","bestmatch":"5\/16","econ":"7.62","average":"30.85","strike":"24.2","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":257,"innings":244,"balls":12491,"overs":2081.5,"runs":9871,"wickets":292,"bestinning":"5\/33","bestmatch":"5\/33","econ":"4.74","average":"33.80","strike":"42.7","wicket4i":10,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":138,"innings":247,"balls":31240,"overs":5206.4,"runs":13220,"wickets":555,"bestinning":"7\/31","bestmatch":"13\/126","econ":"2.53","average":"23.81","strike":"56.2","wicket4i":23,"wicket5i":36,"wicket10m":10,"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":"0ceceaf467e8957ad3ec0d613303d3ed","modified":"2025-07-05 10:35:09","datetime":"2025-07-05 10:35:09","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":125,"title":"Ravindra Jadeja","short_name":"R Jadeja","first_name":"Ravindra Jadeja","last_name":"","middle_name":"","birthdate":"1988-12-06","birthplace":"Navagam-Khed, Saurashtra","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"https:\/\/www.facebook.com\/ImRavindraJadeja\/","twitter_profile":"https:\/\/mobile.twitter.com\/imjadeja","instagram_profile":"https:\/\/www.instagram.com\/ravindra.jadeja","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":81,"innings":120,"notout":22,"runs":3406,"balls":6155,"highest":175,"run100":4,"run50":22,"run4":334,"run6":70,"average":"34.75","strike":"55.33","catches":46,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":204,"innings":137,"notout":51,"runs":2806,"balls":3284,"highest":87,"run100":0,"run50":13,"run4":205,"run6":54,"average":"32.62","strike":"85.44","catches":76,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":74,"innings":41,"notout":17,"runs":515,"balls":405,"highest":46,"run100":0,"run50":0,"run4":39,"run6":14,"average":"21.45","strike":"127.16","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":346,"innings":252,"notout":101,"runs":3985,"balls":3046,"highest":77,"run100":0,"run50":5,"run4":296,"run6":141,"average":"26.39","strike":"130.82","catches":141,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":257,"innings":181,"notout":63,"runs":3855,"balls":4442,"highest":134,"run100":2,"run50":18,"run4":281,"run6":81,"average":"32.66","strike":"86.78","catches":98,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":138,"innings":204,"notout":30,"runs":7559,"balls":13070,"highest":331,"run100":13,"run50":39,"run4":780,"run6":132,"average":"43.44","strike":"57.83","catches":97,"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":{"test":{"match_id":0,"inning_id":0,"matches":81,"innings":152,"balls":18755,"overs":3125.5,"runs":7970,"wickets":324,"bestinning":"7\/42","bestmatch":"10\/110","econ":"2.54","average":"24.59","strike":"57.8","wicket4i":13,"wicket5i":15,"wicket10m":3,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":204,"innings":196,"balls":10116,"overs":1686,"runs":8180,"wickets":231,"bestinning":"5\/33","bestmatch":"5\/33","econ":"4.85","average":"35.41","strike":"43.7","wicket4i":7,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":74,"innings":71,"balls":1356,"overs":226,"runs":1612,"wickets":54,"bestinning":"3\/15","bestmatch":"3\/15","econ":"7.13","average":"29.85","strike":"25.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":346,"innings":314,"balls":5702,"overs":950.2,"runs":7251,"wickets":235,"bestinning":"5\/16","bestmatch":"5\/16","econ":"7.62","average":"30.85","strike":"24.2","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":257,"innings":244,"balls":12491,"overs":2081.5,"runs":9871,"wickets":292,"bestinning":"5\/33","bestmatch":"5\/33","econ":"4.74","average":"33.80","strike":"42.7","wicket4i":10,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":138,"innings":247,"balls":31240,"overs":5206.4,"runs":13220,"wickets":555,"bestinning":"7\/31","bestmatch":"13\/126","econ":"2.53","average":"23.81","strike":"56.2","wicket4i":23,"wicket5i":36,"wicket10m":10,"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":"0ceceaf467e8957ad3ec0d613303d3ed","modified":"2025-07-05 10:35:09","datetime":"2025-07-05 10:35:09","api_version":"3.0"}', Modified = GetDate() WHERE Id = 125 AND DataTypeId = 6 END
Player profile of Ravindra Jadeja, India
CricDirect Cricket News, Results and Stats
 

Ravindra Jadeja

NationalityIndia
RoleAll Rounder
Born06 Dec 1988 (36)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 81 120 22 3406 175 34.75 6155 55.33 4 22
ODI 204 137 51 2806 87 32.62 3284 85.44 - 13
T20I 74 41 17 515 46 21.45 405 127.16 - -
T20I 346 252 101 3985 77 26.39 3046 130.82 - 5
List A 257 181 63 3855 134 32.66 4442 86.78 2 18
1st Class 138 204 30 7559 331 43.44 13070 57.83 13 39

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 81 152 3125.5 7970 324 7/42 24.59 2.54 57.8 13 15
ODI 204 196 1686 8180 231 5/33 35.41 4.85 43.7 7 2
T20i 74 71 226 1612 54 3/15 29.85 7.13 25.1 - -
T20 346 314 950.2 7251 235 5/16 30.85 7.62 24.2 3 1
List A 257 244 2081.5 9871 292 5/33 33.80 4.74 42.7 10 2
1st Class 138 247 5206.4 13220 555 7/31 23.81 2.53 56.2 23 36
× Close