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:398c0ebd-79f1-474e-8fab-fee818774662 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 1760 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (1760,6,'{"status":"ok","response":{"player":{"pid":1760,"title":"Mohammad Nawaz","short_name":"M Nawaz","first_name":"Mohammad Nawaz","last_name":"","middle_name":"","birthdate":"1994-03-21","birthplace":" Rawalpindi, Punjab","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rnawaz31888","instagram_profile":"https:\/\/www.instagram.com\/m_nawazkhan\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":6,"innings":10,"notout":1,"runs":144,"balls":346,"highest":45,"run100":0,"run50":0,"run4":15,"run6":0,"average":"16.00","strike":"41.61","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":37,"innings":28,"notout":6,"runs":406,"balls":458,"highest":53,"run100":0,"run50":1,"run4":27,"run6":11,"average":"18.45","strike":"88.64","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":60,"innings":38,"notout":12,"runs":477,"balls":355,"highest":45,"run100":0,"run50":0,"run4":38,"run6":24,"average":"18.34","strike":"134.36","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":281,"innings":211,"notout":59,"runs":3347,"balls":2663,"highest":72,"run100":0,"run50":9,"run4":254,"run6":149,"average":"22.01","strike":"125.68","catches":124,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":110,"innings":92,"notout":13,"runs":2254,"balls":2518,"highest":187,"run100":1,"run50":14,"run4":200,"run6":37,"average":"28.53","strike":"89.51","catches":31,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":61,"innings":101,"notout":6,"runs":3311,"balls":5859,"highest":170,"run100":6,"run50":16,"run4":441,"run6":12,"average":"34.85","strike":"56.51","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"6","innings":"1","notout":"0","runs":"13","balls":"10","highest":"13","run100":"0","run50":"0","run4":"1","run6":"1","average":"13.00","strike":"130.00","catches":"3","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":6,"innings":12,"balls":959,"overs":159.5,"runs":496,"wickets":16,"bestinning":"5\/88","bestmatch":"6\/106","econ":"3.10","average":"31.00","strike":"59.9","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":37,"innings":37,"balls":1773,"overs":295.3,"runs":1507,"wickets":42,"bestinning":"4\/19","bestmatch":"4\/19","econ":"5.09","average":"35.88","strike":"42.2","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":60,"innings":57,"balls":1102,"overs":183.4,"runs":1361,"wickets":50,"bestinning":"3\/5","bestmatch":"3\/5","econ":"7.41","average":"27.22","strike":"22.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":281,"innings":264,"balls":4892,"overs":815.2,"runs":6225,"wickets":217,"bestinning":"5\/24","bestmatch":"5\/24","econ":"7.63","average":"28.68","strike":"22.5","wicket4i":2,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":110,"innings":106,"balls":5094,"overs":849,"runs":4327,"wickets":124,"bestinning":"4\/19","bestmatch":"4\/19","econ":"5.09","average":"34.89","strike":"41.0","wicket4i":5,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":61,"innings":92,"balls":6355,"overs":1059.1,"runs":3329,"wickets":111,"bestinning":"7\/31","bestmatch":"11\/93","econ":"3.14","average":"29.99","strike":"57.2","wicket4i":4,"wicket5i":4,"wicket10m":1,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"6","innings":"1","balls":"12","overs":"2","runs":"31","wickets":"0","bestinning":"0\/31","bestmatch":"","econ":"15.50","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"a3bfd97efb64bb89547d54b28c010867","modified":"2025-07-12 03:59:22","datetime":"2025-07-12 03:59:22","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":1760,"title":"Mohammad Nawaz","short_name":"M Nawaz","first_name":"Mohammad Nawaz","last_name":"","middle_name":"","birthdate":"1994-03-21","birthplace":" Rawalpindi, Punjab","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":7.5,"facebook_profile":"","twitter_profile":"https:\/\/twitter.com\/Rnawaz31888","instagram_profile":"https:\/\/www.instagram.com\/m_nawazkhan\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"Pakistan"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":6,"innings":10,"notout":1,"runs":144,"balls":346,"highest":45,"run100":0,"run50":0,"run4":15,"run6":0,"average":"16.00","strike":"41.61","catches":4,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":37,"innings":28,"notout":6,"runs":406,"balls":458,"highest":53,"run100":0,"run50":1,"run4":27,"run6":11,"average":"18.45","strike":"88.64","catches":14,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":60,"innings":38,"notout":12,"runs":477,"balls":355,"highest":45,"run100":0,"run50":0,"run4":38,"run6":24,"average":"18.34","strike":"134.36","catches":26,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":281,"innings":211,"notout":59,"runs":3347,"balls":2663,"highest":72,"run100":0,"run50":9,"run4":254,"run6":149,"average":"22.01","strike":"125.68","catches":124,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":110,"innings":92,"notout":13,"runs":2254,"balls":2518,"highest":187,"run100":1,"run50":14,"run4":200,"run6":37,"average":"28.53","strike":"89.51","catches":31,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":61,"innings":101,"notout":6,"runs":3311,"balls":5859,"highest":170,"run100":6,"run50":16,"run4":441,"run6":12,"average":"34.85","strike":"56.51","catches":28,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t10":{"match_id":"0","inning_id":"0","matches":"6","innings":"1","notout":"0","runs":"13","balls":"10","highest":"13","run100":"0","run50":"0","run4":"1","run6":"1","average":"13.00","strike":"130.00","catches":"3","stumpings":"0"}},"bowling":{"test":{"match_id":0,"inning_id":0,"matches":6,"innings":12,"balls":959,"overs":159.5,"runs":496,"wickets":16,"bestinning":"5\/88","bestmatch":"6\/106","econ":"3.10","average":"31.00","strike":"59.9","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":37,"innings":37,"balls":1773,"overs":295.3,"runs":1507,"wickets":42,"bestinning":"4\/19","bestmatch":"4\/19","econ":"5.09","average":"35.88","strike":"42.2","wicket4i":3,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":60,"innings":57,"balls":1102,"overs":183.4,"runs":1361,"wickets":50,"bestinning":"3\/5","bestmatch":"3\/5","econ":"7.41","average":"27.22","strike":"22.0","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":281,"innings":264,"balls":4892,"overs":815.2,"runs":6225,"wickets":217,"bestinning":"5\/24","bestmatch":"5\/24","econ":"7.63","average":"28.68","strike":"22.5","wicket4i":2,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":110,"innings":106,"balls":5094,"overs":849,"runs":4327,"wickets":124,"bestinning":"4\/19","bestmatch":"4\/19","econ":"5.09","average":"34.89","strike":"41.0","wicket4i":5,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":61,"innings":92,"balls":6355,"overs":1059.1,"runs":3329,"wickets":111,"bestinning":"7\/31","bestmatch":"11\/93","econ":"3.14","average":"29.99","strike":"57.2","wicket4i":4,"wicket5i":4,"wicket10m":1,"hattrick":0,"expensive_over_runs":0},"t10":{"match_id":"0","inning_id":"0","matches":"6","innings":"1","balls":"12","overs":"2","runs":"31","wickets":"0","bestinning":"0\/31","bestmatch":"","econ":"15.50","average":"","strike":"","wicket4i":"0","wicket5i":"0","wicket10m":"0"}}},"etag":"a3bfd97efb64bb89547d54b28c010867","modified":"2025-07-12 03:59:22","datetime":"2025-07-12 03:59:22","api_version":"3.0"}', Modified = GetDate() WHERE Id = 1760 AND DataTypeId = 6 END
Player profile of Mohammad Nawaz, Pakistan
<>
CricDirect Cricket News, Results and Stats
 

Mohammad Nawaz

NationalityPakistan
RoleAll Rounder
Born21 Mar 1994 (31)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 6 10 1 144 45 16.00 346 41.61 - -
ODI 37 28 6 406 53 18.45 458 88.64 - 1
T20I 60 38 12 477 45 18.34 355 134.36 - -
T20I 281 211 59 3347 72 22.01 2663 125.68 - 9
List A 110 92 13 2254 187 28.53 2518 89.51 1 14
1st Class 61 101 6 3311 170 34.85 5859 56.51 6 16

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 6 12 159.5 496 16 5/88 31.00 3.10 59.9 - 1
ODI 37 37 295.3 1507 42 4/19 35.88 5.09 42.2 3 -
T20i 60 57 183.4 1361 50 3/5 27.22 7.41 22.0 - -
T20 281 264 815.2 6225 217 5/24 28.68 7.63 22.5 2 1
List A 110 106 849 4327 124 4/19 34.89 5.09 41.0 5 -
1st Class 61 92 1059.1 3329 111 7/31 29.99 3.14 57.2 4 4
× Close