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:288f5d80-5062-477b-a718-0c35c251dc65 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1692 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1692,6,'{"status":"ok","response":{"player":{"pid":1692,"title":"Muhammad Usman","short_name":"M Usman","first_name":"Muhammad Usman","last_name":"","middle_name":"","birthdate":"1985-10-13","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"United Arab Emirates"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":38,"innings":37,"notout":5,"runs":1008,"balls":1312,"highest":102,"run100":1,"run50":4,"run4":89,"run6":22,"average":"31.50","strike":"76.82","catches":11,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":47,"innings":43,"notout":6,"runs":891,"balls":778,"highest":89,"run100":0,"run50":3,"run4":73,"run6":27,"average":"24.08","strike":"114.52","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":48,"innings":44,"notout":7,"runs":899,"balls":783,"highest":89,"run100":0,"run50":3,"run4":74,"run6":27,"average":"24.29","strike":"114.81","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":58,"innings":56,"notout":12,"runs":1517,"balls":1960,"highest":102,"run100":1,"run50":9,"run4":133,"run6":29,"average":"34.47","strike":"77.39","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":5,"innings":8,"notout":0,"runs":217,"balls":379,"highest":103,"run100":1,"run50":0,"run4":25,"run6":3,"average":"27.12","strike":"57.25","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"35","innings":"32","notout":"11","runs":"502","balls":"290","highest":"55","run100":"0","run50":"1","run4":"36","run6":"29","average":"23.90","strike":"173.10","catches":"8","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":38,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":47,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":48,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":58,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":5,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"35","innings":"5","balls":"39","overs":"6.3","runs":"65","wickets":"4","bestinning":"0\/4","bestmatch":"","econ":"10.00","average":"16.25","strike":"9.75","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"27c873adbfec5c8060d69e3e4b445b7e","modified":"2025-06-20 18:35:23","datetime":"2025-06-20 18:35:23","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1692,"title":"Muhammad Usman","short_name":"M Usman","first_name":"Muhammad Usman","last_name":"","middle_name":"","birthdate":"1985-10-13","birthplace":"","country":"ae","primary_team":[],"logo_url":"","playing_role":"bat","batting_style":"Left hand Bat","bowling_style":"","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"United Arab Emirates"},"batting":{"odi":{"match_id":0,"inning_id":0,"matches":38,"innings":37,"notout":5,"runs":1008,"balls":1312,"highest":102,"run100":1,"run50":4,"run4":89,"run6":22,"average":"31.50","strike":"76.82","catches":11,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":47,"innings":43,"notout":6,"runs":891,"balls":778,"highest":89,"run100":0,"run50":3,"run4":73,"run6":27,"average":"24.08","strike":"114.52","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":48,"innings":44,"notout":7,"runs":899,"balls":783,"highest":89,"run100":0,"run50":3,"run4":74,"run6":27,"average":"24.29","strike":"114.81","catches":12,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":58,"innings":56,"notout":12,"runs":1517,"balls":1960,"highest":102,"run100":1,"run50":9,"run4":133,"run6":29,"average":"34.47","strike":"77.39","catches":18,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":5,"innings":8,"notout":0,"runs":217,"balls":379,"highest":103,"run100":1,"run50":0,"run4":25,"run6":3,"average":"27.12","strike":"57.25","catches":0,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"35","innings":"32","notout":"11","runs":"502","balls":"290","highest":"55","run100":"0","run50":"1","run4":"36","run6":"29","average":"23.90","strike":"173.10","catches":"8","stumpings":"0"}},"bowling":{"odi":{"match_id":0,"inning_id":0,"matches":38,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":47,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":48,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":58,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":5,"innings":0,"balls":0,"overs":0,"runs":0,"wickets":0,"bestinning":"","bestmatch":"","econ":"","average":"","strike":"","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"35","innings":"5","balls":"39","overs":"6.3","runs":"65","wickets":"4","bestinning":"0\/4","bestmatch":"","econ":"10.00","average":"16.25","strike":"9.75","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"27c873adbfec5c8060d69e3e4b445b7e","modified":"2025-06-20 18:35:23","datetime":"2025-06-20 18:35:23","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1692 AND DataTypeId = 6 END
Player profile of Muhammad Usman, United Arab Emirates
<>
CricDirect Cricket News, Results and Stats
 

Muhammad Usman

NationalityUnited Arab Emirates
RoleBatter
Born13 Oct 1985 (39)
Batting StyleLeft hand Bat

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
ODI 38 37 5 1008 102 31.50 1312 76.82 1 4
T20I 47 43 6 891 89 24.08 778 114.52 - 3
T20I 48 44 7 899 89 24.29 783 114.81 - 3
List A 58 56 12 1517 102 34.47 1960 77.39 1 9
1st Class 5 8 - 217 103 27.12 379 57.25 1 -

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
ODI 38 - - - - - - - - - -
T20i 47 - - - - - - - - - -
T20 48 - - - - - - - - - -
List A 58 - - - - - - - - - -
1st Class 5 - - - - - - - - - -
× Close