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:9154f7b0-07d8-4dc8-8033-d68ff2083f38 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 636 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (636,6,'{"status":"ok","response":{"player":{"pid":636,"title":"Karanveer Singh","short_name":"K Singh","first_name":"Karanveer Singh","last_name":"","middle_name":"","birthdate":"1987-11-08","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":6,"notout":4,"runs":36,"balls":54,"highest":17,"run100":0,"run50":0,"run4":3,"run6":0,"average":"18.00","strike":"66.66","catches":7,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"notout":1,"runs":11,"balls":18,"highest":6,"run100":0,"run50":0,"run4":1,"run6":0,"average":"3.66","strike":"61.11","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":10,"innings":11,"notout":3,"runs":286,"balls":539,"highest":88,"run100":0,"run50":1,"run4":40,"run6":0,"average":"35.75","strike":"53.06","catches":9,"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":326,"overs":54.2,"runs":466,"wickets":21,"bestinning":"4\/15","bestmatch":"4\/15","econ":"8.57","average":"22.19","strike":"15.5","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":5,"innings":5,"balls":172,"overs":28.4,"runs":126,"wickets":5,"bestinning":"2\/19","bestmatch":"2\/19","econ":"4.39","average":"25.20","strike":"34.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":10,"innings":17,"balls":1405,"overs":234.1,"runs":722,"wickets":18,"bestinning":"3\/28","bestmatch":"5\/120","econ":"3.08","average":"40.11","strike":"78.0","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":"998c6864dbcf2dcf90f6cd55a76dda2f","modified":"2025-06-20 14:40:07","datetime":"2025-06-20 14:40:07","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":636,"title":"Karanveer Singh","short_name":"K Singh","first_name":"Karanveer Singh","last_name":"","middle_name":"","birthdate":"1987-11-08","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Leg Spin","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":6.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":16,"innings":6,"notout":4,"runs":36,"balls":54,"highest":17,"run100":0,"run50":0,"run4":3,"run6":0,"average":"18.00","strike":"66.66","catches":7,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":5,"innings":4,"notout":1,"runs":11,"balls":18,"highest":6,"run100":0,"run50":0,"run4":1,"run6":0,"average":"3.66","strike":"61.11","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":10,"innings":11,"notout":3,"runs":286,"balls":539,"highest":88,"run100":0,"run50":1,"run4":40,"run6":0,"average":"35.75","strike":"53.06","catches":9,"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":326,"overs":54.2,"runs":466,"wickets":21,"bestinning":"4\/15","bestmatch":"4\/15","econ":"8.57","average":"22.19","strike":"15.5","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":5,"innings":5,"balls":172,"overs":28.4,"runs":126,"wickets":5,"bestinning":"2\/19","bestmatch":"2\/19","econ":"4.39","average":"25.20","strike":"34.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":10,"innings":17,"balls":1405,"overs":234.1,"runs":722,"wickets":18,"bestinning":"3\/28","bestmatch":"5\/120","econ":"3.08","average":"40.11","strike":"78.0","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":"998c6864dbcf2dcf90f6cd55a76dda2f","modified":"2025-06-20 14:40:07","datetime":"2025-06-20 14:40:07","api_version":"3.0"}', Modified = GetDate() WHERE Id = 636 AND DataTypeId = 6 END
Player profile of Karanveer Singh, 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*211/2 (50.5 ov)

 Day 1 - Session 2, England elected to bowl
LIVETodayMatch 9

Brno CCBrno CC135/6 (10 ov)

United CC*134/5 (10 ov)

 Match completed
LIVETodayMatch 11

Diamond DazzlersDiamond Dazzlers*10/1 (2 ov)

Alembic Warriors

 Rain Delay : Alembic Warriors elected to bowl
LIVETodayMatch 31

Durham WomenDurham Women*81/6 (17 ov)

Essex Women

 Essex Women elected to bowl
LIVETodayEliminator

Raigad RoyalsRaigad Royals

Kolhapur Tuskers*16/0 (2 ov)

 Raigad Royals elected to bowl
LIVETodayMatch 19

Lux Shyam Kolkata TigersLux Shyam Kolkata Tigers*114/4 (13 ov)

Shrachi Rarh Tigers

 Lux Shyam Kolkata Tigers elected to bat
LIVETodayMatch 32

Warwickshire WomenWarwickshire Women*84/1 (10.3 ov)

The Blaze

 Warwickshire Women elected to bat
LIVEToday6th T20I

ScotlandScotland*77/1 (8 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*68/3 (8 ov)

JMD Kutch Riders

 JMD Kutch Riders elected to bowl
ScheduledTodayMatch 10

BohemiansBohemians

Prague Tigers

 
ScheduledTodayFinal

Tally RangersTally Rangers

ACE KRM Panthers

 
Scheduled20 June Match 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

 
CricDirect Cricket News, Results and Stats
 

Karanveer Singh

NationalityIndia
RoleAll Rounder
Born08 Nov 1987 (37)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Leg Spin

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 16 6 4 36 17 18.00 54 66.66 - -
List A 5 4 1 11 6 3.66 18 61.11 - -
1st Class 10 11 3 286 88 35.75 539 53.06 - 1

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 16 16 54.2 466 21 4/15 22.19 8.57 15.5 2 -
List A 5 5 28.4 126 5 2/19 25.20 4.39 34.4 - -
1st Class 10 17 234.1 722 18 3/28 40.11 3.08 78.0 - -
× Close