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:9f9eb102-eee4-4540-91d9-4c095ef8b0be Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 49345 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (49345,6,'{"status":"ok","response":{"player":{"pid":49345,"title":"Billy Root","short_name":"WT Root","first_name":"Billy Root","last_name":"","middle_name":"","birthdate":"1992-08-05","birthplace":" Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/billyroot07\/","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":50,"innings":39,"notout":9,"runs":634,"balls":567,"highest":41,"run100":0,"run50":0,"run4":48,"run6":15,"average":"21.13","strike":"111.81","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":55,"innings":47,"notout":10,"runs":1604,"balls":1770,"highest":113,"run100":3,"run50":8,"run4":128,"run6":21,"average":"43.35","strike":"90.62","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":78,"innings":132,"notout":13,"runs":4023,"balls":7409,"highest":229,"run100":7,"run50":17,"run4":515,"run6":17,"average":"33.80","strike":"54.29","catches":23,"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":50,"innings":3,"balls":18,"overs":3,"runs":37,"wickets":0,"bestinning":"","bestmatch":"","econ":"12.33","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":55,"innings":11,"balls":292,"overs":48.4,"runs":310,"wickets":6,"bestinning":"2\/36","bestmatch":"2\/36","econ":"6.36","average":"51.66","strike":"48.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":78,"innings":18,"balls":389,"overs":64.5,"runs":275,"wickets":8,"bestinning":"3\/29","bestmatch":"3\/29","econ":"4.24","average":"34.37","strike":"48.6","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":"0cbbfbb7d4b6013c8b770c6583affd98","modified":"2025-06-20 16:49:47","datetime":"2025-06-20 16:49:47","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":49345,"title":"Billy Root","short_name":"WT Root","first_name":"Billy Root","last_name":"","middle_name":"","birthdate":"1992-08-05","birthplace":" Sheffield, Yorkshire","country":"en","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/billyroot07\/","debut_data":"","thumb_url":"","nationality":"England"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":50,"innings":39,"notout":9,"runs":634,"balls":567,"highest":41,"run100":0,"run50":0,"run4":48,"run6":15,"average":"21.13","strike":"111.81","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":55,"innings":47,"notout":10,"runs":1604,"balls":1770,"highest":113,"run100":3,"run50":8,"run4":128,"run6":21,"average":"43.35","strike":"90.62","catches":13,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":78,"innings":132,"notout":13,"runs":4023,"balls":7409,"highest":229,"run100":7,"run50":17,"run4":515,"run6":17,"average":"33.80","strike":"54.29","catches":23,"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":50,"innings":3,"balls":18,"overs":3,"runs":37,"wickets":0,"bestinning":"","bestmatch":"","econ":"12.33","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":55,"innings":11,"balls":292,"overs":48.4,"runs":310,"wickets":6,"bestinning":"2\/36","bestmatch":"2\/36","econ":"6.36","average":"51.66","strike":"48.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":78,"innings":18,"balls":389,"overs":64.5,"runs":275,"wickets":8,"bestinning":"3\/29","bestmatch":"3\/29","econ":"4.24","average":"34.37","strike":"48.6","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":"0cbbfbb7d4b6013c8b770c6583affd98","modified":"2025-06-20 16:49:47","datetime":"2025-06-20 16:49:47","api_version":"3.0"}', Modified = GetDate() WHERE Id = 49345 AND DataTypeId = 6 END
Player profile of Billy Root, England
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

Sri LankaSri Lanka485/10 (131.2 ov)

Bangladesh495/10 (153.4 ov) & *177/3 (57 ov)

 Stumps : Day 4 - Bangladesh lead by 187 runs.
LIVEToday1st Test

EnglandEngland

India*312/3 (75 ov)

 Day 1 - Session 3, England elected to bowl
LIVETodayEliminator

Raigad RoyalsRaigad Royals

Kolhapur Tuskers*151/7 (19.3 ov)

 Raigad Royals elected to bowl
LIVETodayMatch 19

Lux Shyam Kolkata TigersLux Shyam Kolkata Tigers160/8 (20 ov)

Shrachi Rarh Tigers*110/3 (14.3 ov)

 Shrachi Rarh Tigers need 51 runs in 33 remaining balls
LIVETodayMatch 32

Warwickshire WomenWarwickshire Women172/6 (20 ov)

The Blaze*145/7 (19.2 ov)

 The Blaze need 28 runs in 4 remaining balls
LIVEToday6th T20I

ScotlandScotland193/5 (20 ov)

Nepal*106/6 (14 ov)

 Nepal need 88 runs in 36 remaining balls
LIVETodayMatch 17

Bhopal LeopardsBhopal Leopards

Gwalior Cheetahs*55/2 (4.1 ov)

 Gwalior Cheetahs elected to bat
LIVETodayFinal

Anmol Kings HalarAnmol Kings Halar142/10 (19.4 ov)

JMD Kutch Riders*105/2 (11.4 ov)

 JMD Kutch Riders need 38 runs in 50 remaining balls
LIVETodayMatch 10

BohemiansBohemians122/4 (10 ov)

Prague Tigers125/3 (7.5 ov)

 Prague Tigers won by 7 wickets
LIVETodayFinal

Tally RangersTally Rangers

ACE KRM Panthers*156/4 (16.4 ov)

 ACE KRM Panthers elected to bat
LIVETodayMatch 28

Chicago Steelpan PlayersChicago Steelpan Players*0/0 ( ov)

SAMP Army Cocrico Cavaliers

 Rain Delay : SAMP Army Cocrico Cavaliers elected to bowl
CancelledTodayMatch 11

Diamond DazzlersDiamond Dazzlers10/1 (2 ov)

Alembic Warriors

 Match Abandoned
ScheduledTodayMatch 65

NorthamptonshireNorthamptonshire

Nottinghamshire

 
ScheduledTodayMatch 67

GlamorganGlamorgan

Somerset

 
ScheduledTodayMatch 69

DurhamDurham

Yorkshire

 
ScheduledTodayMatch 64

SurreySurrey

Middlesex

 
Scheduled20 June Match 66

GloucestershireGloucestershire

Hampshire

 
Scheduled20 June Match 68

EssexEssex

Kent

 
CricDirect Cricket News, Results and Stats
 

Billy Root

NationalityEngland
RoleBatter
Born05 Aug 1992 (32)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 50 39 9 634 41 21.13 567 111.81 - -
List A 55 47 10 1604 113 43.35 1770 90.62 3 8
1st Class 78 132 13 4023 229 33.80 7409 54.29 7 17

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 50 3 3 37 - - - 12.33 - - -
List A 55 11 48.4 310 6 2/36 51.66 6.36 48.6 - -
1st Class 78 18 64.5 275 8 3/29 34.37 4.24 48.6 - -
× Close