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:b049a13a-fdd4-4019-b23a-9ba9b1bb305c Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 94546 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (94546,6,'{"status":"ok","response":{"player":{"pid":94546,"title":"Asad Pathan","short_name":"A Pathan","first_name":"Asad Pathan","last_name":"","middle_name":"","birthdate":"1984-06-17","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":34,"innings":33,"notout":5,"runs":656,"balls":441,"highest":87,"run100":0,"run50":4,"run4":75,"run6":28,"average":"23.42","strike":"148.75","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":20,"notout":0,"runs":383,"balls":391,"highest":63,"run100":0,"run50":2,"run4":59,"run6":7,"average":"19.15","strike":"97.95","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":2,"innings":4,"notout":0,"runs":28,"balls":74,"highest":24,"run100":0,"run50":0,"run4":4,"run6":0,"average":"7.00","strike":"37.83","catches":0,"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":34,"innings":3,"balls":39,"overs":6.3,"runs":63,"wickets":0,"bestinning":"","bestmatch":"","econ":"9.69","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":2,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","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":"46faf673eda504a0f4f5db5ead28aa1f","modified":"2025-06-10 10:25:17","datetime":"2025-06-10 10:25:17","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":94546,"title":"Asad Pathan","short_name":"A Pathan","first_name":"Asad Pathan","last_name":"","middle_name":"","birthdate":"1984-06-17","birthplace":"","country":"in","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","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":34,"innings":33,"notout":5,"runs":656,"balls":441,"highest":87,"run100":0,"run50":4,"run4":75,"run6":28,"average":"23.42","strike":"148.75","catches":8,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":20,"notout":0,"runs":383,"balls":391,"highest":63,"run100":0,"run50":2,"run4":59,"run6":7,"average":"19.15","strike":"97.95","catches":2,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":2,"innings":4,"notout":0,"runs":28,"balls":74,"highest":24,"run100":0,"run50":0,"run4":4,"run6":0,"average":"7.00","strike":"37.83","catches":0,"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":34,"innings":3,"balls":39,"overs":6.3,"runs":63,"wickets":0,"bestinning":"","bestmatch":"","econ":"9.69","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":20,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":2,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","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":"46faf673eda504a0f4f5db5ead28aa1f","modified":"2025-06-10 10:25:17","datetime":"2025-06-10 10:25:17","api_version":"3.0"}', Modified = GetDate() WHERE Id = 94546 AND DataTypeId = 6 END
Player profile of Asad Pathan, India
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVETodayMatch 5

South Africa ASouth Africa A*324/7 (102 ov)

West Indies A220/10 (68.1 ov)

 Stumps : Day 2 - South Africa A lead by 104 runs.
LIVETodayMatch 25

Uganda WomenUganda Women99/6 (20 ov)

Tanzania Women79/10 (18 ov)

 Uganda Women won by 20 runs
LIVETodayMatch 26

Nigeria WomenNigeria Women107/10 (19.3 ov)

Malawi Women*40/5 (13.4 ov)

 Malawi Women need 68 runs in 38 remaining balls
LIVETodayMatch 5

CzechiaCzechia*14/1 (2 ov)

Norway174/6 (20 ov)

 Czechia need 161 runs in 18.0 remaining overs
LIVETodayMatch 10

Kolhapur TuskersKolhapur Tuskers

Satara Warriors*139/6 (17.3 ov)

 Satara Warriors elected to bat
LIVETodayMatch 31

Old BrentwoodsOld Brentwoods224/2 (10 ov)

Gagan*177/7 (9.3 ov)

 Gagan need 48 runs in 3 remaining balls
LIVEToday1st Semi Final

Eagle Thane StrikersEagle Thane Strikers*92/4 (16.2 ov)

Mumbai South Central Maratha Royals

 Eagle Thane Strikers elected to bat
LIVETodayMatch 10

NECO Master BlasterNECO Master Blaster

Orange Tigers*110/3 (14.2 ov)

 NECO Master Blaster elected to bowl
LIVETodayMatch 78

NetherlandsNetherlands

Nepal*20/0 (4.3 ov)

 Netherlands elected to bowl
LIVETodayMatch 3

Netherlands WomenNetherlands Women

United States of America Women

 Toss delayed due to rain
LIVETodayMatch 32

Old BrentwoodsOld Brentwoods

East Londoners

 Old Brentwoods elected to bowl
Scheduled10 June Match 27

Zimbabwe HPC WomenZimbabwe HPC Women

Cameroon Women

 
Scheduled10 June Match 28

Brazil WomenBrazil Women

Rwanda Women

 
Scheduled10 June Match 6

NorwayNorway

Austria

 
Scheduled10 June Match 33

GaganGagan

East Londoners

 
Scheduled10 June Match 11

Puneri BappaPuneri Bappa

Eagle Nashik Titans

 
Scheduled10 June Match 7

Salem SpartansSalem Spartans

Trichy Grand Chola

 
Scheduled10 June 2nd Semi Final

SOBO Mumbai FalconsSOBO Mumbai Falcons

Namo Bandra Blasters

 
CricDirect Cricket News, Results and Stats
 

Asad Pathan

NationalityIndia
RoleBatter
Born17 Jun 1984 (40)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 34 33 5 656 87 23.42 441 148.75 - 4
List A 20 20 - 383 63 19.15 391 97.95 - 2
1st Class 2 4 - 28 24 7.00 74 37.83 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 34 3 6.3 63 - - - 9.69 - - -
List A 20 - - - - - - - - - -
1st Class 2 - - - - - - - - - -
× Close