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:538af871-5b57-4ca5-9701-b8e7421d3753 Error Number:207,State:1,Class:16If not Exists (Select ApiId From api_Data WHERE Id = 53527 AND DataTypeId = 6) BEGIN INSERT INTO api_Data (Id, DataTypeId, Json, Modified, StatusId, ErrorLog) VALUES (53527,6,'{"status":"ok","response":{"player":{"pid":53527,"title":"Ashok Menaria","short_name":"Ashok Menaria","first_name":"Ashok Menaria","last_name":"","middle_name":"","birthdate":"1990-10-29","birthplace":"","country":"in","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":"","instagram_profile":"https:\/\/www.instagram.com\/ashok_menaria\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":72,"innings":63,"notout":5,"runs":1085,"balls":938,"highest":77,"run100":0,"run50":4,"run4":85,"run6":43,"average":"18.70","strike":"115.67","catches":22,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":116,"innings":108,"notout":14,"runs":2783,"balls":3479,"highest":113,"run100":2,"run50":20,"run4":238,"run6":70,"average":"29.60","strike":"79.99","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":153,"notout":11,"runs":5219,"balls":9321,"highest":230,"run100":11,"run50":24,"run4":678,"run6":69,"average":"36.75","strike":"55.99","catches":49,"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":{"t20":{"match_id":0,"inning_id":0,"matches":72,"innings":34,"balls":451,"overs":75.1,"runs":493,"wickets":17,"bestinning":"3\/19","bestmatch":"3\/19","econ":"6.55","average":"29.00","strike":"26.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":116,"innings":56,"balls":1735,"overs":289.1,"runs":1342,"wickets":37,"bestinning":"5\/38","bestmatch":"5\/38","econ":"4.64","average":"36.27","strike":"46.8","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":74,"balls":2561,"overs":426.5,"runs":1433,"wickets":20,"bestinning":"3\/7","bestmatch":"3\/32","econ":"3.35","average":"71.65","strike":"128.0","wicket4i":0,"wicket5i":0,"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":"1dcb0ceae61fa52da31e91da85a1ed6e","modified":"2025-07-08 17:07:28","datetime":"2025-07-08 17:07:28","api_version":"3.0"}', GetDate() , 0,'') END ELSE BEGIN Update api_Data Set Json = '{"status":"ok","response":{"player":{"pid":53527,"title":"Ashok Menaria","short_name":"Ashok Menaria","first_name":"Ashok Menaria","last_name":"","middle_name":"","birthdate":"1990-10-29","birthplace":"","country":"in","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":"","instagram_profile":"https:\/\/www.instagram.com\/ashok_menaria\/","debut_data":"","bowling_type":"Spin","thumb_url":"","nationality":"India"},"batting":{"t20":{"match_id":0,"inning_id":0,"matches":72,"innings":63,"notout":5,"runs":1085,"balls":938,"highest":77,"run100":0,"run50":4,"run4":85,"run6":43,"average":"18.70","strike":"115.67","catches":22,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"lista":{"match_id":0,"inning_id":0,"matches":116,"innings":108,"notout":14,"runs":2783,"balls":3479,"highest":113,"run100":2,"run50":20,"run4":238,"run6":70,"average":"29.60","strike":"79.99","catches":41,"stumpings":0,"fastest50balls":0,"fastest100balls":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":153,"notout":11,"runs":5219,"balls":9321,"highest":230,"run100":11,"run50":24,"run4":678,"run6":69,"average":"36.75","strike":"55.99","catches":49,"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":{"t20":{"match_id":0,"inning_id":0,"matches":72,"innings":34,"balls":451,"overs":75.1,"runs":493,"wickets":17,"bestinning":"3\/19","bestmatch":"3\/19","econ":"6.55","average":"29.00","strike":"26.5","wicket4i":0,"wicket5i":0,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"lista":{"match_id":0,"inning_id":0,"matches":116,"innings":56,"balls":1735,"overs":289.1,"runs":1342,"wickets":37,"bestinning":"5\/38","bestmatch":"5\/38","econ":"4.64","average":"36.27","strike":"46.8","wicket4i":0,"wicket5i":1,"wicket10m":0,"hattrick":0,"expensive_over_runs":0},"firstclass":{"match_id":0,"inning_id":0,"matches":96,"innings":74,"balls":2561,"overs":426.5,"runs":1433,"wickets":20,"bestinning":"3\/7","bestmatch":"3\/32","econ":"3.35","average":"71.65","strike":"128.0","wicket4i":0,"wicket5i":0,"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":"1dcb0ceae61fa52da31e91da85a1ed6e","modified":"2025-07-08 17:07:28","datetime":"2025-07-08 17:07:28","api_version":"3.0"}', Modified = GetDate() WHERE Id = 53527 AND DataTypeId = 6 END
Player profile of Ashok Menaria, India
<>
CricDirect Cricket News, Results and Stats
 

Ashok Menaria

NationalityIndia
RoleAll Rounder
Born29 Oct 1990 (34)
Batting StyleLeft hand Bat
Bowling StyleLeft Arm Orthodox

Batting

Format MAT INNS NO RUNS HS AVG BF SR 100s 50s
T20I 72 63 5 1085 77 18.70 938 115.67 - 4
List A 116 108 14 2783 113 29.60 3479 79.99 2 20
1st Class 96 153 11 5219 230 36.75 9321 55.99 11 24

Bowling

Format MAT INNS OVR RUNS WK BBI AVG ECN SR 4W 5W
T20 72 34 75.1 493 17 3/19 29.00 6.55 26.5 - -
List A 116 56 289.1 1342 37 5/38 36.27 4.64 46.8 - 1
1st Class 96 74 426.5 1433 20 3/7 71.65 3.35 128.0 - -
× Close