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:99683131-2f06-4891-9dd6-fb1d12e3264e Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 49850 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (49850,6,'{"status":"ok","response":{"player":{"pid":49850,"title":"Ayaz Tasawar","short_name":"Ayaz Tasawar","first_name":"Ayaz Tasawar","last_name":"","middle_name":"","birthdate":"1990-12-10","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","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":23,"innings":17,"notout":3,"runs":237,"balls":252,"highest":64,"run100":0,"run50":1,"run4":16,"run6":9,"average":"16.92","strike":"94.04","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":71,"innings":62,"notout":16,"runs":1852,"balls":2271,"highest":100,"run100":1,"run50":12,"run4":150,"run6":37,"average":"40.26","strike":"81.54","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":101,"innings":164,"notout":22,"runs":5311,"balls":10072,"highest":149,"run100":8,"run50":30,"run4":629,"run6":46,"average":"37.40","strike":"52.73","catches":84,"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":23,"innings":1,"balls":2,"overs":0.2,"runs":2,"wickets":0,"bestinning":"","bestmatch":"","econ":"6.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":71,"innings":6,"balls":211,"overs":35.1,"runs":196,"wickets":5,"bestinning":"3\/39","bestmatch":"3\/39","econ":"5.57","average":"39.20","strike":"42.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":101,"innings":8,"balls":246,"overs":41,"runs":144,"wickets":1,"bestinning":"1\/36","bestmatch":"1\/40","econ":"3.51","average":"144.00","strike":"246.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":"19acc83ca605c6e8c1032436cc30af39","modified":"2025-06-05 11:25:16","datetime":"2025-06-05 11:25:16","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":49850,"title":"Ayaz Tasawar","short_name":"Ayaz Tasawar","first_name":"Ayaz Tasawar","last_name":"","middle_name":"","birthdate":"1990-12-10","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Left hand Bat","bowling_style":"Right Arm Leg Spin","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":23,"innings":17,"notout":3,"runs":237,"balls":252,"highest":64,"run100":0,"run50":1,"run4":16,"run6":9,"average":"16.92","strike":"94.04","catches":9,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":71,"innings":62,"notout":16,"runs":1852,"balls":2271,"highest":100,"run100":1,"run50":12,"run4":150,"run6":37,"average":"40.26","strike":"81.54","catches":20,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":101,"innings":164,"notout":22,"runs":5311,"balls":10072,"highest":149,"run100":8,"run50":30,"run4":629,"run6":46,"average":"37.40","strike":"52.73","catches":84,"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":23,"innings":1,"balls":2,"overs":0.2,"runs":2,"wickets":0,"bestinning":"","bestmatch":"","econ":"6.00","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":71,"innings":6,"balls":211,"overs":35.1,"runs":196,"wickets":5,"bestinning":"3\/39","bestmatch":"3\/39","econ":"5.57","average":"39.20","strike":"42.2","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":101,"innings":8,"balls":246,"overs":41,"runs":144,"wickets":1,"bestinning":"1\/36","bestmatch":"1\/40","econ":"3.51","average":"144.00","strike":"246.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":"19acc83ca605c6e8c1032436cc30af39","modified":"2025-06-05 11:25:16","datetime":"2025-06-05 11:25:16","api_version":"3.0"}', Modified = GetDate() WHERE Id = 49850 AND DataTypeId = 6 END
Player profile of Ayaz Tasawar, Pakistan
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVETodayPratice Match

South AfricaSouth Africa313/7d (79 ov)

Zimbabwe*48/1 (11 ov)

 Match Start Delay : Day 3 - Zimbabwe trail by 265 runs.
LIVETodayMatch 2

Raigad RoyalsRaigad Royals190/6 (20 ov)

Satara Warriors*56/2 (10.2 ov)

 Satara Warriors need 135 runs in 58 remaining balls
LIVETodayMatch 6

Namo Bandra BlastersNamo Bandra Blasters*15/1 (2.3 ov)

Eagle Thane Strikers205/6 (20 ov)

 Namo Bandra Blasters need 191 runs in 17.3 remaining overs
LIVETodayMatch 1

Pagariya StrikersPagariya Strikers*11/1 (2 ov)

Nagpur Titans122/8 (20 ov)

 Pagariya Strikers need 112 runs in 18.0 remaining overs
LIVETodayMatch 17

RainhamRainham

Mighty Tigers0/0 ( ov)

 Rain Delay : Rainham elected to bowl
LIVETodayMatch 11

Rwanda WomenRwanda Women0/0 ( ov)

Malawi Women

 Malawi Women elected to bowl
LIVETodayMatch 12

Nigeria WomenNigeria Women

Tanzania Women

 
Cancelled05 June Match 5

Hong Kong WomenHong Kong Women

Philippines Women

 Match Abandoned
CancelledTodayMatch 16

Sharks Cricket AcademySharks Cricket Academy

Mighty Tigers

 Match abondoned due to rain
ScheduledTodayMatch 7

SOBO Mumbai FalconsSOBO Mumbai Falcons

North Mumbai Panthers

 
Scheduled05 June Match 18

Sharks Cricket AcademySharks Cricket Academy

Rainham

 
Scheduled05 June Match 10

Surrey WomenSurrey Women

Hampshire Women

 
Scheduled05 June Match 2

Ratnagiri Jets WomenRatnagiri Jets Women

Raigad Royals Women

 
Scheduled05 June Match 1

Dindigul DragonsDindigul Dragons

Lyca Kovai Kings

 
Scheduled05 June Match 8

Triumph Knights MNETriumph Knights MNE

Mumbai South Central Maratha Royals

 
Scheduled05 June Match 19

Sharks Cricket AcademySharks Cricket Academy

Hornchurch

 
Scheduled05 June Match 10

AnguillaAnguilla

Nevis

 
Scheduled05 June Match 19

MEC Study GroupMEC Study Group

Thunder Cats

 
CricDirect Cricket News, Results and Stats
 

Ayaz Tasawar

NationalityPakistan
RoleAll Rounder
Born10 Dec 1990 (34)
Batting StyleLeft hand Bat
Bowling StyleRight Arm Leg Spin

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 23 17 3 237 64 16.92 252 94.04 - 1
List A 71 62 16 1852 100 40.26 2271 81.54 1 12
1st Class 101 164 22 5311 149 37.40 10072 52.73 8 30

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 23 1 0.2 2 - - - 6.00 - - -
List A 71 6 35.1 196 5 3/39 39.20 5.57 42.2 - -
1st Class 101 8 41 144 1 1/36 144.00 3.51 246.0 - -
× Close