How to bind dropdown values in excel

Hi,

I am using excel dropdown, how to bind dropdown values in excel using SQL server with sing field,

Eg:Employee Name

Thank u in advance

Re: How to bind dropdown values in excel

kathir_cs
how to bind dropdown values in excel using SQL server with sing field,

Read Excel File in C# - http://www.gridview.net/read-excel-file-in-c/

And once you have data in datatable, then you can use it to bind it with dropdown...http://shahed-kazi.blogspot.in/2009/03/bind-datatable-to-dropdownlist.html

Thanks,

Re: How to bind dropdown values in excel

try try this..

Public Function ToDataSetbyOle(pathName As String, SheetName As String) As DataSet

	Dim strQuery As String = "SELECT * FROM [" & SheetName & "]"
	Dim conn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " & pathName & "; Extended Properties = ""Excel;HDR=YES;FMT=""")
	conn.Open()
	Dim adapter As New System.Data.OleDb.OleDbDataAdapter(strQuery, conn)
	Dim ds As New System.Data.DataSet("Excel File")
	adapter.Fill(ds)
	conn.Close()
	Return ds

End Function

DropDownlist1.DataSource = dataSet.Tables("Table1")
Dropdownlist1.DataTextField = "username"
Dropdownlist1.DataValueField = "userid"
DropDownlist1.DataBind()

http://forums.asp.net/t/1255191.aspx/1

Re: How to bind dropdown values in excel

pls see this url

http://spreadsheets.about.com/od/datamanagementinexcel/qt/20071113_drpdwn.htm

thank u

Re: How to bind dropdown values in excel

<div>

Hi kathir_cs,

As this issue is related to Excel, I suggest you post the isssue in this support forum below. There will be more experts familiar with the issue in this forum.

http://answers.microsoft.com/en-us/office/forum/excel

Regards

</div>