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:6e9a522d-f099-41c2-b011-ef29159f0f35 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53720 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53720,6,'{"status":"ok","response":{"player":{"pid":53720,"title":"Vishaul Singh","short_name":"VA Singh","first_name":"Vishaul Singh","last_name":"","middle_name":"","birthdate":"1989-01-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"West Indies"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":6,"notout":0,"runs":63,"balls":199,"highest":32,"run100":0,"run50":0,"run4":4,"run6":0,"average":"10.50","strike":"31.65","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":8,"notout":1,"runs":213,"balls":0,"highest":49,"run100":0,"run50":0,"run4":0,"run6":0,"average":"30.42","strike":"","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":138,"notout":13,"runs":4247,"balls":0,"highest":161,"run100":9,"run50":19,"run4":0,"run6":0,"average":"33.97","strike":"","catches":52,"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":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":5,"balls":54,"overs":9,"runs":39,"wickets":0,"bestinning":"","bestmatch":"","econ":"4.33","average":"","strike":"","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":"87fa0871c7ae84fdb6252739efff2aa0","modified":"2025-07-29 21:29:41","datetime":"2025-07-29 21:29:41","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53720,"title":"Vishaul Singh","short_name":"VA Singh","first_name":"Vishaul Singh","last_name":"","middle_name":"","birthdate":"1989-01-12","birthplace":"","country":"wi","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"West Indies"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":6,"notout":0,"runs":63,"balls":199,"highest":32,"run100":0,"run50":0,"run4":4,"run6":0,"average":"10.50","strike":"31.65","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":8,"notout":1,"runs":213,"balls":0,"highest":49,"run100":0,"run50":0,"run4":0,"run6":0,"average":"30.42","strike":"","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":138,"notout":13,"runs":4247,"balls":0,"highest":161,"run100":9,"run50":19,"run4":0,"run6":0,"average":"33.97","strike":"","catches":52,"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":{"test":{"match_id":0,"inning_id":0,"matches":3,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":80,"innings":5,"balls":54,"overs":9,"runs":39,"wickets":0,"bestinning":"","bestmatch":"","econ":"4.33","average":"","strike":"","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":"87fa0871c7ae84fdb6252739efff2aa0","modified":"2025-07-29 21:29:41","datetime":"2025-07-29 21:29:41","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53720 AND DataTypeId = 6 END
Player profile of Vishaul Singh, West Indies
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday51st Match

DurhamDurham153/10 (55.1 ov) & *104/2 (24 ov)

Surrey322/10 (68.1 ov)

 Day 2 - Durham trail by 65 runs.
LIVEToday55th Match

NottinghamshireNottinghamshire*53/1 (12.1 ov)

Somerset438/10 (132.3 ov)

 Day 2 - Nottinghamshire trail by 385 runs.
LIVEToday54th Match

WorcestershireWorcestershire

Hampshire291/10 (87.3 ov)

 Innings Break : Day 2 - Worcestershire elected to bowl
LIVEToday52nd Match

EssexEssex*589/5 (147.5 ov)

Warwickshire

 Day 2 - Warwickshire elected to bowl
LIVEToday53rd Match

YorkshireYorkshire*171/2 (49 ov)

Sussex222/10 (99.5 ov)

 Day 2 - Yorkshire trail by 51 runs.
LIVEToday42nd Match

GloucestershireGloucestershire

Middlesex*342/7 (84 ov)

 Day 2 - Middlesex elected to bat
LIVEToday44th Match

KentKent*83/1 (29.1 ov)

Leicestershire471/10 (114.5 ov)

 Day 2 - Kent trail by 388 runs.
LIVEToday43rd Match

LancashireLancashire*97/3 (30 ov)

Glamorgan261/10 (97.2 ov)

 Day 2 - Lancashire trail by 164 runs.
LIVEToday41st Match

NorthamptonshireNorthamptonshire*122/2 (37.5 ov)

Derbyshire377/10 (104.2 ov)

 Day 2 - Northamptonshire trail by 255 runs.
LIVEToday1st Test

ZimbabweZimbabwe149/10 (60.3 ov)

New Zealand*40/0 (9 ov)

 Day 1 - Session 3, New Zealand trail by 109 runs.
LIVETodayMatch 37

Hampshire WomenHampshire Women291/7 (50 ov)

The Blaze Women*18/2 (6 ov)

 The Blaze Women need 274 runs in 44.0 remaining overs
LIVETodayMatch 38

Lancashire WomenLancashire Women306/4 (50 ov)

Essex Women*66/2 (14.4 ov)

 Essex Women need 241 runs in 35.2 remaining overs
LIVETodayMatch 39

Somerset WomenSomerset Women*59/1 (13 ov)

Durham Women315/9 (50 ov)

 Somerset Women need 257 runs in 37.0 remaining overs
LIVETodayMatch 40

Warwickshire WomenWarwickshire Women239/10 (42.5 ov)

Surrey Women*147/2 (20.5 ov)

 Surrey Women need 93 runs in 29.1 remaining overs
LIVETodayMatch 13

East MoleseyEast Molesey100/10 (8.2 ov)

Weybridge*40/3 (4.3 ov)

 Weybridge need 61 runs in 33 remaining balls
LIVETodayMatch 4

West Indies Women Under-19sWest Indies Women Under-19s*6/3 (3.5 ov)

United States of America Women Under-19s

 United States of America Women Under-19s elected to bowl
ScheduledTodayMatch 14

WeybridgeWeybridge

Twickenham

 
Scheduled30 July Match 3

Royal TrivianzRoyal Trivianz

Keraniganj Challengers

 
CricDirect Cricket News, Results and Stats
 

Vishaul Singh

NationalityWest Indies
RoleBatter
Born12 Jan 1989 (36)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 3 6 - 63 32 10.50 199 31.65 - -
List A 8 8 1 213 49 30.42 - - - -
1st Class 80 138 13 4247 161 33.97 - - 9 19

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 3 - - - - - - - - - -
List A 8 - - - - - - - - - -
1st Class 80 5 9 39 - - - 4.33 - - -
× Close