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:cff2f22a-6608-4627-892a-6f5978b76bc3 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 105 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (105,6,'{"status":"ok","response":{"player":{"pid":105,"title":"Jos Buttler","short_name":"J Buttler","first_name":"Jos Buttler","last_name":"","middle_name":"","birthdate":"1990-09-08","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicket keeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/josbuttler\/","twitter_profile":"https:\/\/twitter.com\/josbuttler","instagram_profile":"https:\/\/www.instagram.com\/josbuttler\/","debut_data":"","bowling_type":"","thumb_url":"","nationality":"England"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":57,"innings":100,"notout":9,"runs":2907,"balls":5365,"highest":152,"run100":2,"run50":18,"run4":340,"run6":33,"average":"31.94","strike":"54.18","catches":153,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":190,"innings":163,"notout":28,"runs":5274,"balls":4565,"highest":162,"run100":11,"run50":27,"run4":422,"run6":176,"average":"39.06","strike":"115.53","catches":227,"stumpings":38,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":137,"innings":126,"notout":23,"runs":3700,"balls":2516,"highest":101,"run100":1,"run50":27,"run4":333,"run6":160,"average":"35.92","strike":"147.05","catches":78,"stumpings":15,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":456,"innings":430,"notout":66,"runs":12969,"balls":8891,"highest":124,"run100":8,"run50":92,"run4":1169,"run6":554,"average":"35.62","strike":"145.86","catches":268,"stumpings":48,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":260,"innings":222,"notout":48,"runs":7439,"balls":6351,"highest":162,"run100":13,"run50":43,"run4":645,"run6":239,"average":"42.75","strike":"117.13","catches":277,"stumpings":43,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":122,"innings":199,"notout":16,"runs":5888,"balls":10293,"highest":152,"run100":7,"run50":33,"run4":732,"run6":72,"average":"32.17","strike":"57.20","catches":274,"stumpings":3,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"9","notout":"5","runs":"242","balls":"108","highest":"62","run100":"0","run50":"2","run4":"14","run6":"22","average":"60.50","strike":"224.07","catches":"1","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":57,"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},"odi":{"match_id":0,"inning_id":0,"matches":190,"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},"t20i":{"match_id":0,"inning_id":0,"matches":137,"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},"t20":{"match_id":0,"inning_id":0,"matches":456,"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":260,"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":122,"innings":1,"balls":12,"overs":2,"runs":11,"wickets":0,"bestinning":"","bestmatch":"","econ":"5.50","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"1396f3057a3f6498cdc4738e41130cd9","modified":"2025-07-16 02:27:00","datetime":"2025-07-16 02:27:00","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":105,"title":"Jos Buttler","short_name":"J Buttler","first_name":"Jos Buttler","last_name":"","middle_name":"","birthdate":"1990-09-08","birthplace":"Taunton, Somerset","country":"en","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Right Hand Bat","bowling_style":"","fielding_position":"Wicket keeper","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"https:\/\/www.facebook.com\/josbuttler\/","twitter_profile":"https:\/\/twitter.com\/josbuttler","instagram_profile":"https:\/\/www.instagram.com\/josbuttler\/","debut_data":"","bowling_type":"","thumb_url":"","nationality":"England"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":57,"innings":100,"notout":9,"runs":2907,"balls":5365,"highest":152,"run100":2,"run50":18,"run4":340,"run6":33,"average":"31.94","strike":"54.18","catches":153,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":190,"innings":163,"notout":28,"runs":5274,"balls":4565,"highest":162,"run100":11,"run50":27,"run4":422,"run6":176,"average":"39.06","strike":"115.53","catches":227,"stumpings":38,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":137,"innings":126,"notout":23,"runs":3700,"balls":2516,"highest":101,"run100":1,"run50":27,"run4":333,"run6":160,"average":"35.92","strike":"147.05","catches":78,"stumpings":15,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":456,"innings":430,"notout":66,"runs":12969,"balls":8891,"highest":124,"run100":8,"run50":92,"run4":1169,"run6":554,"average":"35.62","strike":"145.86","catches":268,"stumpings":48,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":260,"innings":222,"notout":48,"runs":7439,"balls":6351,"highest":162,"run100":13,"run50":43,"run4":645,"run6":239,"average":"42.75","strike":"117.13","catches":277,"stumpings":43,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":122,"innings":199,"notout":16,"runs":5888,"balls":10293,"highest":152,"run100":7,"run50":33,"run4":732,"run6":72,"average":"32.17","strike":"57.20","catches":274,"stumpings":3,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"9","notout":"5","runs":"242","balls":"108","highest":"62","run100":"0","run50":"2","run4":"14","run6":"22","average":"60.50","strike":"224.07","catches":"1","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":57,"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},"odi":{"match_id":0,"inning_id":0,"matches":190,"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},"t20i":{"match_id":0,"inning_id":0,"matches":137,"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},"t20":{"match_id":0,"inning_id":0,"matches":456,"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":260,"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":122,"innings":1,"balls":12,"overs":2,"runs":11,"wickets":0,"bestinning":"","bestmatch":"","econ":"5.50","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"1396f3057a3f6498cdc4738e41130cd9","modified":"2025-07-16 02:27:00","datetime":"2025-07-16 02:27:00","api_version":"3.0"}', Modified = GetDate() WHERE Id = 105 AND DataTypeId = 6 END
Player profile of Jos Buttler, England
CricDirect Cricket News, Results and Stats
 

Jos Buttler

NationalityEngland
Role
Born08 Sep 1990 (34)
Batting StyleRight Hand Bat

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 57 100 9 2907 152 31.94 5365 54.18 2 18
ODI 190 163 28 5274 162 39.06 4565 115.53 11 27
T20I 137 126 23 3700 101 35.92 2516 147.05 1 27
T20I 456 430 66 12969 124 35.62 8891 145.86 8 92
List A 260 222 48 7439 162 42.75 6351 117.13 13 43
1st Class 122 199 16 5888 152 32.17 10293 57.20 7 33

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 57 - - - - - - - - - -
ODI 190 - - - - - - - - - -
T20i 137 - - - - - - - - - -
T20 456 - - - - - - - - - -
List A 260 - - - - - - - - - -
1st Class 122 1 2 11 - - - 5.50 - - -
× Close