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:950d0903-7de0-47b5-9856-4c0b058b23b0 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 35 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (35,6,'{"status":"ok","response":{"player":{"pid":35,"title":"Grant Elliott","short_name":"G Elliott","first_name":"Grant Elliott","last_name":"","middle_name":"","birthdate":"1979-03-21","birthplace":"Johannesburg, Transvaal","country":"nz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/grantelliottnz","instagram_profile":"https:\/\/www.instagram.com\/grantelliottnz\/","debut_data":"","thumb_url":"","nationality":"New Zealand"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":5,"innings":9,"notout":1,"runs":86,"balls":322,"highest":25,"run100":0,"run50":0,"run4":3,"run6":0,"average":"10.75","strike":"26.70","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":83,"innings":69,"notout":11,"runs":1976,"balls":2416,"highest":115,"run100":2,"run50":11,"run4":151,"run6":28,"average":"34.06","strike":"81.78","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":17,"innings":15,"notout":4,"runs":171,"balls":157,"highest":27,"run100":0,"run50":0,"run4":12,"run6":2,"average":"15.54","strike":"108.91","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":150,"innings":127,"notout":30,"runs":2209,"balls":1718,"highest":70,"run100":0,"run50":8,"run4":174,"run6":74,"average":"22.77","strike":"128.57","catches":54,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":211,"innings":183,"notout":30,"runs":5126,"balls":0,"highest":115,"run100":7,"run50":28,"run4":0,"run6":0,"average":"33.50","strike":"","catches":70,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":83,"innings":134,"notout":7,"runs":3883,"balls":0,"highest":196,"run100":8,"run50":20,"run4":0,"run6":0,"average":"30.57","strike":"","catches":46,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"5","innings":"1","notout":"0","runs":"0","balls":"1","highest":"0","run100":"0","run50":"0","run4":"0","run6":"0","average":"0.00","strike":"0.00","catches":"2","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":5,"innings":6,"balls":282,"overs":47,"runs":140,"wickets":4,"bestinning":"2\/8","bestmatch":"2\/8","econ":"2.97","average":"35.00","strike":"70.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":83,"innings":56,"balls":1302,"overs":217,"runs":1179,"wickets":39,"bestinning":"4\/31","bestmatch":"4\/31","econ":"5.43","average":"30.23","strike":"33.3","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":17,"innings":15,"balls":192,"overs":32,"runs":235,"wickets":14,"bestinning":"4\/22","bestmatch":"4\/22","econ":"7.34","average":"16.78","strike":"13.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":150,"innings":130,"balls":1996,"overs":332.4,"runs":2682,"wickets":112,"bestinning":"4\/15","bestmatch":"4\/15","econ":"8.06","average":"23.94","strike":"17.8","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":211,"innings":0,"balls":4827,"overs":804.3,"runs":4337,"wickets":130,"bestinning":"5\/34","bestmatch":"5\/34","econ":"5.39","average":"33.36","strike":"37.1","wicket4i":4,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":83,"innings":0,"balls":7216,"overs":1202.4,"runs":3378,"wickets":92,"bestinning":"5\/33","bestmatch":"","econ":"2.80","average":"36.71","strike":"78.4","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"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"}}},"etag":"f5e16118578aff58dcb2fb68c9b09a15","modified":"2025-05-31 14:53:40","datetime":"2025-05-31 14:53:40","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":35,"title":"Grant Elliott","short_name":"G Elliott","first_name":"Grant Elliott","last_name":"","middle_name":"","birthdate":"1979-03-21","birthplace":"Johannesburg, Transvaal","country":"nz","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/grantelliottnz","instagram_profile":"https:\/\/www.instagram.com\/grantelliottnz\/","debut_data":"","thumb_url":"","nationality":"New Zealand"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":5,"innings":9,"notout":1,"runs":86,"balls":322,"highest":25,"run100":0,"run50":0,"run4":3,"run6":0,"average":"10.75","strike":"26.70","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":83,"innings":69,"notout":11,"runs":1976,"balls":2416,"highest":115,"run100":2,"run50":11,"run4":151,"run6":28,"average":"34.06","strike":"81.78","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":17,"innings":15,"notout":4,"runs":171,"balls":157,"highest":27,"run100":0,"run50":0,"run4":12,"run6":2,"average":"15.54","strike":"108.91","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":150,"innings":127,"notout":30,"runs":2209,"balls":1718,"highest":70,"run100":0,"run50":8,"run4":174,"run6":74,"average":"22.77","strike":"128.57","catches":54,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":211,"innings":183,"notout":30,"runs":5126,"balls":0,"highest":115,"run100":7,"run50":28,"run4":0,"run6":0,"average":"33.50","strike":"","catches":70,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":83,"innings":134,"notout":7,"runs":3883,"balls":0,"highest":196,"run100":8,"run50":20,"run4":0,"run6":0,"average":"30.57","strike":"","catches":46,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"5","innings":"1","notout":"0","runs":"0","balls":"1","highest":"0","run100":"0","run50":"0","run4":"0","run6":"0","average":"0.00","strike":"0.00","catches":"2","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":5,"innings":6,"balls":282,"overs":47,"runs":140,"wickets":4,"bestinning":"2\/8","bestmatch":"2\/8","econ":"2.97","average":"35.00","strike":"70.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":83,"innings":56,"balls":1302,"overs":217,"runs":1179,"wickets":39,"bestinning":"4\/31","bestmatch":"4\/31","econ":"5.43","average":"30.23","strike":"33.3","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":17,"innings":15,"balls":192,"overs":32,"runs":235,"wickets":14,"bestinning":"4\/22","bestmatch":"4\/22","econ":"7.34","average":"16.78","strike":"13.7","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":150,"innings":130,"balls":1996,"overs":332.4,"runs":2682,"wickets":112,"bestinning":"4\/15","bestmatch":"4\/15","econ":"8.06","average":"23.94","strike":"17.8","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":211,"innings":0,"balls":4827,"overs":804.3,"runs":4337,"wickets":130,"bestinning":"5\/34","bestmatch":"5\/34","econ":"5.39","average":"33.36","strike":"37.1","wicket4i":4,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":83,"innings":0,"balls":7216,"overs":1202.4,"runs":3378,"wickets":92,"bestinning":"5\/33","bestmatch":"","econ":"2.80","average":"36.71","strike":"78.4","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"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"}}},"etag":"f5e16118578aff58dcb2fb68c9b09a15","modified":"2025-05-31 14:53:40","datetime":"2025-05-31 14:53:40","api_version":"3.0"}', Modified = GetDate() WHERE Id = 35 AND DataTypeId = 6 END
Player profile of Grant Elliott, New Zealand
<>
CricDirect Cricket News, Results and Stats
 

Grant Elliott

NationalityNew Zealand
RoleAll Rounder
Born21 Mar 1979 (46)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 5 9 1 86 25 10.75 322 26.70 - -
ODI 83 69 11 1976 115 34.06 2416 81.78 2 11
T20I 17 15 4 171 27 15.54 157 108.91 - -
T20I 150 127 30 2209 70 22.77 1718 128.57 - 8
List A 211 183 30 5126 115 33.50 - - 7 28
1st Class 83 134 7 3883 196 30.57 - - 8 20

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 5 6 47 140 4 2/8 35.00 2.97 70.5 - -
ODI 83 56 217 1179 39 4/31 30.23 5.43 33.3 1 -
T20i 17 15 32 235 14 4/22 16.78 7.34 13.7 1 -
T20 150 130 332.4 2682 112 4/15 23.94 8.06 17.8 4 -
List A 211 - 804.3 4337 130 5/34 33.36 5.39 37.1 4 1
1st Class 83 - 1202.4 3378 92 5/33 36.71 2.80 78.4 - 1
× Close