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:c16fae17-5da8-4f4f-91c9-37a9b8cdf25a Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 108425 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (108425,6,'{"status":"ok","response":{"player":{"pid":108425,"title":"Alex Russell","short_name":"A Russell","first_name":"Alex Russell","last_name":"","middle_name":"","birthdate":"2002-04-17","birthplace":" Newport, Monmouthshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":3,"innings":2,"notout":2,"runs":1,"balls":3,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"33.33","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":9,"notout":8,"runs":14,"balls":42,"highest":7,"run100":0,"run50":0,"run4":0,"run6":0,"average":"14.00","strike":"33.33","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":20,"innings":25,"notout":14,"runs":97,"balls":352,"highest":17,"run100":0,"run50":0,"run4":10,"run6":0,"average":"8.81","strike":"27.55","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"1","notout":"1","runs":"4","balls":"6","highest":"4","run100":"0","run50":"0","run4":"0","run6":"0","average":"","strike":"66.67","catches":"4","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"balls":66,"overs":11,"runs":82,"wickets":2,"bestinning":"1\/27","bestmatch":"1\/27","econ":"7.45","average":"41.00","strike":"33.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":1004,"overs":167.2,"runs":965,"wickets":22,"bestinning":"3\/15","bestmatch":"3\/15","econ":"5.76","average":"43.86","strike":"45.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":20,"innings":31,"balls":3619,"overs":603.1,"runs":2816,"wickets":87,"bestinning":"7\/84","bestmatch":"12\/122","econ":"4.66","average":"32.36","strike":"41.5","wicket4i":1,"wicket5i":10,"wicket10m":4,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"8","balls":"60","overs":"10","runs":"128","wickets":"5","bestinning":"2\/32","bestmatch":"2\/32","econ":"12.80","average":"25.60","strike":"12.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"2380a8e4163dc3973652f25fd8e0b567","modified":"2025-06-13 12:18:59","datetime":"2025-06-13 12:18:59","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":108425,"title":"Alex Russell","short_name":"A Russell","first_name":"Alex Russell","last_name":"","middle_name":"","birthdate":"2002-04-17","birthplace":" Newport, Monmouthshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":3,"innings":2,"notout":2,"runs":1,"balls":3,"highest":1,"run100":0,"run50":0,"run4":0,"run6":0,"average":"","strike":"33.33","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":9,"notout":8,"runs":14,"balls":42,"highest":7,"run100":0,"run50":0,"run4":0,"run6":0,"average":"14.00","strike":"33.33","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":20,"innings":25,"notout":14,"runs":97,"balls":352,"highest":17,"run100":0,"run50":0,"run4":10,"run6":0,"average":"8.81","strike":"27.55","catches":3,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"1","notout":"1","runs":"4","balls":"6","highest":"4","run100":"0","run50":"0","run4":"0","run6":"0","average":"","strike":"66.67","catches":"4","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":3,"innings":3,"balls":66,"overs":11,"runs":82,"wickets":2,"bestinning":"1\/27","bestmatch":"1\/27","econ":"7.45","average":"41.00","strike":"33.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":1004,"overs":167.2,"runs":965,"wickets":22,"bestinning":"3\/15","bestmatch":"3\/15","econ":"5.76","average":"43.86","strike":"45.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":20,"innings":31,"balls":3619,"overs":603.1,"runs":2816,"wickets":87,"bestinning":"7\/84","bestmatch":"12\/122","econ":"4.66","average":"32.36","strike":"41.5","wicket4i":1,"wicket5i":10,"wicket10m":4,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"9","innings":"8","balls":"60","overs":"10","runs":"128","wickets":"5","bestinning":"2\/32","bestmatch":"2\/32","econ":"12.80","average":"25.60","strike":"12.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"2380a8e4163dc3973652f25fd8e0b567","modified":"2025-06-13 12:18:59","datetime":"2025-06-13 12:18:59","api_version":"3.0"}', Modified = GetDate() WHERE Id = 108425 AND DataTypeId = 6 END
Player profile of Alex Russell, England
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVETodayFinal

South AfricaSouth Africa138/10 (57.1 ov) & *9/0 (2 ov)

Australia212/10 (56.4 ov) & 207/10 (65 ov)

 Day 3 - Session 2, South Africa need 273 runs to win.
LIVETodayMatch 15

Satara WarriorsSatara Warriors115/10 (19.5 ov)

Eagle Nashik Titans*111/7 (16.3 ov)

 Eagle Nashik Titans need 5 runs in 21 remaining balls
LIVEToday1st Semi-Final

Bharat RangersBharat Rangers204/3 (20 ov)

NECO Master Blaster*119/1 (11.4 ov)

 NECO Master Blaster need 86 runs in 50 remaining balls
LIVETodayMatch 2

Jabalpur LionsJabalpur Lions

Bhopal Leopards*130/6 (16.0 ov)

 Rain Delay : Jabalpur Lions elected to bowl
LIVETodayMatch 6

Netherlands WomenNetherlands Women149/7 (20 ov)

United States of America Women*49/7 (10.4 ov)

 United States of America Women need 101 runs in 56 remaining balls
LIVEToday2nd Semi-Final

HornchurchHornchurch130/3 (10 ov)

Sharks Cricket Academy136/4 (8.3 ov)

 Sharks Cricket Academy won by 6 wickets
LIVETodayMatch 6

Austria WomenAustria Women

Czechia Women*0/0 ( ov)

 Match Start Delay : Czechia Women elected to bat
Scheduled13 June Match 16

Ratnagiri JetsRatnagiri Jets

Kolhapur Tuskers

 
Scheduled13 June Match 5

Murshidabd KingsMurshidabd Kings

Harbour Diamonds

 
Scheduled13 June Match 9

IDream Tiruppur TamizhansIDream Tiruppur Tamizhans

Salem Spartans

 
Scheduled13 June 3rd Place Play-Off

Mighty TigersMighty Tigers

TBA

 
Scheduled13 June Match 3

Bundelkhand BullsBundelkhand Bulls

Rewa Jaguars

 
Scheduled13 June Match 11

Zalwad StrikersZalwad Strikers

Anmol Kings Halar

 
Scheduled13 June 2nd Semi-Final

Pagariya StrikersPagariya Strikers

Orange Tigers

 
Scheduled13 June Match 1

YSSCYSSC

Phoenix Cricketers

 
Scheduled13 June Final

Old BrentwoodsOld Brentwoods

TBA

 
Scheduled13 June Match 9

Soca KingsSoca Kings

Leatherback Strikers

 
Scheduled13 June Match 48

WorcestershireWorcestershire

Lancashire

 
CricDirect Cricket News, Results and Stats
 

Alex Russell

NationalityEngland
RoleBowler
Born17 Apr 2002 (23)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Leg Spin

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 3 2 2 1 1 - 3 33.33 - -
List A 20 9 8 14 7 14.00 42 33.33 - -
1st Class 20 25 14 97 17 8.81 352 27.55 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 3 3 11 82 2 1/27 41.00 7.45 33.0 - -
List A 20 20 167.2 965 22 3/15 43.86 5.76 45.6 - -
1st Class 20 31 603.1 2816 87 7/84 32.36 4.66 41.5 1 10
× Close