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:b7fc90f6-4e84-4810-a56d-55adb81cb036 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 60737 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (60737,6,'{"status":"ok","response":{"player":{"pid":60737,"title":"Michael Snedden","short_name":"Michael Snedden","first_name":"Michael Snedden","last_name":"","middle_name":"","birthdate":"1992-09-20","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"New Zealand"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":3,"notout":2,"runs":4,"balls":6,"highest":2,"run100":0,"run50":0,"run4":0,"run6":0,"average":"4.00","strike":"66.66","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":12,"notout":7,"runs":77,"balls":147,"highest":21,"run100":0,"run50":0,"run4":7,"run6":0,"average":"15.40","strike":"52.38","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":32,"innings":52,"notout":17,"runs":403,"balls":1310,"highest":90,"run100":0,"run50":1,"run4":31,"run6":6,"average":"11.51","strike":"30.76","catches":15,"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":16,"innings":14,"balls":234,"overs":39,"runs":326,"wickets":13,"bestinning":"2\/22","bestmatch":"2\/22","econ":"8.35","average":"25.07","strike":"18.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":20,"balls":836,"overs":139.2,"runs":855,"wickets":23,"bestinning":"3\/26","bestmatch":"3\/26","econ":"6.13","average":"37.17","strike":"36.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":32,"innings":57,"balls":4695,"overs":782.3,"runs":2416,"wickets":71,"bestinning":"4\/24","bestmatch":"5\/79","econ":"3.08","average":"34.02","strike":"66.1","wicket4i":1,"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":"ad9a450e728b6a0e9879f4b5234b826a","modified":"2025-06-16 21:55:05","datetime":"2025-06-16 21:55:05","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":60737,"title":"Michael Snedden","short_name":"Michael Snedden","first_name":"Michael Snedden","last_name":"","middle_name":"","birthdate":"1992-09-20","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"New Zealand"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":3,"notout":2,"runs":4,"balls":6,"highest":2,"run100":0,"run50":0,"run4":0,"run6":0,"average":"4.00","strike":"66.66","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":12,"notout":7,"runs":77,"balls":147,"highest":21,"run100":0,"run50":0,"run4":7,"run6":0,"average":"15.40","strike":"52.38","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":32,"innings":52,"notout":17,"runs":403,"balls":1310,"highest":90,"run100":0,"run50":1,"run4":31,"run6":6,"average":"11.51","strike":"30.76","catches":15,"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":16,"innings":14,"balls":234,"overs":39,"runs":326,"wickets":13,"bestinning":"2\/22","bestmatch":"2\/22","econ":"8.35","average":"25.07","strike":"18.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":20,"balls":836,"overs":139.2,"runs":855,"wickets":23,"bestinning":"3\/26","bestmatch":"3\/26","econ":"6.13","average":"37.17","strike":"36.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":32,"innings":57,"balls":4695,"overs":782.3,"runs":2416,"wickets":71,"bestinning":"4\/24","bestmatch":"5\/79","econ":"3.08","average":"34.02","strike":"66.1","wicket4i":1,"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":"ad9a450e728b6a0e9879f4b5234b826a","modified":"2025-06-16 21:55:05","datetime":"2025-06-16 21:55:05","api_version":"3.0"}', Modified = GetDate() WHERE Id = 60737 AND DataTypeId = 6 END
Player profile of Michael Snedden, New Zealand
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVETodayMatch 4

BermudaBermuda*85/3 (8.5 ov)

Bahamas90/8 (20 ov)

 Bermuda need 6 runs in 11.1 remaining overs
LIVETodayMatch 18

SAMP Army Cocrico CavaliersSAMP Army Cocrico Cavaliers

Leatherback Strikers*99/5 (8.3 ov)

 SAMP Army Cocrico Cavaliers elected to bowl
Cancelled16 June Match 21

Ratnagiri JetsRatnagiri Jets

Raigad Royals

 Match Abandoned due to rain
Cancelled16 June Match 10

Lux Shyam Kolkata TigersLux Shyam Kolkata Tigers178/4 (20 ov)

Servotech Siliguri Strikers35/0 (3 ov)

 Match abandoned due to rain
Cancelled16 June Match 10

Murshidabd Kueens WomensMurshidabd Kueens Womens

Shrachi Rarh Tigers Womens69/9 (19 ov)

 Match abandoned due to rain
Cancelled16 June Match 22

Kolhapur TuskersKolhapur Tuskers

Eagle Nashik Titans

 Match abandoned due to rain
Cancelled16 June Match 2

Alembic WarriorsAlembic Warriors

Pruthvi Panthers97/4 (12.3 ov)

 Match abandoned due to rain
CancelledTodayMatch 23

Puneri BappaPuneri Bappa

Satara Warriors0/0 ( ov)

 Match Abandoned
CancelledTodayMatch 16

Aryan Sorath LionsAryan Sorath Lions

Dita Gohilwad Titans

 Match Abandoned
Scheduled17 June Match 7

Texas Super KingsTexas Super Kings

Seattle Orcas

 
Scheduled17 June Match 5

Pakyong XIPakyong XI

Irises Cricket Club

 
Scheduled17 June Match 11

Servotech Siliguri Strikers WomensServotech Siliguri Strikers Womens

Rashmi Medinipur Wizards Womens

 
Cancelled17 June Match 18

Eagle Nashik TitansEagle Nashik Titans

Puneri Bappa

 Match Abandoned
Scheduled17 June 1st Test

Sri LankaSri Lanka

Bangladesh

 
Scheduled17 June Match 16

Aryan Sorath LionsAryan Sorath Lions

Dita Gohilwad Titans

 
Scheduled17 June Match 16

Ratnagiri JetsRatnagiri Jets

Kolhapur Tuskers

 
Scheduled17 June Match 6

Vinohrady CCVinohrady CC

Praha Dominators

 
Scheduled17 June Match 6

Royal North BrothersRoyal North Brothers

Black Eagle SAP

 
CricDirect Cricket News, Results and Stats
 

Michael Snedden

NationalityNew Zealand
RoleBowler
Born20 Sep 1992 (32)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 16 3 2 4 2 4.00 6 66.66 - -
List A 20 12 7 77 21 15.40 147 52.38 - -
1st Class 32 52 17 403 90 11.51 1310 30.76 - 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 16 14 39 326 13 2/22 25.07 8.35 18.0 - -
List A 20 20 139.2 855 23 3/26 37.17 6.13 36.3 - -
1st Class 32 57 782.3 2416 71 4/24 34.02 3.08 66.1 1 -
× Close