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:f933166a-2554-46e6-8f6a-07a7171a7026 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 165 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (165,6,'{"status":"ok","response":{"player":{"pid":165,"title":"AB de Villiers","short_name":"A Villiers","first_name":"AB de Villiers","last_name":"","middle_name":"","birthdate":"1984-02-17","birthplace":"","country":"za","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":9.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":114,"innings":191,"notout":18,"runs":8765,"balls":16077,"highest":278,"run100":22,"run50":46,"run4":1024,"run6":64,"average":"50.66","strike":"54.51","catches":222,"stumpings":5,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":228,"innings":218,"notout":39,"runs":9577,"balls":9473,"highest":176,"run100":25,"run50":53,"run4":840,"run6":204,"average":"53.50","strike":"101.09","catches":176,"stumpings":5,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":78,"innings":75,"notout":11,"runs":1672,"balls":1237,"highest":79,"run100":0,"run50":10,"run4":140,"run6":60,"average":"26.12","strike":"135.16","catches":65,"stumpings":7,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":340,"innings":320,"notout":67,"runs":9424,"balls":6277,"highest":133,"run100":4,"run50":69,"run4":753,"run6":436,"average":"37.24","strike":"150.13","catches":230,"stumpings":18,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":263,"innings":252,"notout":44,"runs":11123,"balls":0,"highest":176,"run100":29,"run50":63,"run4":0,"run6":0,"average":"53.47","strike":"","catches":203,"stumpings":5,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":141,"innings":238,"notout":23,"runs":10689,"balls":19026,"highest":278,"run100":25,"run50":60,"run4":0,"run6":0,"average":"49.71","strike":"56.18","catches":275,"stumpings":6,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"2","notout":"1","runs":"61","balls":"24","highest":"50","run100":"0","run50":"1","run4":"6","run6":"3","average":"61.00","strike":"254.17","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":114,"innings":5,"balls":204,"overs":34,"runs":104,"wickets":2,"bestinning":"2\/49","bestmatch":"2\/49","econ":"3.05","average":"52.00","strike":"102.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":228,"innings":9,"balls":192,"overs":32,"runs":202,"wickets":7,"bestinning":"2\/15","bestmatch":"2\/15","econ":"6.31","average":"28.85","strike":"27.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":78,"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":340,"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":263,"innings":0,"balls":192,"overs":32,"runs":202,"wickets":7,"bestinning":"2\/15","bestmatch":"2\/15","econ":"6.31","average":"28.85","strike":"27.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":141,"innings":0,"balls":234,"overs":39,"runs":138,"wickets":2,"bestinning":"2\/49","bestmatch":"","econ":"3.53","average":"69.00","strike":"117.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"856f1fae7ec42dba5a27bee57daf1bf3","modified":"2025-07-08 20:32:13","datetime":"2025-07-08 20:32:13","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":165,"title":"AB de Villiers","short_name":"A Villiers","first_name":"AB de Villiers","last_name":"","middle_name":"","birthdate":"1984-02-17","birthplace":"","country":"za","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":9.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":114,"innings":191,"notout":18,"runs":8765,"balls":16077,"highest":278,"run100":22,"run50":46,"run4":1024,"run6":64,"average":"50.66","strike":"54.51","catches":222,"stumpings":5,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":228,"innings":218,"notout":39,"runs":9577,"balls":9473,"highest":176,"run100":25,"run50":53,"run4":840,"run6":204,"average":"53.50","strike":"101.09","catches":176,"stumpings":5,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":78,"innings":75,"notout":11,"runs":1672,"balls":1237,"highest":79,"run100":0,"run50":10,"run4":140,"run6":60,"average":"26.12","strike":"135.16","catches":65,"stumpings":7,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":340,"innings":320,"notout":67,"runs":9424,"balls":6277,"highest":133,"run100":4,"run50":69,"run4":753,"run6":436,"average":"37.24","strike":"150.13","catches":230,"stumpings":18,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":263,"innings":252,"notout":44,"runs":11123,"balls":0,"highest":176,"run100":29,"run50":63,"run4":0,"run6":0,"average":"53.47","strike":"","catches":203,"stumpings":5,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":141,"innings":238,"notout":23,"runs":10689,"balls":19026,"highest":278,"run100":25,"run50":60,"run4":0,"run6":0,"average":"49.71","strike":"56.18","catches":275,"stumpings":6,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"2","notout":"1","runs":"61","balls":"24","highest":"50","run100":"0","run50":"1","run4":"6","run6":"3","average":"61.00","strike":"254.17","catches":"0","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":114,"innings":5,"balls":204,"overs":34,"runs":104,"wickets":2,"bestinning":"2\/49","bestmatch":"2\/49","econ":"3.05","average":"52.00","strike":"102.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":228,"innings":9,"balls":192,"overs":32,"runs":202,"wickets":7,"bestinning":"2\/15","bestmatch":"2\/15","econ":"6.31","average":"28.85","strike":"27.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":78,"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":340,"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":263,"innings":0,"balls":192,"overs":32,"runs":202,"wickets":7,"bestinning":"2\/15","bestmatch":"2\/15","econ":"6.31","average":"28.85","strike":"27.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":141,"innings":0,"balls":234,"overs":39,"runs":138,"wickets":2,"bestinning":"2\/49","bestmatch":"","econ":"3.53","average":"69.00","strike":"117.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"2","innings":"0","balls":"0","overs":"0","runs":"0","wickets":"0","bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"856f1fae7ec42dba5a27bee57daf1bf3","modified":"2025-07-08 20:32:13","datetime":"2025-07-08 20:32:13","api_version":"3.0"}', Modified = GetDate() WHERE Id = 165 AND DataTypeId = 6 END
Player profile of AB de Villiers, South Africa
CricDirect Cricket News, Results and Stats
 

AB de Villiers

NationalitySouth Africa
RoleBatter
Born17 Feb 1984 (41)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 114 191 18 8765 278 50.66 16077 54.51 22 46
ODI 228 218 39 9577 176 53.50 9473 101.09 25 53
T20I 78 75 11 1672 79 26.12 1237 135.16 - 10
T20I 340 320 67 9424 133 37.24 6277 150.13 4 69
List A 263 252 44 11123 176 53.47 - - 29 63
1st Class 141 238 23 10689 278 49.71 19026 56.18 25 60

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 114 5 34 104 2 2/49 52.00 3.05 102.0 - -
ODI 228 9 32 202 7 2/15 28.85 6.31 27.4 - -
T20i 78 - - - - - - - - - -
T20 340 - - - - - - - - - -
List A 263 - 32 202 7 2/15 28.85 6.31 27.4 - -
1st Class 141 - 39 138 2 2/49 69.00 3.53 117.0 - -
× Close