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:b2fb5be2-ad66-4491-9ff0-07c366220158 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 48694 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (48694,6,'{"status":"ok","response":{"player":{"pid":48694,"title":"Lalit Yadav","short_name":"Lalit Yadav","first_name":"Lalit Yadav","last_name":"","middle_name":"","birthdate":"1995-12-17","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":10,"innings":3,"notout":1,"runs":19,"balls":24,"highest":9,"run100":0,"run50":0,"run4":2,"run6":1,"average":"9.50","strike":"79.16","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":5,"notout":4,"runs":26,"balls":19,"highest":10,"run100":0,"run50":0,"run4":2,"run6":2,"average":"26.00","strike":"136.84","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":30,"innings":32,"notout":4,"runs":282,"balls":627,"highest":27,"run100":0,"run50":0,"run4":38,"run6":6,"average":"10.07","strike":"44.97","catches":5,"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":10,"innings":10,"balls":185,"overs":30.5,"runs":237,"wickets":7,"bestinning":"3\/19","bestmatch":"3\/19","econ":"7.68","average":"33.85","strike":"26.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":8,"balls":324,"overs":54,"runs":275,"wickets":6,"bestinning":"2\/15","bestmatch":"2\/15","econ":"5.09","average":"45.83","strike":"54.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":30,"innings":47,"balls":4227,"overs":704.3,"runs":2223,"wickets":79,"bestinning":"7\/56","bestmatch":"9\/121","econ":"3.15","average":"28.13","strike":"53.5","wicket4i":1,"wicket5i":5,"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":"74ac70982c210cc7a9c2eacbfaa0f8f0","modified":"2025-06-18 15:23:52","datetime":"2025-06-18 15:23:52","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":48694,"title":"Lalit Yadav","short_name":"Lalit Yadav","first_name":"Lalit Yadav","last_name":"","middle_name":"","birthdate":"1995-12-17","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bowl","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium Fast","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":10,"innings":3,"notout":1,"runs":19,"balls":24,"highest":9,"run100":0,"run50":0,"run4":2,"run6":1,"average":"9.50","strike":"79.16","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":5,"notout":4,"runs":26,"balls":19,"highest":10,"run100":0,"run50":0,"run4":2,"run6":2,"average":"26.00","strike":"136.84","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":30,"innings":32,"notout":4,"runs":282,"balls":627,"highest":27,"run100":0,"run50":0,"run4":38,"run6":6,"average":"10.07","strike":"44.97","catches":5,"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":10,"innings":10,"balls":185,"overs":30.5,"runs":237,"wickets":7,"bestinning":"3\/19","bestmatch":"3\/19","econ":"7.68","average":"33.85","strike":"26.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":8,"innings":8,"balls":324,"overs":54,"runs":275,"wickets":6,"bestinning":"2\/15","bestmatch":"2\/15","econ":"5.09","average":"45.83","strike":"54.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":30,"innings":47,"balls":4227,"overs":704.3,"runs":2223,"wickets":79,"bestinning":"7\/56","bestmatch":"9\/121","econ":"3.15","average":"28.13","strike":"53.5","wicket4i":1,"wicket5i":5,"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":"74ac70982c210cc7a9c2eacbfaa0f8f0","modified":"2025-06-18 15:23:52","datetime":"2025-06-18 15:23:52","api_version":"3.0"}', Modified = GetDate() WHERE Id = 48694 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 Lanka

Bangladesh*484/9 (151 ov)

 Stumps : Day 2 - Bangladesh elected to bat
LIVETodayMatch 6

Dragons WomenDragons Women

Scorchers Women

 Not covered Live
LIVETodayMatch 28

Surrey WomenSurrey Women171/9 (20 ov)

Lancashire Women*90/3 (12.2 ov)

 Lancashire Women need 82 runs in 46 remaining balls
LIVETodayMatch 7

Pruthvi PanthersPruthvi Panthers

A4 Power Strikers

 Match delayed due to rain
LIVETodayMatch 27

Kolhapur TuskersKolhapur Tuskers0/0 ( ov)

Satara Warriors

 Satara Warriors elected to bowl
LIVETodayMatch 15

Harbour DiamondsHarbour Diamonds

Lux Shyam Kolkata Tigers

 Toss delayed due to rain
LIVETodayMatch 16

Siechem Madurai PanthersSiechem Madurai Panthers*98/4 (12.1 ov)

Nellai Royal Kings

 Nellai Royal Kings elected to bowl
LIVEToday4th T20I

ScotlandScotland

Netherlands*161/5 (16.3 ov)

 Scotland elected to bowl
LIVETodayMatch 13

Jabalpur LionsJabalpur Lions

Chamble Ghariyals*47/5 (9 ov)

 Chamble Ghariyals elected to bat
LIVETodayMatch 20

JMD Kutch RidersJMD Kutch Riders

Zalwad Strikers*93/7 (16 ov)

 Zalwad Strikers elected to bat
LIVETodayMatch 5

BermudaBermuda

Cayman Islands*78/4 (11 ov)

 Bermuda elected to bowl
LIVETodayMatch 4

Munster RedsMunster Reds*52/4 (7.1 ov)

Northern Knights

 Northern Knights elected to bowl
LIVETodayFinal

Prague Spartans CCPrague Spartans CC

Vinohrady CC*51/1 (4.3 ov)

 Prague Spartans CC elected to bowl
Cancelled18 June Match 13

Adamas Howrah Warriors WomensAdamas Howrah Warriors Womens

Lux Shyam Kolkata Tigers Womens

 Match abandoned due to rain
CancelledTodayMatch 14

Shrachi Rarh TigersShrachi Rarh Tigers

Rashmi Medinipur Wizards

 Match abandoned due to rain
CancelledTodayMatch 14

Murshidabd Kueens WomensMurshidabd Kueens Womens

Servotech Siliguri Strikers Womens

 Match abandoned due to rain
CancelledTodayMatch 26

Raigad RoyalsRaigad Royals111/6 (14 ov)

Eagle Nashik Titans

 Match abondoned due to rain
ScheduledTodayMatch 22

Leatherback StrikersLeatherback Strikers

Soca Kings

 
CricDirect Cricket News, Results and Stats
 

Lalit Yadav

NationalityIndia
RoleBowler
Born17 Dec 1995 (29)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium Fast

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 10 3 1 19 9 9.50 24 79.16 - -
List A 8 5 4 26 10 26.00 19 136.84 - -
1st Class 30 32 4 282 27 10.07 627 44.97 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 10 10 30.5 237 7 3/19 33.85 7.68 26.4 - -
List A 8 8 54 275 6 2/15 45.83 5.09 54.0 - -
1st Class 30 47 704.3 2223 79 7/56 28.13 3.15 53.5 1 5
× Close