[2008] Filling a combobox with data from Access Database using Dataset.

[vblover2008]

Hi
I have a problem filling the second column data from table REG, by using form1.Dataset.table. during the load of form2.

form1: contains a datagridview of the table REG.

STUDENTREGDataSet: is my database set, I tested the connection it is successful and I can see the data of table REG on form1 and I can browse them by using the navigator so I think the connection is fine.

I don't have any errors on this code but the combobox is still empty after loading the form.
I sould fill the combo box with non-repeated data. so that's why I put this line:

 If (Combobox1.Items.IndexOf(S) = -1) Then
                    Combobox1.Items.Add(S)
                End If

with or without that code the data is not filling.


my code is like this:

Private Sub Form2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim S As String 'the field is as Text in the Access Database
        Dim I As String
        With Form1.STUDENTREGDataSet.REG
            For I = 0 To .Rows.Count - 1
                S = .Rows(I).Item(1)
                If (Combobox1.Items.IndexOf(S) = -1) Then
                    Combobox1.Items.Add(S)
                End If
            Next
        End With
    End Sub

and in form1 I have this code it's automatically written:

 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'TODO: This line of code loads data into the 'STUDENTREGDataSet.REG' table. You can move, or remove it, as needed.
        Me.REGTableAdapter.Fill(Me.STUDENTREGDataSet.REG)

    End Sub

can you help me please?? I'm new in VB.NET 2008.

thanks