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:f847c5b2-bed4-4fa9-9e0a-ca3027a3393e Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 49708 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (49708,6,'{"status":"ok","response":{"player":{"pid":49708,"title":"Dane Paterson","short_name":"Dane Paterson","first_name":"Dane Paterson","last_name":"","middle_name":"","birthdate":"1989-04-04","birthplace":"Cape Town, Cape Province","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"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":7,"innings":11,"notout":3,"runs":101,"balls":110,"highest":39,"run100":0,"run50":0,"run4":15,"run6":3,"average":"12.62","strike":"91.81","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":4,"innings":0,"notout":0,"runs":0,"balls":0,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":8,"innings":2,"notout":1,"runs":5,"balls":2,"highest":4,"run100":0,"run50":0,"run4":1,"run6":0,"average":"5.00","strike":"250.00","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":106,"innings":38,"notout":17,"runs":175,"balls":145,"highest":24,"run100":0,"run50":0,"run4":13,"run6":5,"average":"8.33","strike":"120.68","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":118,"innings":55,"notout":19,"runs":415,"balls":407,"highest":29,"run100":0,"run50":0,"run4":25,"run6":27,"average":"11.52","strike":"101.96","catches":33,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":174,"innings":215,"notout":66,"runs":1765,"balls":2542,"highest":59,"run100":0,"run50":1,"run4":180,"run6":85,"average":"11.84","strike":"69.43","catches":50,"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":7,"innings":13,"balls":1319,"overs":219.5,"runs":656,"wickets":25,"bestinning":"5\/61","bestmatch":"7\/104","econ":"2.98","average":"26.24","strike":"52.7","wicket4i":0,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"balls":209,"overs":34.5,"runs":217,"wickets":4,"bestinning":"3\/44","bestmatch":"3\/44","econ":"6.22","average":"54.25","strike":"52.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":8,"innings":8,"balls":179,"overs":29.5,"runs":265,"wickets":9,"bestinning":"4\/32","bestmatch":"4\/32","econ":"8.88","average":"29.44","strike":"19.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":106,"innings":103,"balls":2085,"overs":347.3,"runs":2791,"wickets":110,"bestinning":"4\/24","bestmatch":"4\/24","econ":"8.03","average":"25.37","strike":"18.9","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":118,"innings":115,"balls":5632,"overs":938.4,"runs":4963,"wickets":162,"bestinning":"5\/19","bestmatch":"5\/19","econ":"5.28","average":"30.63","strike":"34.7","wicket4i":6,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":174,"innings":309,"balls":29340,"overs":4890,"runs":15078,"wickets":624,"bestinning":"8\/52","bestmatch":"10\/62","econ":"3.08","average":"24.16","strike":"47.0","wicket4i":18,"wicket5i":24,"wicket10m":2,"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":"c802efed0109728f2bda9e72b4987c6f","modified":"2025-07-22 02:28:53","datetime":"2025-07-22 02:28:53","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":49708,"title":"Dane Paterson","short_name":"Dane Paterson","first_name":"Dane Paterson","last_name":"","middle_name":"","birthdate":"1989-04-04","birthplace":"Cape Town, Cape Province","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"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":7,"innings":11,"notout":3,"runs":101,"balls":110,"highest":39,"run100":0,"run50":0,"run4":15,"run6":3,"average":"12.62","strike":"91.81","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":4,"innings":0,"notout":0,"runs":0,"balls":0,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":8,"innings":2,"notout":1,"runs":5,"balls":2,"highest":4,"run100":0,"run50":0,"run4":1,"run6":0,"average":"5.00","strike":"250.00","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":106,"innings":38,"notout":17,"runs":175,"balls":145,"highest":24,"run100":0,"run50":0,"run4":13,"run6":5,"average":"8.33","strike":"120.68","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":118,"innings":55,"notout":19,"runs":415,"balls":407,"highest":29,"run100":0,"run50":0,"run4":25,"run6":27,"average":"11.52","strike":"101.96","catches":33,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":174,"innings":215,"notout":66,"runs":1765,"balls":2542,"highest":59,"run100":0,"run50":1,"run4":180,"run6":85,"average":"11.84","strike":"69.43","catches":50,"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":7,"innings":13,"balls":1319,"overs":219.5,"runs":656,"wickets":25,"bestinning":"5\/61","bestmatch":"7\/104","econ":"2.98","average":"26.24","strike":"52.7","wicket4i":0,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":4,"innings":4,"balls":209,"overs":34.5,"runs":217,"wickets":4,"bestinning":"3\/44","bestmatch":"3\/44","econ":"6.22","average":"54.25","strike":"52.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":8,"innings":8,"balls":179,"overs":29.5,"runs":265,"wickets":9,"bestinning":"4\/32","bestmatch":"4\/32","econ":"8.88","average":"29.44","strike":"19.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":106,"innings":103,"balls":2085,"overs":347.3,"runs":2791,"wickets":110,"bestinning":"4\/24","bestmatch":"4\/24","econ":"8.03","average":"25.37","strike":"18.9","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":118,"innings":115,"balls":5632,"overs":938.4,"runs":4963,"wickets":162,"bestinning":"5\/19","bestmatch":"5\/19","econ":"5.28","average":"30.63","strike":"34.7","wicket4i":6,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":174,"innings":309,"balls":29340,"overs":4890,"runs":15078,"wickets":624,"bestinning":"8\/52","bestmatch":"10\/62","econ":"3.08","average":"24.16","strike":"47.0","wicket4i":18,"wicket5i":24,"wicket10m":2,"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":"c802efed0109728f2bda9e72b4987c6f","modified":"2025-07-22 02:28:53","datetime":"2025-07-22 02:28:53","api_version":"3.0"}', Modified = GetDate() WHERE Id = 49708 AND DataTypeId = 6 END
Player profile of Dane Paterson, South Africa
CricDirect Cricket News, Results and Stats
 

Dane Paterson

NationalitySouth Africa
RoleBowler
Born04 Apr 1989 (36)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 7 11 3 101 39 12.62 110 91.81 - -
ODI 4 - - - - - - - - -
T20I 8 2 1 5 4 5.00 2 250.00 - -
T20I 106 38 17 175 24 8.33 145 120.68 - -
List A 118 55 19 415 29 11.52 407 101.96 - -
1st Class 174 215 66 1765 59 11.84 2542 69.43 - 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 7 13 219.5 656 25 5/61 26.24 2.98 52.7 - 2
ODI 4 4 34.5 217 4 3/44 54.25 6.22 52.2 - -
T20i 8 8 29.5 265 9 4/32 29.44 8.88 19.8 1 -
T20 106 103 347.3 2791 110 4/24 25.37 8.03 18.9 3 -
List A 118 115 938.4 4963 162 5/19 30.63 5.28 34.7 6 1
1st Class 174 309 4890 15078 624 8/52 24.16 3.08 47.0 18 24
× Close