asp.net excel

Question

I started in dotnet with asp.net I wante export data from sqlserver to excel in this site i found

how do this with c# in winforms bat i like do it in webforms (in browser)It is possible help me please.
Thanks BCP

sarra amin · Answer

I am sorry ,but I m using google but I have not found how to import excel data to sqlserver in asp.net I found only en ado Thanks sorry

dilipv vishwakarma · Answer

hi there, First of all are you aware of Google OR not, atleast you need to search articles baesd on it. Just check out the given links as follows. http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q321686 http://davidhayden.com/blog/dave/archive/2006/05/31/2976.aspx http://www.c-sharpcorner.com/UploadFile/vandita/exceltoaccessinterop02242007093426AM/exceltoaccessinterop.aspx Hope this will help you. Thanks & Regards Dilipv Programmer SharePoint Consulting

sarra amin · Answer

thanks very much mr; sorry my english is bad !! so to import data to excel i must import it to datagrid or gridview and after to excel . im using your help and i import data from gridview to excel but now i have another problem how imprting data from excel to sqlserver using asp.net? thanks

dilipv vishwakarma · Answer

hi there, You can easily export data from sql server to excel sheet easily, there are several articles available you can do google. So, just checkout the given link as follows. http://www.codeproject.com/KB/aspnet/ExportClassLibrary.aspx http://www.c-sharpcorner.com/UploadFile/DipalChoksi/ExportASPNetDataGridToExcel11222005041447AM/ExportASPNetDataGridToExcel.aspx Hope this will help you. Thanks & Rgards Dilipv SharePoint Consulting