如何获取数据集中的某字段的值

[jwhcl]

我做了一个登录界面,登录成功后要显示该用户的基本信息.
在显示基本信息的页面中我先查询该基本信息表,然后将查询到的结果填加到数据集中,再获取该数据集中的各个字段的值.将这些值放到标签控件中一个一个显示出来
但是不知道怎么获取,请高手指点.希望尽量能讲解的详细点,谢谢了!

[tjficcbw]

是什么数据库呀

   Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Dim cstring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\db.mdb"
        Dim con As New OleDb.OleDbConnection(cstring)

        Dim sql As String = "select * from bkstudent"
        Try
            con.Open()
            'MsgBox("连接成功!")
        Catch ex As Exception
            'MsgBox("不能连接!")
        End Try

        Dim sales As DataSet = New DataSet
        Dim cmd As New OleDb.OleDbCommand(sql, con)
        Dim myreader As OleDbDataReader = cmd.ExecuteReader
        While myreader.Read
            TextBox1.Text = TextBox1.Text & myreader(0) & "-" & myreader(1) & "-" & myreader(2) & "-" & myreader(3) & vbCrLf
        End While

        'cmd.ExecuteNonQuery()
        'cmd.CommandText() = sql
        con.Close()



    End Sub

[tautaulee]

DataTable.rows[行][列].toString();

[tjficcbw]

我上面的是MDB数据库
下面是SQL数据库

    Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click
        Dim cstring As String = "User ID=sa;pwd=a;Initial Catalog=zbb;Data Source=(local)"
        Dim con As New SqlClient.SqlConnection(cstring)

        Dim sql As String = "select * from manid"
        Try
            con.Open()
            'MsgBox("连接成功!")
        Catch ex As Exception
            'MsgBox("不能连接!")
        End Try

        Dim sales As DataSet = New DataSet
        Dim cmd As New SqlClient.SqlCommand(sql, con)
        Dim myreader As SqlClient.SqlDataReader = cmd.ExecuteReader
        While myreader.Read
            TextBox1.Text = TextBox1.Text & myreader(0) & vbCrLf
        End While

        'cmd.ExecuteNonQuery()
        'cmd.CommandText() = sql
        con.Close()

    End Sub

[jwhcl]

谢谢了,以后有问题还请多多指教!