add default value to databound dropdownlist

[magmo]

Hi


I have a drop down list that is databound this way..

            MyConnection.Open()
            MyCommand = New SqlCommand("dbo.p_ShowProducts", MyConnection)
            MyCommand.CommandType = CommandType.StoredProcedure
            MyDataReader = MyCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
            DropDownListProducts.DataSource = MyDataReader
            DropDownListProducts.DataBind()

But I would like to add a default value like this...

DropDownListProducts.Items.Insert(0, "All products....")

But I don't know how to, is this possible at all?


Regards

 

[link9]

DropDownListProducts.Items.Insert(0, new ListItem("All Products", "0"));

-paul

The answer to getting answered -- faq855-2992