which is the best idea to store record: either in binary file or sql database

Question

what is the best idea to store record in binary or in sql database .if i put all the records in a sql it becomes very bulky becoase every day i have to deal with 10000 table .and taking a sql hosting for in this much bulky data storing in sql is not affordable so i am about to move on binary file is it a good for me to creating binary file as a database and how

Answer 1

Hi, Thanks I removed httpUtility.UrlEncode from view.aspx page and it worked.

Answer 2

Hi..
Welcome to Csharpcorner
Normally this error occur when we are trying to access the resource which is not available. In your case check out view.aspx location means see is it present in any directory.If it is then try like

Hyperlink.NavigateUrl = "~/view.aspx?ReturnUrl=" +
HttpUtility.UrlEncode(Request.Url.AbsolutePath); 
As well your target url must be able to Decode.