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:1890d2e9-c304-43ab-8800-26f6f6d7c587 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 52996 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (52996,6,'{"status":"ok","response":{"player":{"pid":52996,"title":"Craig Alexander","short_name":"CJ Alexander","first_name":"Craig Alexander","last_name":"","middle_name":"","birthdate":"1987-01-05","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.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":63,"innings":60,"notout":12,"runs":1456,"balls":109,"highest":0,"run100":0,"run50":0,"run4":6,"run6":7,"average":"29.12","strike":"22.70","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":113,"innings":0,"notout":22,"runs":4175,"balls":301,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"28.40","strike":"32.00","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":129,"innings":149,"notout":46,"runs":1330,"balls":1919,"highest":59,"run100":0,"run50":4,"run4":0,"run6":0,"average":"12.91","strike":"69.30","catches":35,"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":63,"innings":23,"balls":1138,"overs":189.4,"runs":118,"wickets":50,"bestinning":"4\/11","bestmatch":"4\/11","econ":"7.67","average":"10.72","strike":"108.25","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":113,"innings":62,"balls":4628,"overs":771.2,"runs":242,"wickets":146,"bestinning":"5\/42","bestmatch":"5\/42","econ":"5.30","average":"6.36","strike":"77.07","wicket4i":6,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":129,"innings":0,"balls":17711,"overs":2951.5,"runs":10975,"wickets":374,"bestinning":"6\/38","bestmatch":"","econ":"3.71","average":"29.34","strike":"47.3","wicket4i":11,"wicket5i":18,"wicket10m":1,"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":"692ab668253f0111455a72329e00a07b","modified":"2025-07-06 14:38:46","datetime":"2025-07-06 14:38:46","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":52996,"title":"Craig Alexander","short_name":"CJ Alexander","first_name":"Craig Alexander","last_name":"","middle_name":"","birthdate":"1987-01-05","birthplace":"","country":"za","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.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":63,"innings":60,"notout":12,"runs":1456,"balls":109,"highest":0,"run100":0,"run50":0,"run4":6,"run6":7,"average":"29.12","strike":"22.70","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":113,"innings":0,"notout":22,"runs":4175,"balls":301,"highest":0,"run100":0,"run50":0,"run4":0,"run6":0,"average":"28.40","strike":"32.00","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":129,"innings":149,"notout":46,"runs":1330,"balls":1919,"highest":59,"run100":0,"run50":4,"run4":0,"run6":0,"average":"12.91","strike":"69.30","catches":35,"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":63,"innings":23,"balls":1138,"overs":189.4,"runs":118,"wickets":50,"bestinning":"4\/11","bestmatch":"4\/11","econ":"7.67","average":"10.72","strike":"108.25","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":113,"innings":62,"balls":4628,"overs":771.2,"runs":242,"wickets":146,"bestinning":"5\/42","bestmatch":"5\/42","econ":"5.30","average":"6.36","strike":"77.07","wicket4i":6,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":129,"innings":0,"balls":17711,"overs":2951.5,"runs":10975,"wickets":374,"bestinning":"6\/38","bestmatch":"","econ":"3.71","average":"29.34","strike":"47.3","wicket4i":11,"wicket5i":18,"wicket10m":1,"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":"692ab668253f0111455a72329e00a07b","modified":"2025-07-06 14:38:46","datetime":"2025-07-06 14:38:46","api_version":"3.0"}', Modified = GetDate() WHERE Id = 52996 AND DataTypeId = 6 END
Player profile of Craig Alexander, 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 Test

EnglandEngland407/10 (89.3 ov) & *180/6 (48.1 ov)

India587/10 (151 ov) & 427/6d (83 ov)

 Day 5 - Session 2, England need 428 runs to win.
LIVEToday2nd Test

West IndiesWest Indies253/10 (73.2 ov)

Australia286/10 (66.5 ov) & *242/9 (70.4 ov)

 Day 4 - Session 1, Australia lead by 275 runs.
LIVEToday2nd Test

ZimbabweZimbabwe

South Africa*403/3 (78.1 ov)

 Day 1 - Session 3, Zimbabwe elected to bowl
LIVETodayMatch 40

Surrey WomenSurrey Women159/5 (20 ov)

Essex Women93/5 (10 ov)

 Match Tie
LIVETodayMatch 3

BahrainBahrain207/2 (20 ov)

Germany*116/6 (14.2 ov)

 Germany need 92 runs in 34 remaining balls
LIVETodayMatch 38

Lancashire WomenLancashire Women*115/3 (17.0 ov)

Warwickshire Women123/7 (20 ov)

 Lancashire Women need 9 runs in 18 remaining balls
LIVETodayMatch 1

Ossudu Accord WarriorsOssudu Accord Warriors

Ruby White Town legends*131/7 (19 ov)

 Ossudu Accord Warriors elected to bowl
LIVETodayMatch 86

GlamorganGlamorgan

Kent*91/8 (16.4 ov)

 Glamorgan elected to bowl
LIVETodayMatch 87

DurhamDurham0/0 ( ov)

Warwickshire

 Rain Delay : Warwickshire elected to bowl
LIVETodayMatch 88

DerbyshireDerbyshire

Yorkshire*157/5 (17.2 ov)

 Derbyshire elected to bowl
LIVETodayFinal

IDream Tiruppur TamizhansIDream Tiruppur Tamizhans*121/0 (10.3 ov)

Dindigul Dragons

 Dindigul Dragons elected to bowl
LIVETodayFinal

Sofia StarsSofia Stars

MUS Akademik Ravens120/8 (10 ov)

 Innings Break : Sofia Stars elected to bowl
LIVETodayMatch 82

NottinghamshireNottinghamshire

Leicestershire*93/0 (10 ov)

 Leicestershire elected to bat
LIVETodayMatch 83

NorthamptonshireNorthamptonshire*4/0 (0.5 ov)

Worcestershire

 Worcestershire elected to bowl
LIVETodayMatch 84

HampshireHampshire*0/0 ( ov)

Somerset

 Rain Delay : Somerset elected to bowl
LIVETodayMatch 4

ItalyItaly

Jersey

 Toss delayed due to rain
LIVETodayMatch 8

Typhoons WomenTyphoons Women

Dragons Women*67/0 (6 ov)

 Dragons Women elected to bat
CancelledTodayMatch 3

GuernseyGuernsey

Scotland

 Match abandoned
CricDirect Cricket News, Results and Stats
 

Craig Alexander

NationalitySouth Africa
RoleBowler
Born05 Jan 1987 (38)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 63 60 12 1456 - 29.12 109 22.70 - -
List A 113 - 22 4175 - 28.40 301 32.00 - -
1st Class 129 149 46 1330 59 12.91 1919 69.30 - 4

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 63 23 189.4 118 50 4/11 10.72 7.67 108.25 2 -
List A 113 62 771.2 242 146 5/42 6.36 5.30 77.07 6 2
1st Class 129 - 2951.5 10975 374 6/38 29.34 3.71 47.3 11 18
× Close