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:009d140a-dd8a-4909-9523-5cd5f69119e4 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1812 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1812,6,'{"status":"ok","response":{"player":{"pid":1812,"title":"Wellington Masakadza","short_name":"W Masakadza","first_name":"Wellington Masakadza","last_name":"","middle_name":"","birthdate":"1993-10-04","birthplace":"Harare","country":"zw","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Zimbabwe"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":7,"innings":14,"notout":2,"runs":159,"balls":523,"highest":57,"run100":0,"run50":1,"run4":16,"run6":3,"average":"13.25","strike":"30.40","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":42,"innings":26,"notout":4,"runs":243,"balls":386,"highest":40,"run100":0,"run50":0,"run4":21,"run6":2,"average":"11.04","strike":"62.95","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":65,"innings":38,"notout":12,"runs":244,"balls":259,"highest":34,"run100":0,"run50":0,"run4":17,"run6":5,"average":"9.38","strike":"94.20","catches":29,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":108,"innings":63,"notout":21,"runs":508,"balls":483,"highest":56,"run100":0,"run50":1,"run4":41,"run6":9,"average":"12.09","strike":"105.17","catches":53,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":117,"innings":76,"notout":16,"runs":960,"balls":1280,"highest":66,"run100":0,"run50":2,"run4":80,"run6":9,"average":"16.00","strike":"75.00","catches":49,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":64,"innings":104,"notout":16,"runs":1847,"balls":4249,"highest":88,"run100":0,"run50":12,"run4":186,"run6":24,"average":"20.98","strike":"43.46","catches":43,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"17","innings":"6","notout":"2","runs":"22","balls":"22","highest":"9","run100":"0","run50":"0","run4":"2","run6":"0","average":"5.50","strike":"100.00","catches":"10","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"balls":1381,"overs":230.1,"runs":790,"wickets":19,"bestinning":"4\/98","bestmatch":"5\/41","econ":"3.43","average":"41.57","strike":"72.6","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":42,"innings":39,"balls":1751,"overs":291.5,"runs":1423,"wickets":33,"bestinning":"4\/21","bestmatch":"4\/21","econ":"4.87","average":"43.12","strike":"53.0","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":65,"innings":61,"balls":1084,"overs":180.4,"runs":1317,"wickets":44,"bestinning":"4\/11","bestmatch":"4\/11","econ":"7.28","average":"29.93","strike":"24.6","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":108,"innings":104,"balls":1967,"overs":327.5,"runs":2364,"wickets":82,"bestinning":"4\/11","bestmatch":"4\/11","econ":"7.21","average":"28.82","strike":"23.9","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":117,"innings":113,"balls":5686,"overs":947.4,"runs":4150,"wickets":116,"bestinning":"4\/21","bestmatch":"4\/21","econ":"4.37","average":"35.77","strike":"49.0","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":64,"innings":111,"balls":11086,"overs":1847.4,"runs":5278,"wickets":202,"bestinning":"6\/41","bestmatch":"10\/98","econ":"2.85","average":"26.12","strike":"54.8","wicket4i":10,"wicket5i":8,"wicket10m":1,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"17","innings":"12","balls":"109","overs":"18.1","runs":"214","wickets":"10","bestinning":"3\/11","bestmatch":"3\/11","econ":"11.78","average":"21.40","strike":"10.90","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"71141a5408d0b3d4278ff31615ed879b","modified":"2025-07-25 06:52:28","datetime":"2025-07-25 06:52:28","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1812,"title":"Wellington Masakadza","short_name":"W Masakadza","first_name":"Wellington Masakadza","last_name":"","middle_name":"","birthdate":"1993-10-04","birthplace":"Harare","country":"zw","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":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Zimbabwe"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":7,"innings":14,"notout":2,"runs":159,"balls":523,"highest":57,"run100":0,"run50":1,"run4":16,"run6":3,"average":"13.25","strike":"30.40","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":42,"innings":26,"notout":4,"runs":243,"balls":386,"highest":40,"run100":0,"run50":0,"run4":21,"run6":2,"average":"11.04","strike":"62.95","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":65,"innings":38,"notout":12,"runs":244,"balls":259,"highest":34,"run100":0,"run50":0,"run4":17,"run6":5,"average":"9.38","strike":"94.20","catches":29,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":108,"innings":63,"notout":21,"runs":508,"balls":483,"highest":56,"run100":0,"run50":1,"run4":41,"run6":9,"average":"12.09","strike":"105.17","catches":53,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":117,"innings":76,"notout":16,"runs":960,"balls":1280,"highest":66,"run100":0,"run50":2,"run4":80,"run6":9,"average":"16.00","strike":"75.00","catches":49,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":64,"innings":104,"notout":16,"runs":1847,"balls":4249,"highest":88,"run100":0,"run50":12,"run4":186,"run6":24,"average":"20.98","strike":"43.46","catches":43,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"17","innings":"6","notout":"2","runs":"22","balls":"22","highest":"9","run100":"0","run50":"0","run4":"2","run6":"0","average":"5.50","strike":"100.00","catches":"10","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"balls":1381,"overs":230.1,"runs":790,"wickets":19,"bestinning":"4\/98","bestmatch":"5\/41","econ":"3.43","average":"41.57","strike":"72.6","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":42,"innings":39,"balls":1751,"overs":291.5,"runs":1423,"wickets":33,"bestinning":"4\/21","bestmatch":"4\/21","econ":"4.87","average":"43.12","strike":"53.0","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":65,"innings":61,"balls":1084,"overs":180.4,"runs":1317,"wickets":44,"bestinning":"4\/11","bestmatch":"4\/11","econ":"7.28","average":"29.93","strike":"24.6","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":108,"innings":104,"balls":1967,"overs":327.5,"runs":2364,"wickets":82,"bestinning":"4\/11","bestmatch":"4\/11","econ":"7.21","average":"28.82","strike":"23.9","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":117,"innings":113,"balls":5686,"overs":947.4,"runs":4150,"wickets":116,"bestinning":"4\/21","bestmatch":"4\/21","econ":"4.37","average":"35.77","strike":"49.0","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":64,"innings":111,"balls":11086,"overs":1847.4,"runs":5278,"wickets":202,"bestinning":"6\/41","bestmatch":"10\/98","econ":"2.85","average":"26.12","strike":"54.8","wicket4i":10,"wicket5i":8,"wicket10m":1,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"17","innings":"12","balls":"109","overs":"18.1","runs":"214","wickets":"10","bestinning":"3\/11","bestmatch":"3\/11","econ":"11.78","average":"21.40","strike":"10.90","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"71141a5408d0b3d4278ff31615ed879b","modified":"2025-07-25 06:52:28","datetime":"2025-07-25 06:52:28","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1812 AND DataTypeId = 6 END
Player profile of Wellington Masakadza, Zimbabwe
<>
CricDirect Cricket News, Results and Stats
 

Wellington Masakadza

NationalityZimbabwe
RoleAll Rounder
Born04 Oct 1993 (31)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 7 14 2 159 57 13.25 523 30.40 - 1
ODI 42 26 4 243 40 11.04 386 62.95 - -
T20I 65 38 12 244 34 9.38 259 94.20 - -
T20I 108 63 21 508 56 12.09 483 105.17 - 1
List A 117 76 16 960 66 16.00 1280 75.00 - 2
1st Class 64 104 16 1847 88 20.98 4249 43.46 - 12

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 7 11 230.1 790 19 4/98 41.57 3.43 72.6 1 -
ODI 42 39 291.5 1423 33 4/21 43.12 4.87 53.0 1 -
T20i 65 61 180.4 1317 44 4/11 29.93 7.28 24.6 2 -
T20 108 104 327.5 2364 82 4/11 28.82 7.21 23.9 2 -
List A 117 113 947.4 4150 116 4/21 35.77 4.37 49.0 4 -
1st Class 64 111 1847.4 5278 202 6/41 26.12 2.85 54.8 10 8
× Close