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:a90922c6-416f-4169-9109-324703b5c42c Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53937 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53937,6,'{"status":"ok","response":{"player":{"pid":53937,"title":"Swapnil Singh","short_name":"Swapnil Singh","first_name":"Swapnil Singh","last_name":"","middle_name":"","birthdate":"1991-01-22","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":89,"innings":70,"notout":26,"runs":988,"balls":767,"highest":52,"run100":0,"run50":2,"run4":64,"run6":48,"average":"22.45","strike":"128.81","catches":32,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":67,"innings":57,"notout":8,"runs":1187,"balls":1478,"highest":82,"run100":0,"run50":6,"run4":90,"run6":26,"average":"24.22","strike":"80.31","catches":23,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":81,"innings":126,"notout":13,"runs":2929,"balls":6264,"highest":164,"run100":2,"run50":16,"run4":319,"run6":56,"average":"25.92","strike":"46.75","catches":52,"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":89,"innings":83,"balls":1534,"overs":255.4,"runs":1871,"wickets":73,"bestinning":"6\/19","bestmatch":"6\/19","econ":"7.31","average":"25.63","strike":"21.0","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":67,"innings":63,"balls":2935,"overs":489.1,"runs":2169,"wickets":71,"bestinning":"5\/25","bestmatch":"5\/25","econ":"4.43","average":"30.54","strike":"41.3","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":81,"innings":121,"balls":12183,"overs":2030.3,"runs":6027,"wickets":199,"bestinning":"6\/59","bestmatch":"9\/68","econ":"2.96","average":"30.28","strike":"61.2","wicket4i":12,"wicket5i":11,"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":"a66386f768edd6ba9ca4880ee73f27c8","modified":"2025-06-20 17:37:44","datetime":"2025-06-20 17:37:44","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53937,"title":"Swapnil Singh","short_name":"Swapnil Singh","first_name":"Swapnil Singh","last_name":"","middle_name":"","birthdate":"1991-01-22","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":89,"innings":70,"notout":26,"runs":988,"balls":767,"highest":52,"run100":0,"run50":2,"run4":64,"run6":48,"average":"22.45","strike":"128.81","catches":32,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":67,"innings":57,"notout":8,"runs":1187,"balls":1478,"highest":82,"run100":0,"run50":6,"run4":90,"run6":26,"average":"24.22","strike":"80.31","catches":23,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":81,"innings":126,"notout":13,"runs":2929,"balls":6264,"highest":164,"run100":2,"run50":16,"run4":319,"run6":56,"average":"25.92","strike":"46.75","catches":52,"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":89,"innings":83,"balls":1534,"overs":255.4,"runs":1871,"wickets":73,"bestinning":"6\/19","bestmatch":"6\/19","econ":"7.31","average":"25.63","strike":"21.0","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":67,"innings":63,"balls":2935,"overs":489.1,"runs":2169,"wickets":71,"bestinning":"5\/25","bestmatch":"5\/25","econ":"4.43","average":"30.54","strike":"41.3","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":81,"innings":121,"balls":12183,"overs":2030.3,"runs":6027,"wickets":199,"bestinning":"6\/59","bestmatch":"9\/68","econ":"2.96","average":"30.28","strike":"61.2","wicket4i":12,"wicket5i":11,"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":"a66386f768edd6ba9ca4880ee73f27c8","modified":"2025-06-20 17:37:44","datetime":"2025-06-20 17:37:44","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53937 AND DataTypeId = 6 END
Player profile of Swapnil 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*359/3 (85 ov)

 Day 1 - Session 3, England elected to bowl
LIVETodayEliminator

Raigad RoyalsRaigad Royals*32/0 (4 ov)

Kolhapur Tuskers164/7 (20 ov)

 Raigad Royals need 133 runs in 16.0 remaining overs
LIVETodayMatch 17

Bhopal LeopardsBhopal Leopards*0/0 ( ov)

Gwalior Cheetahs136/5 (12 ov)

 Innings Break : Bhopal Leopards need 137 runs in 12 remaining overs
LIVETodayFinal

Tally RangersTally Rangers*23/0 (4 ov)

ACE KRM Panthers199/7 (20 ov)

 Tally Rangers need 177 runs in 16.0 remaining overs
LIVETodayMatch 28

Chicago Steelpan PlayersChicago Steelpan Players*0/0 ( ov)

SAMP Army Cocrico Cavaliers

 Rain Delay : SAMP Army Cocrico Cavaliers elected to bowl
LIVETodayMatch 65

NorthamptonshireNorthamptonshire0/0 ( ov)

Nottinghamshire

 Nottinghamshire elected to bat
LIVETodayMatch 67

GlamorganGlamorgan*8/0 (1 ov)

Somerset

 Somerset elected to bowl
LIVETodayMatch 69

DurhamDurham*5/0 (1.2 ov)

Yorkshire

 Yorkshire elected to bowl
LIVETodayMatch 64

SurreySurrey*0/0 ( ov)

Middlesex

 Middlesex elected to bowl
CancelledTodayMatch 11

Diamond DazzlersDiamond Dazzlers10/1 (2 ov)

Alembic Warriors

 Match Abandoned
ScheduledTodayMatch 66

GloucestershireGloucestershire

Hampshire

 
ScheduledTodayMatch 68

EssexEssex

Kent

 
ScheduledTodayMatch 70

DerbyshireDerbyshire

Lancashire

 
ScheduledTodayMatch 71

WarwickshireWarwickshire

Worcestershire

 
ScheduledToday1st T20I

West Indies WomenWest Indies Women

South Africa Women

 
ScheduledTodayMatch 29

Bess Motors Blue DevilsBess Motors Blue Devils

Leatherback Strikers

 
Scheduled20 June Match 8

YSSCYSSC

TGS

 
CricDirect Cricket News, Results and Stats
 

Swapnil Singh

NationalityIndia
RoleAll Rounder
Born22 Jan 1991 (34)
Batting StyleRight Hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 89 70 26 988 52 22.45 767 128.81 - 2
List A 67 57 8 1187 82 24.22 1478 80.31 - 6
1st Class 81 126 13 2929 164 25.92 6264 46.75 2 16

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 89 83 255.4 1871 73 6/19 25.63 7.31 21.0 - 1
List A 67 63 489.1 2169 71 5/25 30.54 4.43 41.3 3 1
1st Class 81 121 2030.3 6027 199 6/59 30.28 2.96 61.2 12 11
× Close