Transfer data from sql server to Microsoft Excel

Nov 14 2006 4:46 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