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:501fd9a2-1433-444b-9cfe-940dfb814134 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 136370 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (136370,6,'{"status":"ok","response":{"player":{"pid":136370,"title":"Roshan Kumar Prasad","short_name":"R Kumar Prasad","first_name":"Roshan Kumar Prasad","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":7,"notout":2,"runs":58,"balls":66,"highest":18,"run100":0,"run50":0,"run4":3,"run6":2,"average":"11.60","strike":"87.87","catches":2,"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":7,"innings":4,"balls":60,"overs":10,"runs":137,"wickets":6,"bestinning":"4\/34","bestmatch":"4\/34","econ":"13.70","average":"22.83","strike":"10.0","wicket4i":1,"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":"66270532dc15a8200d2aed711df41a09","modified":"2025-07-13 12:54:08","datetime":"2025-07-13 12:54:08","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":136370,"title":"Roshan Kumar Prasad","short_name":"R Kumar Prasad","first_name":"Roshan Kumar Prasad","last_name":"","middle_name":"","birthdate":"2004-06-22","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","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":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":7,"innings":7,"notout":2,"runs":58,"balls":66,"highest":18,"run100":0,"run50":0,"run4":3,"run6":2,"average":"11.60","strike":"87.87","catches":2,"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":7,"innings":4,"balls":60,"overs":10,"runs":137,"wickets":6,"bestinning":"4\/34","bestmatch":"4\/34","econ":"13.70","average":"22.83","strike":"10.0","wicket4i":1,"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":"66270532dc15a8200d2aed711df41a09","modified":"2025-07-13 12:54:08","datetime":"2025-07-13 12:54:08","api_version":"3.0"}', Modified = GetDate() WHERE Id = 136370 AND DataTypeId = 6 END
Player profile of Roshan Kumar Prasad, India
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday3rd Test

EnglandEngland387/10 (112.3 ov) & *105/4 (26.5 ov)

India387/10 (119.2 ov)

 Day 4 - Session 2, England lead by 105 runs.
LIVEToday1st Youth Test

England Under-19sEngland Under-19s*8/1 (2 ov)

India Under-19s540/10 (112.5 ov)

 Day 2 - England Under-19s trail by 532 runs.
LIVEToday3rd Test

West IndiesWest Indies*16/1 (9 ov)

Australia225/10 (70.3 ov)

 Stumps : Day 1 - West Indies trail by 209 runs.
LIVEToday1st Unofficial Test

Australia AAustralia A

Sri Lanka A272/10 (82 ov)

 Stumps : Day 1 - Australia A elected to bowl
LIVETodayMatch 48

Hampshire WomenHampshire Women*123/5 (17.5 ov)

Warwickshire Women165/9 (20 ov)

 Hampshire Women need 43 runs in 13 remaining balls
LIVETodayMatch 49

Lancashire WomenLancashire Women148/7 (20 ov)

Durham Women149/8 (19.2 ov)

 Durham Women won by 2 wickets
LIVETodayMatch 50

Surrey WomenSurrey Women175/6 (20 ov)

Somerset Women107/10 (17.3 ov)

 Surrey Women won by 68 runs
LIVETodayMatch 6

GermanyGermany*10/0 (0.2 ov)

Belgium160/5 (10 ov)

 Germany need 151 runs in 58 remaining balls
LIVETodayFinal

BahrainBahrain*76/7 (16 ov)

Tanzania

 Tanzania elected to bowl
LIVETodayQualifier

Luxembourg Mullerthals-WLuxembourg Mullerthals-W*36/0 (3 ov)

Belgium Belforts-W74/2 (10 ov)

 Luxembourg Mullerthals-W need 39 runs in 42 remaining balls
LIVETodayMatch 15

Villianur Mohit KingsVillianur Mohit Kings*42/1 (4.3 ov)

Ossudu Accord Warriors

 Villianur Mohit Kings elected to bat
LIVETodayMatch 47

Essex WomenEssex Women

The Blaze Women

  The Blaze won the toss and elected to bat
ScheduledTodayMatch 7

GermanyGermany

Belgium

 
ScheduledTodayMatch 106

WorcestershireWorcestershire

Leicestershire

 
ScheduledToday2nd T20I

Sri LankaSri Lanka

Bangladesh

 
Scheduled13 July Match 105

YorkshireYorkshire

Derbyshire

 
Scheduled13 July Match 108

LancashireLancashire

Durham

 
Scheduled13 July Match 110

HampshireHampshire

Sussex

 
CricDirect Cricket News, Results and Stats
 

Roshan Kumar Prasad

NationalityIndia
RoleBatter
Born22 Jun 2004 (21)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 7 7 2 58 18 11.60 66 87.87 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 7 4 10 137 6 4/34 22.83 13.70 10.0 1 -
× Close