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:f57735c4-9c15-41ac-8b3e-b2a22e3efcd0 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 55744 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (55744,6,'{"status":"ok","response":{"player":{"pid":55744,"title":"Lakshay Garg","short_name":"L Garg","first_name":"Lakshay Garg","last_name":"","middle_name":"","birthdate":"1995-10-10","birthplace":"Mapusa, Goa","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.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":50,"innings":29,"notout":13,"runs":201,"balls":169,"highest":28,"run100":0,"run50":0,"run4":14,"run6":11,"average":"12.56","strike":"118.93","catches":15,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":44,"innings":37,"notout":12,"runs":258,"balls":302,"highest":38,"run100":0,"run50":0,"run4":17,"run6":12,"average":"10.32","strike":"85.43","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":44,"notout":5,"runs":616,"balls":1238,"highest":73,"run100":0,"run50":3,"run4":78,"run6":9,"average":"15.79","strike":"49.75","catches":7,"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":50,"innings":50,"balls":1007,"overs":167.5,"runs":1344,"wickets":49,"bestinning":"4\/16","bestmatch":"4\/16","econ":"8.00","average":"27.42","strike":"20.5","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":44,"innings":44,"balls":1852,"overs":308.4,"runs":1755,"wickets":59,"bestinning":"5\/42","bestmatch":"5\/42","econ":"5.68","average":"29.74","strike":"31.3","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":50,"balls":5033,"overs":838.5,"runs":2655,"wickets":90,"bestinning":"6\/46","bestmatch":"8\/162","econ":"3.16","average":"29.50","strike":"55.9","wicket4i":4,"wicket5i":3,"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":"8560ac9c463d5a1c8bd1dec4ce481d18","modified":"2025-07-13 12:21:30","datetime":"2025-07-13 12:21:30","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":55744,"title":"Lakshay Garg","short_name":"L Garg","first_name":"Lakshay Garg","last_name":"","middle_name":"","birthdate":"1995-10-10","birthplace":"Mapusa, Goa","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.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":50,"innings":29,"notout":13,"runs":201,"balls":169,"highest":28,"run100":0,"run50":0,"run4":14,"run6":11,"average":"12.56","strike":"118.93","catches":15,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":44,"innings":37,"notout":12,"runs":258,"balls":302,"highest":38,"run100":0,"run50":0,"run4":17,"run6":12,"average":"10.32","strike":"85.43","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":44,"notout":5,"runs":616,"balls":1238,"highest":73,"run100":0,"run50":3,"run4":78,"run6":9,"average":"15.79","strike":"49.75","catches":7,"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":50,"innings":50,"balls":1007,"overs":167.5,"runs":1344,"wickets":49,"bestinning":"4\/16","bestmatch":"4\/16","econ":"8.00","average":"27.42","strike":"20.5","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":44,"innings":44,"balls":1852,"overs":308.4,"runs":1755,"wickets":59,"bestinning":"5\/42","bestmatch":"5\/42","econ":"5.68","average":"29.74","strike":"31.3","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":34,"innings":50,"balls":5033,"overs":838.5,"runs":2655,"wickets":90,"bestinning":"6\/46","bestmatch":"8\/162","econ":"3.16","average":"29.50","strike":"55.9","wicket4i":4,"wicket5i":3,"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":"8560ac9c463d5a1c8bd1dec4ce481d18","modified":"2025-07-13 12:21:30","datetime":"2025-07-13 12:21:30","api_version":"3.0"}', Modified = GetDate() WHERE Id = 55744 AND DataTypeId = 6 END
Player profile of Lakshay Garg, 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) & *98/4 (25 ov)

India387/10 (119.2 ov)

 Lunch Break : Day 4 - England lead by 98 runs.
LIVEToday1st Youth Test

England Under-19sEngland Under-19s

India Under-19s540/10 (112.5 ov)

 Lunch Break : Day 2 - India Under-19s elected to bat
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*76/1 (10.1 ov)

Warwickshire Women165/9 (20 ov)

 Hampshire Women need 90 runs in 59 remaining balls
LIVETodayMatch 49

Lancashire WomenLancashire Women148/7 (20 ov)

Durham Women*93/4 (12 ov)

 Durham Women need 56 runs in 48 remaining balls
LIVETodayMatch 50

Surrey WomenSurrey Women175/6 (20 ov)

Somerset Women*76/5 (11.3 ov)

 Somerset Women need 100 runs in 51 remaining balls
LIVETodayMatch 6

GermanyGermany

Belgium*60/4 (3.4 ov)

 Belgium elected to bat
LIVETodayFinal

BahrainBahrain*35/4 (6.4 ov)

Tanzania

 Tanzania elected to bowl
LIVETodayQualifier

Luxembourg Mullerthals-WLuxembourg Mullerthals-W

Belgium Belforts-W*59/2 (7.4 ov)

 Luxembourg Mullerthals-W elected to bowl
LIVETodayMatch 15

Villianur Mohit KingsVillianur Mohit Kings

Ossudu Accord Warriors

 
ScheduledTodayMatch 47

Essex WomenEssex Women

The Blaze Women

 
ScheduledTodayMatch 7

GermanyGermany

Belgium

 
Scheduled13 July Match 106

WorcestershireWorcestershire

Leicestershire

 
Scheduled13 July 2nd 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
 

Lakshay Garg

NationalityIndia
RoleAll Rounder
Born10 Oct 1995 (29)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 50 29 13 201 28 12.56 169 118.93 - -
List A 44 37 12 258 38 10.32 302 85.43 - -
1st Class 34 44 5 616 73 15.79 1238 49.75 - 3

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 50 50 167.5 1344 49 4/16 27.42 8.00 20.5 1 -
List A 44 44 308.4 1755 59 5/42 29.74 5.68 31.3 1 1
1st Class 34 50 838.5 2655 90 6/46 29.50 3.16 55.9 4 3
× Close