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:ab0a22de-0e8e-484b-832f-893ac95612bf Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1717 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1717,6,'{"status":"ok","response":{"player":{"pid":1717,"title":"Nadeem Ahmed","short_name":"N Ahmed","first_name":"Nadeem Ahmed","last_name":"","middle_name":"","birthdate":"1987-09-28","birthplace":"","country":"hk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Hong Kong"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":25,"innings":16,"notout":4,"runs":67,"balls":151,"highest":14,"run100":0,"run50":0,"run4":5,"run6":0,"average":"5.58","strike":"44.37","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":24,"innings":9,"notout":4,"runs":34,"balls":55,"highest":10,"run100":0,"run50":0,"run4":2,"run6":0,"average":"6.80","strike":"61.81","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":37,"innings":11,"notout":6,"runs":44,"balls":60,"highest":10,"run100":0,"run50":0,"run4":2,"run6":1,"average":"8.80","strike":"73.33","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":45,"innings":29,"notout":10,"runs":163,"balls":248,"highest":24,"run100":0,"run50":0,"run4":14,"run6":2,"average":"8.57","strike":"65.72","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"notout":0,"runs":94,"balls":237,"highest":29,"run100":0,"run50":0,"run4":0,"run6":0,"average":"8.54","strike":"39.66","catches":1,"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":{"odi":{"match_id":0,"inning_id":0,"matches":25,"innings":25,"balls":1327,"overs":221.1,"runs":932,"wickets":38,"bestinning":"4\/26","bestmatch":"4\/26","econ":"4.21","average":"24.52","strike":"34.9","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":24,"innings":24,"balls":495,"overs":82.3,"runs":546,"wickets":25,"bestinning":"4\/21","bestmatch":"4\/21","econ":"6.61","average":"21.84","strike":"19.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":37,"innings":37,"balls":778,"overs":129.4,"runs":873,"wickets":41,"bestinning":"5\/12","bestmatch":"5\/12","econ":"6.73","average":"21.29","strike":"18.9","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":45,"innings":0,"balls":2334,"overs":389,"runs":1659,"wickets":63,"bestinning":"4\/26","bestmatch":"4\/26","econ":"4.26","average":"26.33","strike":"37.0","wicket4i":6,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":0,"balls":1557,"overs":259.3,"runs":752,"wickets":31,"bestinning":"5\/72","bestmatch":"","econ":"2.89","average":"24.25","strike":"50.2","wicket4i":3,"wicket5i":1,"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":"69eb8b9aa78206ea47f92f96881dbd0e","modified":"2025-07-12 20:05:06","datetime":"2025-07-12 20:05:06","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1717,"title":"Nadeem Ahmed","short_name":"N Ahmed","first_name":"Nadeem Ahmed","last_name":"","middle_name":"","birthdate":"1987-09-28","birthplace":"","country":"hk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Left Arm Orthodox","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Hong Kong"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":25,"innings":16,"notout":4,"runs":67,"balls":151,"highest":14,"run100":0,"run50":0,"run4":5,"run6":0,"average":"5.58","strike":"44.37","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":24,"innings":9,"notout":4,"runs":34,"balls":55,"highest":10,"run100":0,"run50":0,"run4":2,"run6":0,"average":"6.80","strike":"61.81","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":37,"innings":11,"notout":6,"runs":44,"balls":60,"highest":10,"run100":0,"run50":0,"run4":2,"run6":1,"average":"8.80","strike":"73.33","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":45,"innings":29,"notout":10,"runs":163,"balls":248,"highest":24,"run100":0,"run50":0,"run4":14,"run6":2,"average":"8.57","strike":"65.72","catches":17,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":11,"notout":0,"runs":94,"balls":237,"highest":29,"run100":0,"run50":0,"run4":0,"run6":0,"average":"8.54","strike":"39.66","catches":1,"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":{"odi":{"match_id":0,"inning_id":0,"matches":25,"innings":25,"balls":1327,"overs":221.1,"runs":932,"wickets":38,"bestinning":"4\/26","bestmatch":"4\/26","econ":"4.21","average":"24.52","strike":"34.9","wicket4i":4,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":24,"innings":24,"balls":495,"overs":82.3,"runs":546,"wickets":25,"bestinning":"4\/21","bestmatch":"4\/21","econ":"6.61","average":"21.84","strike":"19.8","wicket4i":1,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":37,"innings":37,"balls":778,"overs":129.4,"runs":873,"wickets":41,"bestinning":"5\/12","bestmatch":"5\/12","econ":"6.73","average":"21.29","strike":"18.9","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":45,"innings":0,"balls":2334,"overs":389,"runs":1659,"wickets":63,"bestinning":"4\/26","bestmatch":"4\/26","econ":"4.26","average":"26.33","strike":"37.0","wicket4i":6,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":7,"innings":0,"balls":1557,"overs":259.3,"runs":752,"wickets":31,"bestinning":"5\/72","bestmatch":"","econ":"2.89","average":"24.25","strike":"50.2","wicket4i":3,"wicket5i":1,"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":"69eb8b9aa78206ea47f92f96881dbd0e","modified":"2025-07-12 20:05:06","datetime":"2025-07-12 20:05:06","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1717 AND DataTypeId = 6 END
Player profile of Nadeem Ahmed, Hong Kong
CricDirect Cricket News, Results and Stats
 

Nadeem Ahmed

NationalityHong Kong
RoleBatter
Born28 Sep 1987 (37)
Batting StyleRight Hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 25 16 4 67 14 5.58 151 44.37 - -
T20I 24 9 4 34 10 6.80 55 61.81 - -
T20I 37 11 6 44 10 8.80 60 73.33 - -
List A 45 29 10 163 24 8.57 248 65.72 - -
1st Class 7 11 - 94 29 8.54 237 39.66 - -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 25 25 221.1 932 38 4/26 24.52 4.21 34.9 4 -
T20i 24 24 82.3 546 25 4/21 21.84 6.61 19.8 1 -
T20 37 37 129.4 873 41 5/12 21.29 6.73 18.9 1 1
List A 45 - 389 1659 63 4/26 26.33 4.26 37.0 6 -
1st Class 7 - 259.3 752 31 5/72 24.25 2.89 50.2 3 1
× Close