Recently I came across an issue in Sql Server 2005, while running CROSS APPLY. The error says that Incorrect syntax near '.'. I tried to figure out all syntax that I could apply but it did not resolve the issue. Actually we need to set sp_dbcmptlevel level to 90. There are good blog posts for this here and here , which can save your valuable time.
Recently I had a task to save file on client machine. We usually save file on server and in ASP.NET the more familiar task to save on client side was to export gridview results to excel file. This time the task was to save an image on client machine. Following is the code that I followed. <pre name="code" class="html"> byte[] fileBytes = File.ReadAllBytes("D:\\Projects\\TestClientDownload\\images\\banner_ad_1.jpg"); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "text/plain"; Response.AppendHeader("content-disposition", "attachment; filename=" + "banner_ad_1.jpg"); Response.AppendHeader("content-length", fileBytes.Length.ToString()); ...
Hello friends, We are in the age of web 2.0. With this, I am going to take next step in web. With this my own space, I will be writing on technical topics, financials which is of most interest to me and about all the new things which I will explore in my journey. Because I believe I am student of life and believe in sharing what I learn... So get ready for many more good things to come...