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:42b5ed54-ff87-4e1c-8c17-417e23fdfdf7 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 94306 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (94306,6,'{"status":"ok","response":{"player":{"pid":94306,"title":"Shivank Vashisht","short_name":"S Vashisht","first_name":"Shivank Vashisht","last_name":"","middle_name":"","birthdate":"1995-09-17","birthplace":" Delhi","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shivankvashisth\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":4,"notout":1,"runs":19,"balls":25,"highest":7,"run100":0,"run50":0,"run4":0,"run6":1,"average":"6.33","strike":"76.00","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":16,"innings":7,"notout":0,"runs":136,"balls":179,"highest":55,"run100":0,"run50":2,"run4":16,"run6":0,"average":"19.42","strike":"75.97","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"notout":3,"runs":179,"balls":447,"highest":38,"run100":0,"run50":0,"run4":20,"run6":1,"average":"22.37","strike":"40.04","catches":1,"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":16,"innings":16,"balls":288,"overs":48,"runs":285,"wickets":22,"bestinning":"5\/19","bestmatch":"5\/19","econ":"5.93","average":"12.95","strike":"13.0","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":16,"innings":16,"balls":810,"overs":135,"runs":665,"wickets":15,"bestinning":"2\/31","bestmatch":"2\/31","econ":"4.92","average":"44.33","strike":"54.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"balls":1018,"overs":169.4,"runs":598,"wickets":11,"bestinning":"5\/49","bestmatch":"6\/116","econ":"3.52","average":"54.36","strike":"92.5","wicket4i":0,"wicket5i":1,"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":"700a65184ba183b84ccf8fb18516b37c","modified":"2025-07-27 13:45:11","datetime":"2025-07-27 13:45:11","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":94306,"title":"Shivank Vashisht","short_name":"S Vashisht","first_name":"Shivank Vashisht","last_name":"","middle_name":"","birthdate":"1995-09-17","birthplace":" Delhi","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"https:\/\/www.instagram.com\/shivankvashisth\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":4,"notout":1,"runs":19,"balls":25,"highest":7,"run100":0,"run50":0,"run4":0,"run6":1,"average":"6.33","strike":"76.00","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":16,"innings":7,"notout":0,"runs":136,"balls":179,"highest":55,"run100":0,"run50":2,"run4":16,"run6":0,"average":"19.42","strike":"75.97","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"notout":3,"runs":179,"balls":447,"highest":38,"run100":0,"run50":0,"run4":20,"run6":1,"average":"22.37","strike":"40.04","catches":1,"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":16,"innings":16,"balls":288,"overs":48,"runs":285,"wickets":22,"bestinning":"5\/19","bestmatch":"5\/19","econ":"5.93","average":"12.95","strike":"13.0","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":16,"innings":16,"balls":810,"overs":135,"runs":665,"wickets":15,"bestinning":"2\/31","bestmatch":"2\/31","econ":"4.92","average":"44.33","strike":"54.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"balls":1018,"overs":169.4,"runs":598,"wickets":11,"bestinning":"5\/49","bestmatch":"6\/116","econ":"3.52","average":"54.36","strike":"92.5","wicket4i":0,"wicket5i":1,"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":"700a65184ba183b84ccf8fb18516b37c","modified":"2025-07-27 13:45:11","datetime":"2025-07-27 13:45:11","api_version":"3.0"}', Modified = GetDate() WHERE Id = 94306 AND DataTypeId = 6 END
Player profile of Shivank Vashisht, India
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday4th Test

EnglandEngland669/10 (157.1 ov)

India358/10 (114.1 ov) & *278/4 (104 ov)

 Drinks Break : Day 5 - Session 2, India trail by 33 runs.
LIVETodayMatch 18

United Arab EmiratesUnited Arab Emirates*103/5 (13.2 ov)

Uganda170/7 (20 ov)

 United Arab Emirates need 68 runs in 40 remaining balls
LIVETodayFinal

BahrainBahrain189/3 (20 ov)

Malawi*71/3 (11.3 ov)

 Malawi need 119 runs in 51 remaining balls
LIVEToday1st Semi-Final

The Blaze WomenThe Blaze Women*74/4 (9.3 ov)

Warwickshire Women163/8 (20 ov)

 The Blaze Women need 90 runs in 10.3 remaining overs
LIVETodayMatch 12

South Africa ChampionsSouth Africa Champions241/6 (20 ov)

Australia Champions*50/4 (5.1 ov)

 Australia Champions need 192 runs in 14.5 remaining overs
LIVETodayFinal

Villianur Mohit KingsVillianur Mohit Kings

Mahe Megalo Strikers*14/0 (2.5 ov)

 Villianur Mohit Kings elected to bowl
LIVETodayFinal

Gauhati Town ClubGauhati Town Club

Guwahati Giants

  Guwahati Giants won the toss and elected to bat
CancelledTodayFinal

AustriaAustria182/3 (16 ov)

Romania

 Match abandoned due to rain
CancelledTodayMatch 5

Navarang ClubNavarang Club0/0 ( ov)

City Cricket Club58/1 (6 ov)

 Match abandoned due to rain
ScheduledTodayMatch 2

West Indies Women Under-19sWest Indies Women Under-19s

United States of America Women Under-19s

 
ScheduledTodayFinal

Alby Zalmi CFAlby Zalmi CF

Huddinge

 
Scheduled27 July Final

Surrey WomenSurrey Women

TBA

 
Scheduled27 July Match 13

India ChampionsIndia Champions

England Champions

 
Scheduled27 July Match 29

Chennai Kings CAChennai Kings CA

Tally Rangers

 
Scheduled28 July 1st Semi-Final

Maxx Cricket ClubMaxx Cricket Club

Sky Warriors Cricket

 
Scheduled28 July 2nd Semi-Final

MR KB PutrajayaMR KB Putrajaya

Fatemi Resources Cricket Club

 
Scheduled28 July Match 1

Gauhati Town ClubGauhati Town Club

Bud CC

 
Scheduled28 July Match 15

Band-e-Amir DragonsBand-e-Amir Dragons

Boost Defenders

 
CricDirect Cricket News, Results and Stats
 

Shivank Vashisht

NationalityIndia
RoleAll Rounder
Born17 Sep 1995 (29)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 16 4 1 19 7 6.33 25 76.00 - -
List A 16 7 - 136 55 19.42 179 75.97 - 2
1st Class 7 11 3 179 38 22.37 447 40.04 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 16 16 48 285 22 5/19 12.95 5.93 13.0 1 1
List A 16 16 135 665 15 2/31 44.33 4.92 54.0 - -
1st Class 7 11 169.4 598 11 5/49 54.36 3.52 92.5 - 1
× Close