make use of dataset, bind to controls and scroll

[banks]

Hi i have created a dataset of users as shown below:-

    Public Sub createDataset()
        Dim ds As New DataSet("Users")

        Dim strConn, strSQL As String
        strConn = carDba.getCn

        strSQL = "SELECT UserId, LoginName, LoginPassword, userLevelId, fullName " & _
        "FROM tblUser"
        Dim da As New OleDbDataAdapter(strSQL, strConn)
        da.Fill(ds, "Users")

    End Sub

Pretty sure that will fill "Users" with all the records from tblUSer.

Now my question is, how can i make use of this on my form - i want to bind each selected item to either a textbox or combo on the form...

Secondaly i need to create buttons to scroll left and right through the recordset as a method of viewing each record...

Any help is much apreciated,

al

 

[zekeman]

Wouldn't you just want to use a datagridview ( data control ) ?