First off you need to add the Databind code to the Page_Load section of the
code, not the SelectedIndex Changed section.
Also, the biggest mistake people make when binding data to a dropdown is
that they rebind the data on every Page_Load. So be sure that in your
page_load section of the code you wrap the binding inside an if
(!Page.IsPostBack) block.
So it should look like this:
private void DropDownList1_SelectedIndexChanged(object sender,
System.EventArgs e)
{
// Do something with the changed value
}
private void Page_Load(object sender, System.EventArgs e)
{
if ( !Page.IsPostBack )
{
OleDbConnection conn = new
OleDbConnection("DataSource=ntdrp001.world;
integrated security =true;"+ "initial catalog = Request");
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT distinct(cuid) from
Request",
conn);
OleDbDataReader dreader = cmd.ExecuteReader();
DropDownList1.DataSource = dreader;
DropDownList1.DataValueField = "cuid";
DropDownList1.DataTextField = "cuid";
DropDownList1.SelectedIndex = 0;
DropDownList1.DataBind();
dreader.Close();
conn.Close();
}
}
"Brian Conway" <Br**********@qwest.com> wrote in message
news:ek*************@tk2msftngp13.phx.gbl...
I need some help on binding a datareader to a dropdown box. I have
included the code for the dropdown below. It builds with no errors, but returns no
results. Any help would be appreciated.
private void DropDownList1_SelectedIndexChanged(object sender,
System.EventArgs e)
{
OleDbConnection conn = new OleDbConnection("DataSource=ntdrp001.world;
integrated security =true;"+ "initial catalog = Request");
conn.Open();
OleDbCommand cmd = new OleDbCommand("SELECT distinct(cuid) from Request",
conn);
OleDbDataReader dreader = cmd.ExecuteReader();
DropDownList1.DataSource = dreader;
DropDownList1.DataValueField = "cuid";
DropDownList1.DataTextField = "cuid";
DropDownList1.SelectedIndex = 0;
DropDownList1.DataBind();
dreader.Close();
conn.Close();
}
