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:50865a2e-cba9-4517-84b2-34d203dc95ca Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 346 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (346,6,'{"status":"ok","response":{"player":{"pid":346,"title":"Mahmudullah","short_name":"M Mahmudullah","first_name":"Mahmudullah","last_name":"","middle_name":"","birthdate":"1986-02-04","birthplace":"Mymensingh","country":"bd","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Bangladesh"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":50,"innings":94,"notout":7,"runs":2914,"balls":5456,"highest":150,"run100":5,"run50":16,"run4":338,"run6":24,"average":"33.49","strike":"53.40","catches":38,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":239,"innings":209,"notout":53,"runs":5689,"balls":7327,"highest":128,"run100":4,"run50":32,"run4":425,"run6":107,"average":"36.46","strike":"77.64","catches":82,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":141,"innings":130,"notout":26,"runs":2444,"balls":2082,"highest":64,"run100":0,"run50":8,"run4":184,"run6":77,"average":"23.50","strike":"117.38","catches":51,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":346,"innings":311,"notout":64,"runs":6230,"balls":5174,"highest":73,"run100":0,"run50":25,"run4":472,"run6":214,"average":"25.22","strike":"120.40","catches":142,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":373,"innings":336,"notout":67,"runs":9904,"balls":0,"highest":130,"run100":8,"run50":61,"run4":0,"run6":0,"average":"36.81","strike":"","catches":140,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":114,"innings":204,"notout":20,"runs":6557,"balls":0,"highest":152,"run100":14,"run50":32,"run4":0,"run6":0,"average":"35.63","strike":"","catches":98,"stumpings":1,"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":50,"innings":66,"balls":3423,"overs":570.3,"runs":1958,"wickets":43,"bestinning":"5\/51","bestmatch":"8\/110","econ":"3.43","average":"45.53","strike":"79.6","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":239,"innings":153,"balls":4380,"overs":730,"runs":3809,"wickets":82,"bestinning":"3\/4","bestmatch":"3\/4","econ":"5.21","average":"46.45","strike":"53.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":141,"innings":80,"balls":950,"overs":158.2,"runs":1135,"wickets":41,"bestinning":"3\/10","bestmatch":"3\/10","econ":"7.16","average":"27.68","strike":"23.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":346,"innings":210,"balls":2897,"overs":482.5,"runs":3414,"wickets":135,"bestinning":"3\/6","bestmatch":"3\/6","econ":"7.07","average":"25.28","strike":"21.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":373,"innings":0,"balls":8381,"overs":1396.5,"runs":6875,"wickets":178,"bestinning":"5\/66","bestmatch":"5\/66","econ":"4.92","average":"38.62","strike":"47.0","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":114,"innings":0,"balls":9111,"overs":1518.3,"runs":5026,"wickets":143,"bestinning":"7\/94","bestmatch":"","econ":"3.30","average":"35.14","strike":"63.7","wicket4i":4,"wicket5i":3,"wicket10m":1,"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":"7e951d59db32d475ca81956964cb442c","modified":"2025-06-12 03:22:43","datetime":"2025-06-12 03:22:43","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":346,"title":"Mahmudullah","short_name":"M Mahmudullah","first_name":"Mahmudullah","last_name":"","middle_name":"","birthdate":"1986-02-04","birthplace":"Mymensingh","country":"bd","primary_team":[],"logo_url":"","playing_role":"all","batting_style":"Right Hand Bat","bowling_style":"Right Arm Off Break","fielding_position":"","recent_match":0,"recent_appearance":0,"fantasy_player_rating":7.5,"facebook_profile":"","twitter_profile":"","instagram_profile":"","debut_data":"","thumb_url":"","nationality":"Bangladesh"},"batting":{"test":{"match_id":0,"inning_id":0,"matches":50,"innings":94,"notout":7,"runs":2914,"balls":5456,"highest":150,"run100":5,"run50":16,"run4":338,"run6":24,"average":"33.49","strike":"53.40","catches":38,"stumpings":1,"fastest50balls":0,"fastest100balls":0},"odi":{"match_id":0,"inning_id":0,"matches":239,"innings":209,"notout":53,"runs":5689,"balls":7327,"highest":128,"run100":4,"run50":32,"run4":425,"run6":107,"average":"36.46","strike":"77.64","catches":82,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20i":{"match_id":0,"inning_id":0,"matches":141,"innings":130,"notout":26,"runs":2444,"balls":2082,"highest":64,"run100":0,"run50":8,"run4":184,"run6":77,"average":"23.50","strike":"117.38","catches":51,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"t20":{"match_id":0,"inning_id":0,"matches":346,"innings":311,"notout":64,"runs":6230,"balls":5174,"highest":73,"run100":0,"run50":25,"run4":472,"run6":214,"average":"25.22","strike":"120.40","catches":142,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":373,"innings":336,"notout":67,"runs":9904,"balls":0,"highest":130,"run100":8,"run50":61,"run4":0,"run6":0,"average":"36.81","strike":"","catches":140,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":114,"innings":204,"notout":20,"runs":6557,"balls":0,"highest":152,"run100":14,"run50":32,"run4":0,"run6":0,"average":"35.63","strike":"","catches":98,"stumpings":1,"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":50,"innings":66,"balls":3423,"overs":570.3,"runs":1958,"wickets":43,"bestinning":"5\/51","bestmatch":"8\/110","econ":"3.43","average":"45.53","strike":"79.6","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"odi":{"match_id":0,"inning_id":0,"matches":239,"innings":153,"balls":4380,"overs":730,"runs":3809,"wickets":82,"bestinning":"3\/4","bestmatch":"3\/4","econ":"5.21","average":"46.45","strike":"53.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20i":{"match_id":0,"inning_id":0,"matches":141,"innings":80,"balls":950,"overs":158.2,"runs":1135,"wickets":41,"bestinning":"3\/10","bestmatch":"3\/10","econ":"7.16","average":"27.68","strike":"23.1","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"t20":{"match_id":0,"inning_id":0,"matches":346,"innings":210,"balls":2897,"overs":482.5,"runs":3414,"wickets":135,"bestinning":"3\/6","bestmatch":"3\/6","econ":"7.07","average":"25.28","strike":"21.4","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":373,"innings":0,"balls":8381,"overs":1396.5,"runs":6875,"wickets":178,"bestinning":"5\/66","bestmatch":"5\/66","econ":"4.92","average":"38.62","strike":"47.0","wicket4i":1,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":114,"innings":0,"balls":9111,"overs":1518.3,"runs":5026,"wickets":143,"bestinning":"7\/94","bestmatch":"","econ":"3.30","average":"35.14","strike":"63.7","wicket4i":4,"wicket5i":3,"wicket10m":1,"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":"7e951d59db32d475ca81956964cb442c","modified":"2025-06-12 03:22:43","datetime":"2025-06-12 03:22:43","api_version":"3.0"}', Modified = GetDate() WHERE Id = 346 AND DataTypeId = 6 END
Player profile of Mahmudullah, Bangladesh
CricDirect Cricket News, Results and Stats
 

Mahmudullah

NationalityBangladesh
RoleAll Rounder
Born04 Feb 1986 (39)
Batting StyleRight Hand Bat
Bowling StyleRight Arm Off Break

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
Test 50 94 7 2914 150 33.49 5456 53.40 5 16
ODI 239 209 53 5689 128 36.46 7327 77.64 4 32
T20I 141 130 26 2444 64 23.50 2082 117.38 - 8
T20I 346 311 64 6230 73 25.22 5174 120.40 - 25
List A 373 336 67 9904 130 36.81 - - 8 61
1st Class 114 204 20 6557 152 35.63 - - 14 32

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
Test 50 66 570.3 1958 43 5/51 45.53 3.43 79.6 - 1
ODI 239 153 730 3809 82 3/4 46.45 5.21 53.4 - -
T20i 141 80 158.2 1135 41 3/10 27.68 7.16 23.1 - -
T20 346 210 482.5 3414 135 3/6 25.28 7.07 21.4 - -
List A 373 - 1396.5 6875 178 5/66 38.62 4.92 47.0 1 1
1st Class 114 - 1518.3 5026 143 7/94 35.14 3.30 63.7 4 3
× Close