Friday, October 10, 2014

How to run the tables & Store procedure from one database to another database using SQL Server

How to run the tables & Store procedure from one database to another database using SQL Server For Execution the Table EXEC sys.sp_dropserver @server = 'VCNSQL90.sample.com', @droplogins = 'droplogins'; EXEC master.dbo.sp_addlinkedserver @server = N'VCNSQL90.webhost4life.com', @srvproduct=N'VCNSQL90. sample.com', @provider=N'SQLNCLI', @datasrc=N'VCNSQL90. sample.com'  /* For security reasons the linked server remote logins password is changed with ######## */ EXEC...
Read More »

Wednesday, October 8, 2014

Export tables, div, Grids and any to Excel and PDF in asp.net c#

Export tables, div, Grids and any to Excel and PDF in asp.net c# àWhile exporting  these designs with out images it will working fine à If it having images means you need to give the absolute path for the image URL then only it will work Check this blog http://lokeshasp.blogspot.com/2014/10/how-to-save-image-to-folder-from-data.html  Excel Export protected void imgexcel_Click(object sender, ImageClickEventArgs e)         {             Response.Clear();             Response.AddHeader("content-disposition", "attachment;filename=Suppliers.xls");             Response.Charset...
Read More »

How to save the Image to folder from data base in asp.net

How to save the Image to folder from data base in asp.net 1)  By using this method getting the image bytes and save to the folder public void SaveImageToFolder()         {             try             {                 DataTable dt = new DataTable();                 byte[]...
Read More »