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:43b874ba-c589-4839-8256-3e2b53129186 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53466 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53466,6,'{"status":"ok","response":{"player":{"pid":53466,"title":"Waqar Ahmed","short_name":"Waqar Ahmed","first_name":"Waqar Ahmed","last_name":"","middle_name":"","birthdate":"1980-04-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":14,"innings":10,"notout":4,"runs":71,"balls":68,"highest":40,"run100":0,"run50":0,"run4":5,"run6":3,"average":"11.83","strike":"104.41","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":51,"innings":33,"notout":9,"runs":247,"balls":0,"highest":41,"run100":0,"run50":0,"run4":0,"run6":0,"average":"10.29","strike":"","catches":7,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":107,"innings":156,"notout":31,"runs":1296,"balls":0,"highest":47,"run100":0,"run50":0,"run4":0,"run6":0,"average":"10.36","strike":"","catches":26,"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":14,"innings":12,"balls":246,"overs":41,"runs":366,"wickets":14,"bestinning":"3\/28","bestmatch":"3\/28","econ":"8.92","average":"26.14","strike":"17.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":51,"innings":0,"balls":2089,"overs":348.1,"runs":1881,"wickets":64,"bestinning":"4\/26","bestmatch":"4\/26","econ":"5.40","average":"29.39","strike":"32.6","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":107,"innings":0,"balls":17070,"overs":2845,"runs":9840,"wickets":408,"bestinning":"8\/96","bestmatch":"","econ":"3.45","average":"24.11","strike":"41.8","wicket4i":0,"wicket5i":26,"wicket10m":5,"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":"e91cd6787d41f86d41c220ed46415ce3","modified":"2025-06-21 19:59:18","datetime":"2025-06-21 19:59:18","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53466,"title":"Waqar Ahmed","short_name":"Waqar Ahmed","first_name":"Waqar Ahmed","last_name":"","middle_name":"","birthdate":"1980-04-01","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"Left Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":14,"innings":10,"notout":4,"runs":71,"balls":68,"highest":40,"run100":0,"run50":0,"run4":5,"run6":3,"average":"11.83","strike":"104.41","catches":1,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":51,"innings":33,"notout":9,"runs":247,"balls":0,"highest":41,"run100":0,"run50":0,"run4":0,"run6":0,"average":"10.29","strike":"","catches":7,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":107,"innings":156,"notout":31,"runs":1296,"balls":0,"highest":47,"run100":0,"run50":0,"run4":0,"run6":0,"average":"10.36","strike":"","catches":26,"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":14,"innings":12,"balls":246,"overs":41,"runs":366,"wickets":14,"bestinning":"3\/28","bestmatch":"3\/28","econ":"8.92","average":"26.14","strike":"17.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":51,"innings":0,"balls":2089,"overs":348.1,"runs":1881,"wickets":64,"bestinning":"4\/26","bestmatch":"4\/26","econ":"5.40","average":"29.39","strike":"32.6","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":107,"innings":0,"balls":17070,"overs":2845,"runs":9840,"wickets":408,"bestinning":"8\/96","bestmatch":"","econ":"3.45","average":"24.11","strike":"41.8","wicket4i":0,"wicket5i":26,"wicket10m":5,"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":"e91cd6787d41f86d41c220ed46415ce3","modified":"2025-06-21 19:59:18","datetime":"2025-06-21 19:59:18","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53466 AND DataTypeId = 6 END
Player profile of Waqar Ahmed, Pakistan
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVEToday1st Test

EnglandEngland*209/3 (49 ov)

India471/10 (113 ov)

 Stumps : Day 2 - England trail by 262 runs.
LIVETodayMatch 1

West Indies AcademyWest Indies Academy237/10 (46.2 ov)

Sri Lanka Emerging*178/3 (32.4 ov)

 Sri Lanka Emerging need 60 runs in 17.2 remaining overs
LIVETodayMatch 9

Thunder Cats-BThunder Cats-B*57/4 (8 ov)

Lexus193/4 (20 ov)

 Thunder Cats-B need 137 runs in 12.0 remaining overs
LIVETodayMatch 32

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

Soca Kings122/4 (10 ov)

 Chicago Steelpan Players need 106 runs in 52 remaining balls
LIVETodayMatch 10

Cayman IslandsCayman Islands

Bermuda

 Toss dealyed due to rain
Cancelled21 June Match 12

Diamond DazzlersDiamond Dazzlers121/8 (20 ov)

Pruthvi Panthers

 Match Abandoned
Scheduled22 June Match 11

MI New YorkMI New York

Washington Freedom

 
Scheduled22 June Match 15

Irises Cricket ClubIrises Cricket Club

Yuksom Capitals

 
Scheduled22 June Match 21

Adamas Howrah Warriors WomensAdamas Howrah Warriors Womens

Servotech Siliguri Strikers Womens

 
Scheduled22 June Eliminator

Brno CCBrno CC

Bohemians

 
Scheduled22 June Match 16

Black Eagle SAPBlack Eagle SAP

Avengers CC

 
Scheduled22 June Match 22

Murshidabad KingsMurshidabad Kings

Rashmi Medinipur Wizards

 
Scheduled22 June Match 3

Bhopal Wolves WomenBhopal Wolves Women

Bundelkhand Bulls Women

 
Scheduled22 June Match 22

Shrachi Rarh Tigers WomensShrachi Rarh Tigers Womens

Lux Shyam Kolkata Tigers Womens

 
Scheduled22 June Qualifier 1

Prague TigersPrague Tigers

Prague CC

 
Scheduled22 June Match 14

Diamond DazzlersDiamond Dazzlers

Ami Super Avengers

 
Scheduled22 June Match 20

Bhopal LeopardsBhopal Leopards

Indore Pink Panthers

 
Scheduled22 June Match 19

Salem SpartansSalem Spartans

Dindigul Dragons

 
CricDirect Cricket News, Results and Stats
 

Waqar Ahmed

NationalityPakistan
RoleBatter
Born01 Apr 1980 (45)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 14 10 4 71 40 11.83 68 104.41 - -
List A 51 33 9 247 41 10.29 - - - -
1st Class 107 156 31 1296 47 10.36 - - - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 14 12 41 366 14 3/28 26.14 8.92 17.5 - -
List A 51 - 348.1 1881 64 4/26 29.39 5.40 32.6 3 -
1st Class 107 - 2845 9840 408 8/96 24.11 3.45 41.8 - 26
× Close