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:a2b65b2a-60e9-45b3-bff0-2c84bf1d22cf Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 43711 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (43711,6,'{"status":"ok","response":{"player":{"pid":43711,"title":"Minod Bhanuka","short_name":"M Bhanuka","first_name":"Minod Bhanuka","last_name":"","middle_name":"","birthdate":"1995-04-29","birthplace":"","country":"lk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/minod.banuka_15\/","debut_data":"","bowling_type":"","thumb_url":"","nationality":"Sri Lanka"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":2,"notout":0,"runs":6,"balls":17,"highest":5,"run100":0,"run50":0,"run4":1,"run6":0,"average":"3.00","strike":"35.29","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":6,"innings":6,"notout":0,"runs":140,"balls":194,"highest":36,"run100":0,"run50":0,"run4":13,"run6":2,"average":"23.33","strike":"72.16","catches":5,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"notout":0,"runs":64,"balls":66,"highest":36,"run100":0,"run50":0,"run4":7,"run6":0,"average":"16.00","strike":"96.96","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":90,"innings":84,"notout":10,"runs":1557,"balls":1303,"highest":85,"run100":0,"run50":9,"run4":133,"run6":56,"average":"21.04","strike":"119.49","catches":61,"stumpings":26,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":113,"innings":105,"notout":6,"runs":2978,"balls":3456,"highest":119,"run100":4,"run50":17,"run4":297,"run6":64,"average":"30.08","strike":"86.16","catches":116,"stumpings":45,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":93,"innings":154,"notout":11,"runs":6211,"balls":8668,"highest":342,"run100":17,"run50":27,"run4":677,"run6":122,"average":"43.43","strike":"71.65","catches":194,"stumpings":59,"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":1,"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":6,"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":5,"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":90,"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":113,"innings":1,"balls":12,"overs":2,"runs":7,"wickets":0,"bestinning":"","bestmatch":"","econ":"3.50","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":93,"innings":3,"balls":30,"overs":5,"runs":18,"wickets":0,"bestinning":"","bestmatch":"","econ":"3.60","average":"","strike":"","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":"9f42158762ad11d1110563db52971c07","modified":"2025-07-06 23:32:54","datetime":"2025-07-06 23:32:54","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":43711,"title":"Minod Bhanuka","short_name":"M Bhanuka","first_name":"Minod Bhanuka","last_name":"","middle_name":"","birthdate":"1995-04-29","birthplace":"","country":"lk","primary_team":[],"logo_url":"","playing_role":"wk","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/minod.banuka_15\/","debut_data":"","bowling_type":"","thumb_url":"","nationality":"Sri Lanka"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":1,"innings":2,"notout":0,"runs":6,"balls":17,"highest":5,"run100":0,"run50":0,"run4":1,"run6":0,"average":"3.00","strike":"35.29","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":6,"innings":6,"notout":0,"runs":140,"balls":194,"highest":36,"run100":0,"run50":0,"run4":13,"run6":2,"average":"23.33","strike":"72.16","catches":5,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"notout":0,"runs":64,"balls":66,"highest":36,"run100":0,"run50":0,"run4":7,"run6":0,"average":"16.00","strike":"96.96","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":90,"innings":84,"notout":10,"runs":1557,"balls":1303,"highest":85,"run100":0,"run50":9,"run4":133,"run6":56,"average":"21.04","strike":"119.49","catches":61,"stumpings":26,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":113,"innings":105,"notout":6,"runs":2978,"balls":3456,"highest":119,"run100":4,"run50":17,"run4":297,"run6":64,"average":"30.08","strike":"86.16","catches":116,"stumpings":45,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":93,"innings":154,"notout":11,"runs":6211,"balls":8668,"highest":342,"run100":17,"run50":27,"run4":677,"run6":122,"average":"43.43","strike":"71.65","catches":194,"stumpings":59,"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":1,"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":6,"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":5,"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":90,"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":113,"innings":1,"balls":12,"overs":2,"runs":7,"wickets":0,"bestinning":"","bestmatch":"","econ":"3.50","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":93,"innings":3,"balls":30,"overs":5,"runs":18,"wickets":0,"bestinning":"","bestmatch":"","econ":"3.60","average":"","strike":"","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":"9f42158762ad11d1110563db52971c07","modified":"2025-07-06 23:32:54","datetime":"2025-07-06 23:32:54","api_version":"3.0"}', Modified = GetDate() WHERE Id = 43711 AND DataTypeId = 6 END
Player profile of Minod Bhanuka, Sri Lanka
<>
CricDirect Cricket News, Results and Stats
 

Minod Bhanuka

NationalitySri Lanka
Role
Born29 Apr 1995 (30)
Batting StyleLeft hand Bat

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 1 2 - 6 5 3.00 17 35.29 - -
ODI 6 6 - 140 36 23.33 194 72.16 - -
T20I 5 4 - 64 36 16.00 66 96.96 - -
T20I 90 84 10 1557 85 21.04 1303 119.49 - 9
List A 113 105 6 2978 119 30.08 3456 86.16 4 17
1st Class 93 154 11 6211 342 43.43 8668 71.65 17 27

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 1 - - - - - - - - - -
ODI 6 - - - - - - - - - -
T20i 5 - - - - - - - - - -
T20 90 - - - - - - - - - -
List A 113 1 2 7 - - - 3.50 - - -
1st Class 93 3 5 18 - - - 3.60 - - -
× Close