DropDownList DataBind

[shahab]

I use this code for DropDownList DataBind:
void BindDDL()
{
try
{
string strCon = ConfigurationSettings.AppSettings["ConnStr"];
SqlConnection wg = new SqlConnection(strCon);

SqlDataAdapter dtAdap1 = new
SqlDataAdapter("select Username from tblUserAccounts",wg);


dtAdap1.Fill(dsDDL, "tblUserAccounts");

DropDownList1.DataBind();
}
catch (Exception DDLError)
{
Label8.Text=DDLError.Message.ToString();
}
}
But it does not shows the usernames!

 

[kahlua001]

Did you specify the datatextfield and datavaluefield

 

[shahab]

No ,What should I write there?
DataBindingataBinder.Eval(dsDDL, "Tables[tblUserAccounts].DefaultView.[0].username")
but it shows only the first username not all of them!!

 

[kahlua001]

DropDownList1.DataTextField = "Username";
DropDownList1.DataBind();