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:0a95dab4-62a3-4051-b35d-7f3a7898b540 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 93406 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (93406,6,'{"status":"ok","response":{"player":{"pid":93406,"title":"Lalit Yadav","short_name":"L Yadav","first_name":"Lalit Yadav","last_name":"","middle_name":"","birthdate":"1997-01-03","birthplace":" Delhi","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/LalitYadav03","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":82,"innings":60,"notout":23,"runs":1077,"balls":797,"highest":66,"run100":0,"run50":2,"run4":106,"run6":37,"average":"29.10","strike":"135.13","catches":47,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":41,"innings":32,"notout":9,"runs":927,"balls":1136,"highest":75,"run100":0,"run50":8,"run4":97,"run6":13,"average":"40.30","strike":"81.60","catches":16,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":19,"innings":27,"notout":2,"runs":951,"balls":1909,"highest":177,"run100":1,"run50":7,"run4":118,"run6":17,"average":"38.04","strike":"49.81","catches":17,"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":82,"innings":68,"balls":1206,"overs":201,"runs":1413,"wickets":53,"bestinning":"3\/10","bestmatch":"3\/10","econ":"7.02","average":"26.66","strike":"22.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":41,"innings":40,"balls":1815,"overs":302.3,"runs":1360,"wickets":42,"bestinning":"5\/25","bestmatch":"5\/25","econ":"4.49","average":"32.38","strike":"43.2","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":19,"innings":28,"balls":2164,"overs":360.4,"runs":1162,"wickets":15,"bestinning":"2\/10","bestmatch":"2\/37","econ":"3.22","average":"77.46","strike":"144.2","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":"8dfc0d506a9f4b12ddba8016a66c9722","modified":"2025-06-20 15:04:57","datetime":"2025-06-20 15:04:57","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":93406,"title":"Lalit Yadav","short_name":"L Yadav","first_name":"Lalit Yadav","last_name":"","middle_name":"","birthdate":"1997-01-03","birthplace":" Delhi","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/LalitYadav03","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":82,"innings":60,"notout":23,"runs":1077,"balls":797,"highest":66,"run100":0,"run50":2,"run4":106,"run6":37,"average":"29.10","strike":"135.13","catches":47,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":41,"innings":32,"notout":9,"runs":927,"balls":1136,"highest":75,"run100":0,"run50":8,"run4":97,"run6":13,"average":"40.30","strike":"81.60","catches":16,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":19,"innings":27,"notout":2,"runs":951,"balls":1909,"highest":177,"run100":1,"run50":7,"run4":118,"run6":17,"average":"38.04","strike":"49.81","catches":17,"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":82,"innings":68,"balls":1206,"overs":201,"runs":1413,"wickets":53,"bestinning":"3\/10","bestmatch":"3\/10","econ":"7.02","average":"26.66","strike":"22.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":41,"innings":40,"balls":1815,"overs":302.3,"runs":1360,"wickets":42,"bestinning":"5\/25","bestmatch":"5\/25","econ":"4.49","average":"32.38","strike":"43.2","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":19,"innings":28,"balls":2164,"overs":360.4,"runs":1162,"wickets":15,"bestinning":"2\/10","bestmatch":"2\/37","econ":"3.22","average":"77.46","strike":"144.2","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":"8dfc0d506a9f4b12ddba8016a66c9722","modified":"2025-06-20 15:04:57","datetime":"2025-06-20 15:04:57","api_version":"3.0"}', Modified = GetDate() WHERE Id = 93406 AND DataTypeId = 6 END
Player profile of Lalit Yadav, India
<>
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*219/2 (51.3 ov)

 Day 1 - Session 3, England elected to bowl
LIVETodayMatch 11

Diamond DazzlersDiamond Dazzlers*10/1 (2 ov)

Alembic Warriors

 Rain Delay : Alembic Warriors elected to bowl
LIVETodayMatch 31

Durham WomenDurham Women101/8 (20 ov)

Essex Women0/0 ( ov)

 Innings Break : Essex Women need 102 runs in 20 remaining overs
LIVETodayEliminator

Raigad RoyalsRaigad Royals

Kolhapur Tuskers*38/1 (5 ov)

 Rain Delay : Raigad Royals elected to bowl
LIVETodayMatch 19

Lux Shyam Kolkata TigersLux Shyam Kolkata Tigers*147/5 (17.2 ov)

Shrachi Rarh Tigers

 Lux Shyam Kolkata Tigers elected to bat
LIVETodayMatch 32

Warwickshire WomenWarwickshire Women*127/4 (15.2 ov)

The Blaze

 Warwickshire Women elected to bat
LIVEToday6th T20I

ScotlandScotland*136/3 (13.1 ov)

Nepal

 Scotland elected to bat
LIVETodayMatch 17

Bhopal LeopardsBhopal Leopards

Gwalior Cheetahs*29/1 (3 ov)

 Rain Delay : Gwalior Cheetahs elected to bat
LIVETodayFinal

Anmol Kings HalarAnmol Kings Halar*107/4 (13 ov)

JMD Kutch Riders

 JMD Kutch Riders elected to bowl
LIVETodayMatch 10

BohemiansBohemians*2/0 (0.1 ov)

Prague Tigers

 Prague Tigers elected to bowl
LIVETodayFinal

Tally RangersTally Rangers

ACE KRM Panthers

 
ScheduledTodayMatch 28

Chicago Steelpan PlayersChicago Steelpan Players

SAMP Army Cocrico Cavaliers

 
Scheduled20 June Match 65

NorthamptonshireNorthamptonshire

Nottinghamshire

 
Scheduled20 June Match 67

GlamorganGlamorgan

Somerset

 
Scheduled20 June Match 69

DurhamDurham

Yorkshire

 
Scheduled20 June Match 64

SurreySurrey

Middlesex

 
Scheduled20 June Match 66

GloucestershireGloucestershire

Hampshire

 
CricDirect Cricket News, Results and Stats
 

Lalit Yadav

NationalityIndia
RoleAll Rounder
Born03 Jan 1997 (28)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 82 60 23 1077 66 29.10 797 135.13 - 2
List A 41 32 9 927 75 40.30 1136 81.60 - 8
1st Class 19 27 2 951 177 38.04 1909 49.81 1 7

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 82 68 201 1413 53 3/10 26.66 7.02 22.7 - -
List A 41 40 302.3 1360 42 5/25 32.38 4.49 43.2 - 1
1st Class 19 28 360.4 1162 15 2/10 77.46 3.22 144.2 - -
× Close