How To Do this

I created some DropDownList's Dynamically based on the records in the Products table of Northwind Database Ie
Dim StrConn As String = ConfigurationManager.ConnectionStrings("....").ConnectionString
Dim MyConn As New SqlConnection(StrConn)
Dim MyAdapter As SqlDataAdapter
Dim MyDataSet As DataSet
Dim MyComm As SqlCommand
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim StrSelect As String = "Select ProductId,ProductName From Products"
MyAdapter = New SqlDataAdapter(StrSelect, MyConn)
MyDataSet = New DataSet
MyAdapter.Fill(MyDataSet, "Products")

For Each Dr As DataRow In MyDataSet.Tables("Products").Rows
Dim Drp As New DropDownList
Drp.ID = "Drp" & Dr.Item(0)
Drp.DataSource = MyDataSet.Tables("Products")
Drp.DataTextField = "ProductName"
Drp.DataValueField = "ProductId"
Drp.DataBind()

PlcConterol.Controls.Add(Drp)
Next
End Sub
I tried doing the samething using the DataReader but it creates only one DropDown Ie

While MyReader.Read
Dim Drp as New DropDownList

Drp.Id="Drp"

Drp.DataSource=MyReader

Drp.DataTextField="ProductName"

Drp.DataValueField="ProductId"

Drp.DataBind

End While
Thanks

Hi websyd,

I'm not quite sure why you need to put the databinding process in a loop.

Are you trying to put every row into the dropdownlist item collection? If so, please forget about the loop. When you have set the DataSource, DataTextField and DataValueField, the binding process will put everything into the collection automatically.

So please change to

Drp.DataSource = MyDataSet.Tables("Products")
Drp.DataTextField = "ProductName"
Drp.DataValueField = "ProductId"
Drp.DataBind()

And for DataReader, you can use

Dim Drp as New DropDownList
Drp.Id="Drp"
Drp.DataSource=MyReader
Drp.DataTextField="ProductName"
Drp.DataValueField="ProductId"
Drp.DataBind

HTH.

|||

Hi thanks 4 d response. I looped because i needed to create the DropDowns based on the number of rows in the table. So if i remove the code from the loop i will get only one DropDownList as your code suggests.

With the DataReader, again this will create only one DropDownList but i need to create to more than one.

Thanks

|||

Hi Websyd,

The DataReader only created one DropDownList because the DataReader can only be used once in data binding.

This is because when bound, the control will have the DataReader read to the end to populate the items. As you know, the DataReader is forward-only and cannot be used again for reading. That's why only one control is filled with data.