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:2d76f9ee-93d8-4de9-8e40-6db0079b76d0 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 771 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (771,6,'{"status":"ok","response":{"player":{"pid":771,"title":"Azhar Mahmood","short_name":"A Mahmood","first_name":"Azhar Mahmood","last_name":"","middle_name":"","birthdate":"1975-02-28","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":21,"innings":34,"notout":4,"runs":900,"balls":1772,"highest":136,"run100":3,"run50":1,"run4":113,"run6":5,"average":"30.00","strike":"50.79","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":143,"innings":110,"notout":26,"runs":1521,"balls":1988,"highest":67,"run100":0,"run50":3,"run4":119,"run6":24,"average":"18.10","strike":"76.50","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":230,"innings":207,"notout":47,"runs":4091,"balls":3023,"highest":106,"run100":2,"run50":18,"run4":383,"run6":138,"average":"25.56","strike":"135.32","catches":45,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":319,"innings":256,"notout":49,"runs":4555,"balls":0,"highest":101,"run100":2,"run50":19,"run4":0,"run6":0,"average":"22.00","strike":"","catches":95,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":176,"innings":274,"notout":32,"runs":7703,"balls":0,"highest":204,"run100":9,"run50":42,"run4":0,"run6":0,"average":"31.83","strike":"","catches":142,"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":21,"innings":35,"balls":3015,"overs":502.3,"runs":1402,"wickets":39,"bestinning":"4\/50","bestmatch":"5\/95","econ":"2.79","average":"35.94","strike":"77.3","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":143,"innings":139,"balls":6242,"overs":1040.2,"runs":4813,"wickets":123,"bestinning":"6\/18","bestmatch":"6\/18","econ":"4.62","average":"39.13","strike":"50.7","wicket4i":2,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":230,"innings":229,"balls":4825,"overs":804.1,"runs":6143,"wickets":258,"bestinning":"5\/24","bestmatch":"5\/24","econ":"7.63","average":"23.81","strike":"18.7","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":319,"innings":0,"balls":13952,"overs":2325.2,"runs":10919,"wickets":348,"bestinning":"6\/18","bestmatch":"6\/18","econ":"4.69","average":"31.37","strike":"40.0","wicket4i":13,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":176,"innings":0,"balls":29798,"overs":4966.2,"runs":15337,"wickets":611,"bestinning":"8\/61","bestmatch":"","econ":"3.08","average":"25.10","strike":"48.7","wicket4i":0,"wicket5i":27,"wicket10m":3,"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":"7035257b6dc9d7d7611eb3d861d555d9","modified":"2025-07-29 20:42:57","datetime":"2025-07-29 20:42:57","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":771,"title":"Azhar Mahmood","short_name":"A Mahmood","first_name":"Azhar Mahmood","last_name":"","middle_name":"","birthdate":"1975-02-28","birthplace":"","country":"pk","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Right Hand Bat","bowling_style":"Right Arm Fast Medium","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":8.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","bowling_type":"Pace","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":21,"innings":34,"notout":4,"runs":900,"balls":1772,"highest":136,"run100":3,"run50":1,"run4":113,"run6":5,"average":"30.00","strike":"50.79","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":143,"innings":110,"notout":26,"runs":1521,"balls":1988,"highest":67,"run100":0,"run50":3,"run4":119,"run6":24,"average":"18.10","strike":"76.50","catches":37,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":230,"innings":207,"notout":47,"runs":4091,"balls":3023,"highest":106,"run100":2,"run50":18,"run4":383,"run6":138,"average":"25.56","strike":"135.32","catches":45,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":319,"innings":256,"notout":49,"runs":4555,"balls":0,"highest":101,"run100":2,"run50":19,"run4":0,"run6":0,"average":"22.00","strike":"","catches":95,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":176,"innings":274,"notout":32,"runs":7703,"balls":0,"highest":204,"run100":9,"run50":42,"run4":0,"run6":0,"average":"31.83","strike":"","catches":142,"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":21,"innings":35,"balls":3015,"overs":502.3,"runs":1402,"wickets":39,"bestinning":"4\/50","bestmatch":"5\/95","econ":"2.79","average":"35.94","strike":"77.3","wicket4i":2,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":143,"innings":139,"balls":6242,"overs":1040.2,"runs":4813,"wickets":123,"bestinning":"6\/18","bestmatch":"6\/18","econ":"4.62","average":"39.13","strike":"50.7","wicket4i":2,"wicket5i":3,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":230,"innings":229,"balls":4825,"overs":804.1,"runs":6143,"wickets":258,"bestinning":"5\/24","bestmatch":"5\/24","econ":"7.63","average":"23.81","strike":"18.7","wicket4i":3,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":319,"innings":0,"balls":13952,"overs":2325.2,"runs":10919,"wickets":348,"bestinning":"6\/18","bestmatch":"6\/18","econ":"4.69","average":"31.37","strike":"40.0","wicket4i":13,"wicket5i":5,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":176,"innings":0,"balls":29798,"overs":4966.2,"runs":15337,"wickets":611,"bestinning":"8\/61","bestmatch":"","econ":"3.08","average":"25.10","strike":"48.7","wicket4i":0,"wicket5i":27,"wicket10m":3,"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":"7035257b6dc9d7d7611eb3d861d555d9","modified":"2025-07-29 20:42:57","datetime":"2025-07-29 20:42:57","api_version":"3.0"}', Modified = GetDate() WHERE Id = 771 AND DataTypeId = 6 END
Player profile of Azhar Mahmood, Pakistan
CricDirect Cricket News, Results and Stats
 

Azhar Mahmood

NationalityPakistan
RoleBatter
Born28 Feb 1975 (50)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Fast Medium

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 21 34 4 900 136 30.00 1772 50.79 3 1
ODI 143 110 26 1521 67 18.10 1988 76.50 - 3
T20I 230 207 47 4091 106 25.56 3023 135.32 2 18
List A 319 256 49 4555 101 22.00 - - 2 19
1st Class 176 274 32 7703 204 31.83 - - 9 42

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 21 35 502.3 1402 39 4/50 35.94 2.79 77.3 2 -
ODI 143 139 1040.2 4813 123 6/18 39.13 4.62 50.7 2 3
T20 230 229 804.1 6143 258 5/24 23.81 7.63 18.7 3 1
List A 319 - 2325.2 10919 348 6/18 31.37 4.69 40.0 13 5
1st Class 176 - 4966.2 15337 611 8/61 25.10 3.08 48.7 - 27
× Close