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:bc3743bf-7230-4d5e-afb4-929e4941a44c Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 139 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (139,6,'{"status":"ok","response":{"player":{"pid":139,"title":"Younis Khan","short_name":"Y Khan","first_name":"Younis Khan","last_name":"","middle_name":"","birthdate":"1977-11-29","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right 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":"","bowling_type":"Spin","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":118,"innings":213,"notout":19,"runs":10099,"balls":19375,"highest":313,"run100":34,"run50":33,"run4":1082,"run6":70,"average":"52.05","strike":"52.12","catches":139,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":265,"innings":255,"notout":23,"runs":7249,"balls":9628,"highest":144,"run100":7,"run50":48,"run4":578,"run6":56,"average":"31.24","strike":"75.29","catches":135,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":25,"innings":23,"notout":3,"runs":442,"balls":364,"highest":51,"run100":0,"run50":2,"run4":31,"run6":12,"average":"22.10","strike":"121.42","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":83,"innings":78,"notout":17,"runs":1864,"balls":1589,"highest":71,"run100":0,"run50":10,"run4":144,"run6":37,"average":"30.55","strike":"117.30","catches":34,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":351,"innings":331,"notout":36,"runs":9911,"balls":0,"highest":144,"run100":12,"run50":64,"run4":0,"run6":0,"average":"33.59","strike":"","catches":196,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":229,"innings":385,"notout":42,"runs":17116,"balls":0,"highest":313,"run100":56,"run50":64,"run4":0,"run6":0,"average":"49.90","strike":"","catches":243,"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":{"test":{"match_id":0,"inning_id":0,"matches":118,"innings":31,"balls":804,"overs":134,"runs":491,"wickets":9,"bestinning":"2\/23","bestmatch":"4\/50","econ":"3.66","average":"54.55","strike":"89.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":265,"innings":20,"balls":284,"overs":47.2,"runs":288,"wickets":3,"bestinning":"1\/3","bestmatch":"1\/3","econ":"6.08","average":"96.00","strike":"94.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":25,"innings":1,"balls":22,"overs":3.4,"runs":18,"wickets":3,"bestinning":"3\/18","bestmatch":"3\/18","econ":"4.90","average":"6.00","strike":"7.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":83,"innings":7,"balls":104,"overs":17.2,"runs":136,"wickets":6,"bestinning":"3\/18","bestmatch":"3\/18","econ":"7.84","average":"22.66","strike":"17.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":351,"innings":0,"balls":1169,"overs":194.5,"runs":1127,"wickets":28,"bestinning":"3\/5","bestmatch":"3\/5","econ":"5.78","average":"40.25","strike":"41.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":229,"innings":0,"balls":3620,"overs":603.2,"runs":2120,"wickets":44,"bestinning":"4\/52","bestmatch":"","econ":"3.51","average":"48.18","strike":"82.2","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":"dadc9715bf4e831c2a4ca2c9c9b12186","modified":"2025-07-30 01:43:16","datetime":"2025-07-30 01:43:16","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":139,"title":"Younis Khan","short_name":"Y Khan","first_name":"Younis Khan","last_name":"","middle_name":"","birthdate":"1977-11-29","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right 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":"","bowling_type":"Spin","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":118,"innings":213,"notout":19,"runs":10099,"balls":19375,"highest":313,"run100":34,"run50":33,"run4":1082,"run6":70,"average":"52.05","strike":"52.12","catches":139,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":265,"innings":255,"notout":23,"runs":7249,"balls":9628,"highest":144,"run100":7,"run50":48,"run4":578,"run6":56,"average":"31.24","strike":"75.29","catches":135,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":25,"innings":23,"notout":3,"runs":442,"balls":364,"highest":51,"run100":0,"run50":2,"run4":31,"run6":12,"average":"22.10","strike":"121.42","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":83,"innings":78,"notout":17,"runs":1864,"balls":1589,"highest":71,"run100":0,"run50":10,"run4":144,"run6":37,"average":"30.55","strike":"117.30","catches":34,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":351,"innings":331,"notout":36,"runs":9911,"balls":0,"highest":144,"run100":12,"run50":64,"run4":0,"run6":0,"average":"33.59","strike":"","catches":196,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":229,"innings":385,"notout":42,"runs":17116,"balls":0,"highest":313,"run100":56,"run50":64,"run4":0,"run6":0,"average":"49.90","strike":"","catches":243,"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":{"test":{"match_id":0,"inning_id":0,"matches":118,"innings":31,"balls":804,"overs":134,"runs":491,"wickets":9,"bestinning":"2\/23","bestmatch":"4\/50","econ":"3.66","average":"54.55","strike":"89.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":265,"innings":20,"balls":284,"overs":47.2,"runs":288,"wickets":3,"bestinning":"1\/3","bestmatch":"1\/3","econ":"6.08","average":"96.00","strike":"94.6","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":25,"innings":1,"balls":22,"overs":3.4,"runs":18,"wickets":3,"bestinning":"3\/18","bestmatch":"3\/18","econ":"4.90","average":"6.00","strike":"7.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":83,"innings":7,"balls":104,"overs":17.2,"runs":136,"wickets":6,"bestinning":"3\/18","bestmatch":"3\/18","econ":"7.84","average":"22.66","strike":"17.3","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":351,"innings":0,"balls":1169,"overs":194.5,"runs":1127,"wickets":28,"bestinning":"3\/5","bestmatch":"3\/5","econ":"5.78","average":"40.25","strike":"41.7","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":229,"innings":0,"balls":3620,"overs":603.2,"runs":2120,"wickets":44,"bestinning":"4\/52","bestmatch":"","econ":"3.51","average":"48.18","strike":"82.2","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":"dadc9715bf4e831c2a4ca2c9c9b12186","modified":"2025-07-30 01:43:16","datetime":"2025-07-30 01:43:16","api_version":"3.0"}', Modified = GetDate() WHERE Id = 139 AND DataTypeId = 6 END
Player profile of Younis Khan, Pakistan
CricDirect Cricket News, Results and Stats
 

Younis Khan

NationalityPakistan
RoleBatter
Born29 Nov 1977 (47)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Leg Spin

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 118 213 19 10099 313 52.05 19375 52.12 34 33
ODI 265 255 23 7249 144 31.24 9628 75.29 7 48
T20I 25 23 3 442 51 22.10 364 121.42 - 2
T20I 83 78 17 1864 71 30.55 1589 117.30 - 10
List A 351 331 36 9911 144 33.59 - - 12 64
1st Class 229 385 42 17116 313 49.90 - - 56 64

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 118 31 134 491 9 2/23 54.55 3.66 89.3 - -
ODI 265 20 47.2 288 3 1/3 96.00 6.08 94.6 - -
T20i 25 1 3.4 18 3 3/18 6.00 4.90 7.3 - -
T20 83 7 17.2 136 6 3/18 22.66 7.84 17.3 - -
List A 351 - 194.5 1127 28 3/5 40.25 5.78 41.7 - -
1st Class 229 - 603.2 2120 44 4/52 48.18 3.51 82.2 - -
× Close