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:6bef042c-2574-4abd-b86a-16c8ed3d6b74 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 16562 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (16562,6,'{"status":"ok","response":{"player":{"pid":16562,"title":"Sam Wells","short_name":"SR Wells","first_name":"Sam Wells","last_name":"","middle_name":"","birthdate":"1984-07-13","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"New Zealand"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":37,"innings":23,"notout":8,"runs":202,"balls":185,"highest":35,"run100":0,"run50":0,"run4":13,"run6":8,"average":"13.46","strike":"109.18","catches":19,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":43,"innings":40,"notout":2,"runs":817,"balls":1030,"highest":93,"run100":0,"run50":5,"run4":80,"run6":15,"average":"21.50","strike":"79.32","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":63,"innings":98,"notout":11,"runs":2707,"balls":5174,"highest":118,"run100":4,"run50":20,"run4":363,"run6":24,"average":"31.11","strike":"52.31","catches":18,"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":{"t20":{"match_id":0,"inning_id":0,"matches":37,"innings":21,"balls":266,"overs":44.2,"runs":395,"wickets":19,"bestinning":"4\/24","bestmatch":"4\/24","econ":"8.90","average":"20.78","strike":"14.00","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":43,"innings":37,"balls":1580,"overs":263.2,"runs":1466,"wickets":39,"bestinning":"5\/41","bestmatch":"5\/41","econ":"5.56","average":"37.58","strike":"40.50","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":63,"innings":99,"balls":7711,"overs":1285.1,"runs":4349,"wickets":115,"bestinning":"5\/26","bestmatch":"7\/102","econ":"3.38","average":"37.81","strike":"67.0","wicket4i":2,"wicket5i":3,"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":"fc49895800c2ffae8cea1285784cdf44","modified":"2025-06-11 02:56:37","datetime":"2025-06-11 02:56:37","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":16562,"title":"Sam Wells","short_name":"SR Wells","first_name":"Sam Wells","last_name":"","middle_name":"","birthdate":"1984-07-13","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"New Zealand"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":37,"innings":23,"notout":8,"runs":202,"balls":185,"highest":35,"run100":0,"run50":0,"run4":13,"run6":8,"average":"13.46","strike":"109.18","catches":19,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":43,"innings":40,"notout":2,"runs":817,"balls":1030,"highest":93,"run100":0,"run50":5,"run4":80,"run6":15,"average":"21.50","strike":"79.32","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":63,"innings":98,"notout":11,"runs":2707,"balls":5174,"highest":118,"run100":4,"run50":20,"run4":363,"run6":24,"average":"31.11","strike":"52.31","catches":18,"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":{"t20":{"match_id":0,"inning_id":0,"matches":37,"innings":21,"balls":266,"overs":44.2,"runs":395,"wickets":19,"bestinning":"4\/24","bestmatch":"4\/24","econ":"8.90","average":"20.78","strike":"14.00","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":43,"innings":37,"balls":1580,"overs":263.2,"runs":1466,"wickets":39,"bestinning":"5\/41","bestmatch":"5\/41","econ":"5.56","average":"37.58","strike":"40.50","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":63,"innings":99,"balls":7711,"overs":1285.1,"runs":4349,"wickets":115,"bestinning":"5\/26","bestmatch":"7\/102","econ":"3.38","average":"37.81","strike":"67.0","wicket4i":2,"wicket5i":3,"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":"fc49895800c2ffae8cea1285784cdf44","modified":"2025-06-11 02:56:37","datetime":"2025-06-11 02:56:37","api_version":"3.0"}', Modified = GetDate() WHERE Id = 16562 AND DataTypeId = 6 END
Player profile of Sam Wells, New Zealand
CricDirect Cricket News, Results and Stats
 

Sam Wells

NationalityNew Zealand
RoleBatter
Born13 Jul 1984 (40)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 37 23 8 202 35 13.46 185 109.18 - -
List A 43 40 2 817 93 21.50 1030 79.32 - 5
1st Class 63 98 11 2707 118 31.11 5174 52.31 4 20

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 37 21 44.2 395 19 4/24 20.78 8.90 14.00 1 -
List A 43 37 263.2 1466 39 5/41 37.58 5.56 40.50 - 1
1st Class 63 99 1285.1 4349 115 5/26 37.81 3.38 67.0 2 3
× Close