How can i empty a drop down list in VB.Net

[McGrawh]

From last few days i'm trying to empty the contents from a dropdown list, so that when a user click on the clear button, it should not display any data in VB.Net. I tried my level best for doing so, but couldn't succeed. So can any body tell me that how can i empty a drop down list in VB.Net? Does any body knows about it? Kindly provide me the correct solution for the above issue.

[Katty]

If you want you can try out the following code:-

Protected Sub DropDownList_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyControl1.DataBound, MyControl2.DataBound
DirectCast(sender, DropDownList).Items.Insert(0, String.Empty)
End Sub

[kelfro]

Try to make sure that your DropDownStyle property is been set to DropDown. Then you need to "Leave the Text" property blank and again you need to make sure that you don't change your SelectedIndex property to anything, but it should be set to -1.

[Praetor]

The following code will show you, how you can try to bind a DropDownList control along with data from a table on the DataBase.

string s = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;

private void bindtoddl()
{
SqlConnection con = new SqlConnection(s);
SqlCommand cmd = new SqlCommand("select FieldName from TableName", con);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "FieldName"; // FieldName of Table in DataBase
DropDownList1.DataValueField = "FieldName";
DropDownList1.DataBind();

}