I have a table that is returning rows from a table query. It seems I have done it before but I cannot seem to get the right procedure to obtain the values. I will paste in the code below in which you will see my bad attempts at accomplishing what I need. I will appreciate an answer, an example or sample that will get me over this seemingly easy question.
Public Class Form1 Dim uid As String Dim pw As String Dim em As String, fn, ln, mi As String Dim par As String Dim Field, n, j As Integer Dim JJ As Integer Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load End Sub Private Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click Dim loginAdapter As New STRATEGYDataSetTableAdapters.LOGINTableAdapter Dim theDataSet As New STRATEGYDataSet Dim row As String, kk As Integer, indexx As Integer, item As Integer Dim dvSql As DataView = New DataView(theDataSet.LOGIN) Dim dvrow As New DataView JJ = loginAdapter.GetData.Rows.Count On Error GoTo register For kk = 1 To jj item = kk - 1 'Each dvsql In theDataSet.Tables("LOGIN").Rows JJ = loginAdapter.GetData.Rows.Count 'row = loginAdapter.GetData.Rows(theDataSet.LOGIN) 'uid=dvsql.item(0) 'em = dvsql.Item(1) 'pw = dvsql.Item(2) Next register: End Sub End Class