Click to See Complete Forum and Search --> : Transfer data from SQL server to Microsoft Excel


cleopatra3000
11-14-2006, 03:21 AM
hi,
I'm using ASP.Net 2.0 and C#. when i select an item in the dropdown list and click on a button, it shouldtransfer the data of tat particular item from the SQL sever to Microsoft Excel. eg:i have empid as the dropdown list item, when i click the button, it should retrieve only the data of this particular empid and display it in Microsoft Excel.

thanx

Chitra Xavier
11-18-2006, 02:12 AM
Hi...

Just get the values in dataset and from dataset move the values to excel.I find this will be easy method to move datas from SQL server to Microsoft Excel