fill dropdown list thru dataset

[K R Lal]

Hi,

Any idea how to fill a dropdownlist thru dataset

I done like this
ddLst1.DataSource = myDataSet
ddLst1.DataMember = myDataSet.Tables(0).Columns(1).Caption

ddLst1.DataValueField = myDataSet.Tables(0).Columns(0).Caption

but it is not working ; my dropdown list showing blanck

please help me
--
Regards

K R Lal

[Andrew Robinson]

You are close. You need to call the DataBind() method on your control.

-Andrew
"K R Lal" <la**@yahoo.com> wrote in message
news:#Q**************@tk2msftngp13.phx.gbl...

Hi,

Any idea how to fill a dropdownlist thru dataset

I done like this
ddLst1.DataSource = myDataSet
ddLst1.DataMember = myDataSet.Tables(0).Columns(1).Caption

ddLst1.DataValueField = myDataSet.Tables(0).Columns(0).Caption

but it is not working ; my dropdown list showing blanck

please help me
--
Regards

K R Lal

[Andrew Robinson]

You are close. You need to call the DataBind() method on your control.

-Andrew
"K R Lal" <la**@yahoo.com> wrote in message
news:#Q**************@tk2msftngp13.phx.gbl...

Hi,

Any idea how to fill a dropdownlist thru dataset

I done like this
ddLst1.DataSource = myDataSet
ddLst1.DataMember = myDataSet.Tables(0).Columns(1).Caption

ddLst1.DataValueField = myDataSet.Tables(0).Columns(0).Caption

but it is not working ; my dropdown list showing blanck

please help me
--
Regards

K R Lal

[lea]

Private Sub DropDownList3_Load(ByVal sender As Object, ByVal e A
System.EventArgs) Handles DropDownList3.Load
DropDownList3.Items.Clear()
Dim ds As New ListItem()
Dim con As String = "Provider=Microsoft.Jet.OLEDB.4.0;Dat
Source=database.mdb" ( Change this to ur connection string)
Dim dc As New OleDbConnection(con)
Dim strSQL As String = "SELECT PurposeFunction FRO
[Contribution]" (change this to ur field name and table name)
Dim cmd As New OleDbCommand(strSQL, dc)
dc.Open()
Dim dr As OleDbDataReader = cmd.ExecuteReader()
While dr.Read()
ds.Text = dr(0)
If DropDownList3.Items.Contains(ds) = False Then
DropDownList3.Items.Add(dr(0))
End If
End While
dc.Close()
----------------------------------------------------------------------------------------------------------------------------------------------------
this code is not set thru dataset, but it's actually work and n
duplication! Hope this can help yo

--
le
-----------------------------------------------------------------------
lea's Profile: http://www.msusenet.com/member.php?userid=156
View this thread: http://www.msusenet.com/t-187044956

[lea]

Private Sub DropDownList3_Load(ByVal sender As Object, ByVal e A
System.EventArgs) Handles DropDownList3.Load
DropDownList3.Items.Clear()
Dim ds As New ListItem()
Dim con As String = "Provider=Microsoft.Jet.OLEDB.4.0;Dat
Source=database.mdb" ( Change this to ur connection string)
Dim dc As New OleDbConnection(con)
Dim strSQL As String = "SELECT PurposeFunction FRO
[Contribution]" (change this to ur field name and table name)
Dim cmd As New OleDbCommand(strSQL, dc)
dc.Open()
Dim dr As OleDbDataReader = cmd.ExecuteReader()
While dr.Read()
ds.Text = dr(0)
If DropDownList3.Items.Contains(ds) = False Then
DropDownList3.Items.Add(dr(0))
End If
End While
dc.Close()
----------------------------------------------------------------------------------------------------------------------------------------------------
this code is not set thru dataset, but it's actually work and n
duplication! Hope this can help yo

--
le
-----------------------------------------------------------------------
lea's Profile: http://www.msusenet.com/member.php?userid=156
View this thread: http://www.msusenet.com/t-187044956