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:7c26715f-47da-41cb-aca1-f4151496452c Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 26362 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (26362,6,'{"status":"ok","response":{"player":{"pid":26362,"title":"Bradley Scott","short_name":"BE Scott","first_name":"Bradley Scott","last_name":"","middle_name":"","birthdate":"1979-09-16","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast 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":61,"innings":34,"notout":17,"runs":273,"balls":227,"highest":22,"run100":0,"run50":0,"run4":20,"run6":8,"average":"16.05","strike":"120.26","catches":16,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":103,"innings":66,"notout":26,"runs":691,"balls":0,"highest":44,"run100":0,"run50":0,"run4":0,"run6":0,"average":"17.27","strike":"","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":66,"innings":88,"notout":25,"runs":1361,"balls":0,"highest":96,"run100":0,"run50":6,"run4":0,"run6":0,"average":"21.60","strike":"","catches":20,"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":61,"innings":58,"balls":1174,"overs":195.4,"runs":1572,"wickets":64,"bestinning":"4\/13","bestmatch":"4\/13","econ":"8.03","average":"24.56","strike":"18.30","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":103,"innings":0,"balls":4961,"overs":826.5,"runs":4134,"wickets":117,"bestinning":"4\/63","bestmatch":"4\/63","econ":"4.99","average":"35.33","strike":"42.40","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":66,"innings":0,"balls":11806,"overs":1967.4,"runs":5115,"wickets":182,"bestinning":"6\/20","bestmatch":"","econ":"2.59","average":"28.10","strike":"64.8","wicket4i":0,"wicket5i":5,"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":"12d5617160b246f2c1f7b8eb5ec4bfff","modified":"2025-06-10 14:55:02","datetime":"2025-06-10 14:55:02","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":26362,"title":"Bradley Scott","short_name":"BE Scott","first_name":"Bradley Scott","last_name":"","middle_name":"","birthdate":"1979-09-16","birthplace":"","country":"nz","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast 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":61,"innings":34,"notout":17,"runs":273,"balls":227,"highest":22,"run100":0,"run50":0,"run4":20,"run6":8,"average":"16.05","strike":"120.26","catches":16,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":103,"innings":66,"notout":26,"runs":691,"balls":0,"highest":44,"run100":0,"run50":0,"run4":0,"run6":0,"average":"17.27","strike":"","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":66,"innings":88,"notout":25,"runs":1361,"balls":0,"highest":96,"run100":0,"run50":6,"run4":0,"run6":0,"average":"21.60","strike":"","catches":20,"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":61,"innings":58,"balls":1174,"overs":195.4,"runs":1572,"wickets":64,"bestinning":"4\/13","bestmatch":"4\/13","econ":"8.03","average":"24.56","strike":"18.30","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":103,"innings":0,"balls":4961,"overs":826.5,"runs":4134,"wickets":117,"bestinning":"4\/63","bestmatch":"4\/63","econ":"4.99","average":"35.33","strike":"42.40","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":66,"innings":0,"balls":11806,"overs":1967.4,"runs":5115,"wickets":182,"bestinning":"6\/20","bestmatch":"","econ":"2.59","average":"28.10","strike":"64.8","wicket4i":0,"wicket5i":5,"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":"12d5617160b246f2c1f7b8eb5ec4bfff","modified":"2025-06-10 14:55:02","datetime":"2025-06-10 14:55:02","api_version":"3.0"}', Modified = GetDate() WHERE Id = 26362 AND DataTypeId = 6 END
Player profile of Bradley Scott, 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 5

South Africa ASouth Africa A*324/7 (102 ov)

West Indies A220/10 (68.1 ov)

 Stumps : Day 2 - South Africa A lead by 104 runs.
LIVETodayMatch 78

NetherlandsNetherlands*39/1 (7 ov)

Nepal236/9 (50 ov)

 Netherlands need 198 runs in 43.0 remaining overs
LIVETodayMatch 27

Zimbabwe HPC WomenZimbabwe HPC Women163/6 (20 ov)

Cameroon Women*74/8 (20 ov)

 Match completed
LIVETodayMatch 28

Brazil WomenBrazil Women*87/5 (19.5 ov)

Rwanda Women96/10 (20 ov)

 Brazil Women need 10 runs in 1 remaining balls
LIVETodayMatch 6

NorwayNorway149/8 (20 ov)

Austria

 Innings Break : Norway elected to bat
LIVETodayMatch 11

Puneri BappaPuneri Bappa*79/3 (11.3 ov)

Eagle Nashik Titans

 Eagle Nashik Titans elected to bowl
LIVETodayMatch 7

Salem SpartansSalem Spartans*72/3 (9.2 ov)

Trichy Grand Chola

 Trichy Grand Chola elected to bowl
LIVEToday2nd Semi Final

SOBO Mumbai FalconsSOBO Mumbai Falcons

Namo Bandra Blasters*69/3 (12 ov)

 SOBO Mumbai Falcons elected to bowl
LIVETodayMatch 6

Dita Gohilwad TitansDita Gohilwad Titans*94/2 (11.2 ov)

JMD Kutch Riders

 JMD Kutch Riders elected to bowl
LIVETodayMatch 11

Nagpur HerozNagpur Heroz*12/1 (2 ov)

Nagpur Titans

 Rain Delay : Nagpur Titans elected to bowl
LIVETodayMatch 34

Old BrentwoodsOld Brentwoods*19/0 (1 ov)

Havering XI

 Old Brentwoods elected to bat
Scheduled10 June Match 3

Soca KingsSoca Kings

Scarlet Ibis Scorchers

 
Scheduled10 June Match 35

East LondonersEast Londoners

Havering XI

 
Scheduled10 June 3rd T20I

EnglandEngland

West Indies

 
Scheduled10 June Match 4

Leatherback StrikersLeatherback Strikers

Chicago Steelpan Players

 
Scheduled11 June Match 1

IndonesiaIndonesia

Cambodia

 
Scheduled11 June Match 2

Nagpur Titans WomenNagpur Titans Women

NECO Master Blaster Women

 
Scheduled11 June Match 9

Ratnagiri Jets WomenRatnagiri Jets Women

Pune Warriors Women

 
CricDirect Cricket News, Results and Stats
 

Bradley Scott

NationalityNew Zealand
RoleBatter
Born16 Sep 1979 (45)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 61 34 17 273 22 16.05 227 120.26 - -
List A 103 66 26 691 44 17.27 - - - -
1st Class 66 88 25 1361 96 21.60 - - - 6

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 61 58 195.4 1572 64 4/13 24.56 8.03 18.30 1 -
List A 103 - 826.5 4134 117 4/63 35.33 4.99 42.40 1 -
1st Class 66 - 1967.4 5115 182 6/20 28.10 2.59 64.8 - 5
× Close