Bind a SQL table to a dropdownlist at design time? Surely it can be done?

GG · May 24, 2005

I have a typical ASP page with a dropdownlist web form control. I want
this to auto-populate from a column in a sql table.

I've tried dragging a sql connection data control onto the form, played
with data binding, everything! I'm sure this is easy, can anyone point
out the steps I need to take?

Thanks ...

Brock Allen · May 24, 2005

Here's an example:

<script runat="server">
protected void Page_Load(object sender, EventArgs e)
{
using (SqlConnection cn = new SqlConnection("server=localhost;database=pubs;trusted_connection=yes;"))
{
using (SqlCommand cmd = cn.CreateCommand())
{
cmd.CommandText = "select * from authors";
cn.Open();
using (SqlDataReader rdr = cmd.ExecuteReader())
{
_ddl1.DataSource = rdr;
_ddl1.DataTextField = "au_fname";
_ddl1.DataBind();
}
}
}
}
</script>
<body>
<form id="form1" runat="server" >
<asp

ropDownList runat="server" ID="_ddl1"></asp

ropDownList>
</form>
</body>
</html>

Guest · May 25, 2005

Hi!

Dude, hope that u can get the values in a DataSet from the DataBase.Now
things are pretty starightfwd from here
just put in this code

if(objDs.Tables.Count != 0) //objDs is the dataset which has the table
Employee
{
if(objDs.Tables[0].Rows.Count != 0)
{
ddlEmployeeId.DataSource = objDs;
ddlEmployeeId.DataValueField = "EmployeeID";
ddlEmployeeId.DataTextField = "EmpName";
ddlEmployeeId.DataBind();
}
}

mail2saion · May 14, 2009

Hello readers today i found a helpful post on how you can optimize your code to bind with Dropdown List:

shawpnendu.blogspot.com/2009/05/how-to-bind-or-populate-data-into.html

HOPE IT WILL HELP READERS.

How To? Bind MS Access to DropDownList?	3	Sep 30, 2005
Failed to generate a user instance of SQL Server. Only an integratedconnection can generate a user i	2	Mar 27, 2010
Solution to: dropdownlist has a SelectedValue which is invalidbecause it does not exist in the list	1	Mar 23, 2008
SQL SERVER Table to XML	0	Oct 22, 2006
Is it Possible to Bind an Asp Xml Control to Repeater	0	Jan 24, 2007
Poor Design Time Support for DataBinding in Custom Controls	1	Feb 17, 2007
Inserting ASP.NET form data to SQL table	0	May 29, 2008
dropdownlist selection to a string	0	Jan 17, 2004

Bind a SQL table to a dropdownlist at design time? Surely it can be done?

GG

Brock Allen

Guest

mail2saion

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads