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:ab9e2987-8b88-4a4a-84b2-245c098dc990 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 749 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (749,6,'{"status":"ok","response":{"player":{"pid":749,"title":"Bipul Sharma","short_name":"B Sharma","first_name":"Bipul Sharma","last_name":"","middle_name":"","birthdate":"1983-09-28","birthplace":" Amritsar, Punjab","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/sharmabipul27","instagram_profile":"https:\/\/www.instagram.com\/bipulsharma30\/","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":105,"innings":77,"notout":26,"runs":1203,"balls":868,"highest":79,"run100":0,"run50":3,"run4":81,"run6":55,"average":"23.58","strike":"138.59","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":96,"innings":71,"notout":15,"runs":1620,"balls":1693,"highest":100,"run100":1,"run50":8,"run4":0,"run6":0,"average":"28.92","strike":"95.68","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":59,"innings":75,"notout":11,"runs":3012,"balls":4815,"highest":200,"run100":8,"run50":17,"run4":314,"run6":76,"average":"47.06","strike":"62.55","catches":21,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"3","notout":"1","runs":"9","balls":"10","highest":"4","run100":"0","run50":"0","run4":"1","run6":"0","average":"4.50","strike":"90.00","catches":"1","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":105,"innings":93,"balls":1776,"overs":296,"runs":1847,"wickets":84,"bestinning":"4\/28","bestmatch":"4\/28","econ":"6.23","average":"21.98","strike":"21.1","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":96,"innings":0,"balls":4172,"overs":695.2,"runs":2909,"wickets":96,"bestinning":"5\/36","bestmatch":"5\/36","econ":"4.18","average":"30.30","strike":"43.4","wicket4i":2,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":59,"innings":92,"balls":9081,"overs":1513.3,"runs":3766,"wickets":126,"bestinning":"6\/33","bestmatch":"7\/72","econ":"2.48","average":"29.88","strike":"72.0","wicket4i":4,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"3","balls":"30","overs":"5","runs":"47","wickets":"1","bestinning":"1\/8","bestmatch":"1\/8","econ":"9.40","average":"47.00","strike":"30.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"fdc2ba517a52269dca6129076e298213","modified":"2025-06-20 17:13:54","datetime":"2025-06-20 17:13:54","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":749,"title":"Bipul Sharma","short_name":"B Sharma","first_name":"Bipul Sharma","last_name":"","middle_name":"","birthdate":"1983-09-28","birthplace":" Amritsar, Punjab","country":"in","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/sharmabipul27","instagram_profile":"https:\/\/www.instagram.com\/bipulsharma30\/","debut_data":"","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":105,"innings":77,"notout":26,"runs":1203,"balls":868,"highest":79,"run100":0,"run50":3,"run4":81,"run6":55,"average":"23.58","strike":"138.59","catches":30,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":96,"innings":71,"notout":15,"runs":1620,"balls":1693,"highest":100,"run100":1,"run50":8,"run4":0,"run6":0,"average":"28.92","strike":"95.68","catches":40,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":59,"innings":75,"notout":11,"runs":3012,"balls":4815,"highest":200,"run100":8,"run50":17,"run4":314,"run6":76,"average":"47.06","strike":"62.55","catches":21,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"3","notout":"1","runs":"9","balls":"10","highest":"4","run100":"0","run50":"0","run4":"1","run6":"0","average":"4.50","strike":"90.00","catches":"1","stumpings":"0"}},"bowling":{"t20":{"match_id":0,"inning_id":0,"matches":105,"innings":93,"balls":1776,"overs":296,"runs":1847,"wickets":84,"bestinning":"4\/28","bestmatch":"4\/28","econ":"6.23","average":"21.98","strike":"21.1","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":96,"innings":0,"balls":4172,"overs":695.2,"runs":2909,"wickets":96,"bestinning":"5\/36","bestmatch":"5\/36","econ":"4.18","average":"30.30","strike":"43.4","wicket4i":2,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":59,"innings":92,"balls":9081,"overs":1513.3,"runs":3766,"wickets":126,"bestinning":"6\/33","bestmatch":"7\/72","econ":"2.48","average":"29.88","strike":"72.0","wicket4i":4,"wicket5i":2,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"7","innings":"3","balls":"30","overs":"5","runs":"47","wickets":"1","bestinning":"1\/8","bestmatch":"1\/8","econ":"9.40","average":"47.00","strike":"30.00","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"fdc2ba517a52269dca6129076e298213","modified":"2025-06-20 17:13:54","datetime":"2025-06-20 17:13:54","api_version":"3.0"}', Modified = GetDate() WHERE Id = 749 AND DataTypeId = 6 END
Player profile of Bipul Sharma, 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*336/3 (80.4 ov)

 Day 1 - Session 3, England elected to bowl
LIVETodayEliminator

Raigad RoyalsRaigad Royals*5/0 (1.3 ov)

Kolhapur Tuskers164/7 (20 ov)

 Raigad Royals need 160 runs in 18.3 remaining overs
LIVETodayMatch 19

Lux Shyam Kolkata TigersLux Shyam Kolkata Tigers160/8 (20 ov)

Shrachi Rarh Tigers*131/7 (17.4 ov)

 Shrachi Rarh Tigers need 30 runs in 14 remaining balls
LIVEToday6th T20I

ScotlandScotland193/5 (20 ov)

Nepal*158/9 (18.3 ov)

 Nepal need 36 runs in 9 remaining balls
LIVETodayMatch 17

Bhopal LeopardsBhopal Leopards

Gwalior Cheetahs*110/4 (9.5 ov)

 Gwalior Cheetahs elected to bat
LIVETodayFinal

Anmol Kings HalarAnmol Kings Halar142/10 (19.4 ov)

JMD Kutch Riders143/4 (17.3 ov)

 JMD Kutch Riders won by 6 wickets
LIVETodayFinal

Tally RangersTally Rangers*0/0 ( ov)

ACE KRM Panthers199/7 (20 ov)

 Innings Break : Tally Rangers need 200 runs in 20 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

NorthamptonshireNorthamptonshire

Nottinghamshire

 
LIVETodayMatch 67

GlamorganGlamorgan

Somerset

 Somerset won the toss and elected to field
LIVETodayMatch 69

DurhamDurham

Yorkshire

 
CancelledTodayMatch 11

Diamond DazzlersDiamond Dazzlers10/1 (2 ov)

Alembic Warriors

 Match Abandoned
ScheduledTodayMatch 64

SurreySurrey

Middlesex

 
ScheduledTodayMatch 66

GloucestershireGloucestershire

Hampshire

 
ScheduledTodayMatch 68

EssexEssex

Kent

 
ScheduledTodayMatch 70

DerbyshireDerbyshire

Lancashire

 
ScheduledTodayMatch 71

WarwickshireWarwickshire

Worcestershire

 
CricDirect Cricket News, Results and Stats
 

Bipul Sharma

NationalityIndia
RoleAll Rounder
Born28 Sep 1983 (41)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 105 77 26 1203 79 23.58 868 138.59 - 3
List A 96 71 15 1620 100 28.92 1693 95.68 1 8
1st Class 59 75 11 3012 200 47.06 4815 62.55 8 17

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 105 93 296 1847 84 4/28 21.98 6.23 21.1 1 -
List A 96 - 695.2 2909 96 5/36 30.30 4.18 43.4 2 1
1st Class 59 92 1513.3 3766 126 6/33 29.88 2.48 72.0 4 2
× Close