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:4d5934ce-2291-485c-a194-b2897a64e3a5 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 60298 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (60298,6,'{"status":"ok","response":{"player":{"pid":60298,"title":"Dian Forrester","short_name":"D Forrester","first_name":"Dian Forrester","last_name":"","middle_name":"","birthdate":"2000-06-07","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":11,"innings":11,"notout":3,"runs":266,"balls":209,"highest":57,"run100":0,"run50":1,"run4":10,"run6":10,"average":"33.25","strike":"127.27","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":15,"innings":15,"notout":3,"runs":699,"balls":662,"highest":128,"run100":3,"run50":2,"run4":47,"run6":29,"average":"58.25","strike":"105.58","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":21,"notout":3,"runs":723,"balls":1095,"highest":127,"run100":2,"run50":4,"run4":94,"run6":13,"average":"40.16","strike":"66.02","catches":14,"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":11,"innings":9,"balls":126,"overs":21,"runs":172,"wickets":8,"bestinning":"3\/30","bestmatch":"3\/30","econ":"8.19","average":"21.50","strike":"15.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":15,"innings":14,"balls":401,"overs":66.5,"runs":374,"wickets":17,"bestinning":"6\/48","bestmatch":"6\/48","econ":"5.59","average":"22.00","strike":"23.5","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":22,"balls":1064,"overs":177.2,"runs":675,"wickets":14,"bestinning":"2\/10","bestmatch":"3\/50","econ":"3.80","average":"48.21","strike":"76.0","wicket4i":0,"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":"a0b510f9fad63e68fb07c7127641f45c","modified":"2025-07-23 01:00:17","datetime":"2025-07-23 01:00:17","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":60298,"title":"Dian Forrester","short_name":"D Forrester","first_name":"Dian Forrester","last_name":"","middle_name":"","birthdate":"2000-06-07","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"South Africa"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":11,"innings":11,"notout":3,"runs":266,"balls":209,"highest":57,"run100":0,"run50":1,"run4":10,"run6":10,"average":"33.25","strike":"127.27","catches":5,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":15,"innings":15,"notout":3,"runs":699,"balls":662,"highest":128,"run100":3,"run50":2,"run4":47,"run6":29,"average":"58.25","strike":"105.58","catches":6,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":21,"notout":3,"runs":723,"balls":1095,"highest":127,"run100":2,"run50":4,"run4":94,"run6":13,"average":"40.16","strike":"66.02","catches":14,"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":11,"innings":9,"balls":126,"overs":21,"runs":172,"wickets":8,"bestinning":"3\/30","bestmatch":"3\/30","econ":"8.19","average":"21.50","strike":"15.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":15,"innings":14,"balls":401,"overs":66.5,"runs":374,"wickets":17,"bestinning":"6\/48","bestmatch":"6\/48","econ":"5.59","average":"22.00","strike":"23.5","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":13,"innings":22,"balls":1064,"overs":177.2,"runs":675,"wickets":14,"bestinning":"2\/10","bestmatch":"3\/50","econ":"3.80","average":"48.21","strike":"76.0","wicket4i":0,"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":"a0b510f9fad63e68fb07c7127641f45c","modified":"2025-07-23 01:00:17","datetime":"2025-07-23 01:00:17","api_version":"3.0"}', Modified = GetDate() WHERE Id = 60298 AND DataTypeId = 6 END
Player profile of Dian Forrester, South Africa
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday2nd Unofficial Test

Australia AAustralia A*379/3 (103 ov)

Sri Lanka A485/6d (157 ov)

 Stumps : Day 3 - Australia A trail by 106 runs.
LIVEToday2nd Youth Test

England Under-19sEngland Under-19s309/10 (81.3 ov) & *93/0 (25 ov)

India Under-19s279/10 (58.1 ov)

 Stumps : Day 3 - England Under-19s lead by 123 runs.
LIVEToday47th Match

HampshireHampshire

Nottinghamshire*242/5 (62.1 ov)

 Stumps : Day 1 - Hampshire elected to bowl
LIVEToday46th Match

SomersetSomerset250/10 (49.3 ov)

Durham145/10 (30.1 ov) & *5/2 (3 ov)

 Stumps : Day 1 - Durham trail by 100 runs.
LIVEToday48th Match

SussexSussex204/10 (52.4 ov)

Essex*152/4 (43 ov)

 Stumps : Day 1 - Essex trail by 52 runs.
LIVEToday50th Match

WarwickshireWarwickshire

Worcestershire*262/8 (93 ov)

 Stumps : Day 1 - Worcestershire elected to bat
LIVEToday49th Match

YorkshireYorkshire*282/4 (86 ov)

Surrey

 Stumps : Day 1 - Yorkshire elected to bat
LIVEToday39th Match

DerbyshireDerbyshire

Leicestershire*357/3 (96 ov)

 Stumps : Day 1 - Leicestershire elected to bat
LIVEToday37th Match

GlamorganGlamorgan*125/4 (42 ov)

Kent155/9 (53.2 ov)

 Stumps : Day 1 - Glamorgan trail by 30 runs.
LIVEToday40th Match

GloucestershireGloucestershire

Lancashire*290/6 (91 ov)

 Stumps : Day 1 - Lancashire elected to bat
LIVEToday38th Match

MiddlesexMiddlesex*319/1 (80 ov)

Northamptonshire

 Stumps : Day 1 - Northamptonshire elected to bowl
LIVEToday2nd T20I

West IndiesWest Indies*17/0 (3.3 ov)

Australia

 Australia elected to bowl
ScheduledTodayMatch 9

Hong KongHong Kong

Samoa

 
Scheduled23 July 1st Semi-Final

Bud CCBud CC

Nabajyoti Club

 
Scheduled23 July Match 10

SingaporeSingapore

Malaysia

 
Scheduled23 July Match 11

United Arab EmiratesUnited Arab Emirates

Kenya

 
Scheduled23 July Match 1

Alby Zalmi CFAlby Zalmi CF

Huddinge

 
Scheduled23 July Match 8

MalawiMalawi

Rwanda

 
CricDirect Cricket News, Results and Stats
 

Dian Forrester

NationalitySouth Africa
RoleAll Rounder
Born07 Jun 2000 (25)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 11 11 3 266 57 33.25 209 127.27 - 1
List A 15 15 3 699 128 58.25 662 105.58 3 2
1st Class 13 21 3 723 127 40.16 1095 66.02 2 4

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 11 9 21 172 8 3/30 21.50 8.19 15.7 - -
List A 15 14 66.5 374 17 6/48 22.00 5.59 23.5 - 1
1st Class 13 22 177.2 675 14 2/10 48.21 3.80 76.0 - -
× Close