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:e869687f-483f-4072-895c-3b5fab34779e Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53443 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53443,6,'{"status":"ok","response":{"player":{"pid":53443,"title":"Jalat Khan","short_name":"Jalat Khan","first_name":"Jalat Khan","last_name":"","middle_name":"","birthdate":"1986-02-03","birthplace":"","country":"pk","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":42,"innings":36,"notout":8,"runs":397,"balls":402,"highest":37,"run100":0,"run50":0,"run4":34,"run6":7,"average":"14.17","strike":"98.75","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":77,"innings":70,"notout":10,"runs":893,"balls":0,"highest":55,"run100":0,"run50":1,"run4":0,"run6":0,"average":"14.88","strike":"","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":160,"notout":9,"runs":3243,"balls":0,"highest":170,"run100":2,"run50":10,"run4":0,"run6":0,"average":"21.47","strike":"","catches":45,"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":42,"innings":42,"balls":891,"overs":148.3,"runs":1101,"wickets":44,"bestinning":"5\/23","bestmatch":"5\/23","econ":"7.41","average":"25.02","strike":"20.2","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":77,"innings":0,"balls":3555,"overs":592.3,"runs":3070,"wickets":66,"bestinning":"4\/44","bestmatch":"4\/44","econ":"5.18","average":"46.51","strike":"53.8","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":0,"balls":14037,"overs":2339.3,"runs":7116,"wickets":210,"bestinning":"6\/35","bestmatch":"","econ":"3.04","average":"33.88","strike":"66.8","wicket4i":10,"wicket5i":7,"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":"0193c79a1d84588d507422d322ed9b0e","modified":"2025-06-13 20:50:08","datetime":"2025-06-13 20:50:08","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53443,"title":"Jalat Khan","short_name":"Jalat Khan","first_name":"Jalat Khan","last_name":"","middle_name":"","birthdate":"1986-02-03","birthplace":"","country":"pk","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":9,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Pakistan"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":42,"innings":36,"notout":8,"runs":397,"balls":402,"highest":37,"run100":0,"run50":0,"run4":34,"run6":7,"average":"14.17","strike":"98.75","catches":10,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":77,"innings":70,"notout":10,"runs":893,"balls":0,"highest":55,"run100":0,"run50":1,"run4":0,"run6":0,"average":"14.88","strike":"","catches":27,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":160,"notout":9,"runs":3243,"balls":0,"highest":170,"run100":2,"run50":10,"run4":0,"run6":0,"average":"21.47","strike":"","catches":45,"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":42,"innings":42,"balls":891,"overs":148.3,"runs":1101,"wickets":44,"bestinning":"5\/23","bestmatch":"5\/23","econ":"7.41","average":"25.02","strike":"20.2","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":77,"innings":0,"balls":3555,"overs":592.3,"runs":3070,"wickets":66,"bestinning":"4\/44","bestmatch":"4\/44","econ":"5.18","average":"46.51","strike":"53.8","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":0,"balls":14037,"overs":2339.3,"runs":7116,"wickets":210,"bestinning":"6\/35","bestmatch":"","econ":"3.04","average":"33.88","strike":"66.8","wicket4i":10,"wicket5i":7,"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":"0193c79a1d84588d507422d322ed9b0e","modified":"2025-06-13 20:50:08","datetime":"2025-06-13 20:50:08","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53443 AND DataTypeId = 6 END
Player profile of Jalat Khan, Pakistan
<>
LIVE06 May Match 5

Hong Kong WomenHong Kong Women

Kuwait Women

 
LIVE06 May Match 6

Thailand WomenThailand Women

United Arab Emirates Women

 
LIVETodayFinal

South AfricaSouth Africa138/10 (57.1 ov) & *213/2 (56 ov)

Australia212/10 (56.4 ov) & 207/10 (65 ov)

 Stumps : Day 3 - South Africa need 69 runs to win.
LIVETodayMatch 45

NorthamptonshireNorthamptonshire142/8 (20 ov)

Durham157/8 (20 ov)

 Durham won by 15 runs
LIVETodayMatch 21

Durham WomenDurham Women188/5 (20 ov)

The Blaze*190/3 (19 ov)

 Match completed
LIVETodayMatch 43

GloucestershireGloucestershire135/7 (20 ov)

Somerset137/4 (17.4 ov)

 Somerset won by 6 wickets
LIVETodayMatch 44

HampshireHampshire63/1 (6 ov)

Middlesex

 Innings Break : Middlesex elected to bowl
LIVETodayMatch 47

SussexSussex*23/3 (3.1 ov)

Essex177/4 (17 ov)

 Rain Delay : Sussex need 155 runs in 13.5 remaining overs
LIVETodayMatch 2

Thunder CatsThunder Cats*13/0 (3.4 ov)

Lexus189/4 (20 ov)

 Thunder Cats need 177 runs in 16.2 remaining overs
Cancelled13 June Match 2

Jabalpur LionsJabalpur Lions

Bhopal Leopards130/6 (16.0 ov)

 Match Abandoned
CancelledTodayMatch 16

Ratnagiri JetsRatnagiri Jets

Kolhapur Tuskers

 Match Abandoned
Scheduled14 June Match 2

MI New YorkMI New York

Texas Super Kings

 
Scheduled14 June Match 4

IndonesiaIndonesia

Cambodia

 
Scheduled14 June Match 5

Harbour Diamonds WomensHarbour Diamonds Womens

Lux Shyam Kolkata Tigers Womens

 
Scheduled14 June Match 5

IndonesiaIndonesia

Cambodia

 
Scheduled14 June Match 1

Czechia WomenCzechia Women

Gibraltar Women

 
Scheduled14 June 3rd Place Play-Off

Rwanda WomenRwanda Women

Uganda Women

 
Scheduled14 June Match 6

Lux Shyam Kolkata TigersLux Shyam Kolkata Tigers

Adamas Howrah Warriors

 
Scheduled14 June Match 6

Servotech Siliguri Strikers WomensServotech Siliguri Strikers Womens

Sobisco Smashers Malda Womens

 
Scheduled14 June Match 17

Kolhapur TuskersKolhapur Tuskers

Puneri Bappa

 
CricDirect Cricket News, Results and Stats
 

Jalat Khan

NationalityPakistan
RoleAll Rounder
Born03 Feb 1986 (39)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 42 36 8 397 37 14.17 402 98.75 - -
List A 77 70 10 893 55 14.88 - - - 1
1st Class 96 160 9 3243 170 21.47 - - 2 10

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 42 42 148.3 1101 44 5/23 25.02 7.41 20.2 1 1
List A 77 - 592.3 3070 66 4/44 46.51 5.18 53.8 2 -
1st Class 96 - 2339.3 7116 210 6/35 33.88 3.04 66.8 10 7
× Close