我想获取表中字段也就是列的值,但获取的却是字段名
各位帮我看一下这段程序哪儿错误了啊,谢谢!

Sub mydatabind()
Dim conn As New SqlConnection("server=(local);database=xf;uid=sa;pwd=;")
Dim newid As String = Request.QueryString("nid")
Dim strsql As String = "select * from news where nid='" & newid & "'"
Dim cmd As New SqlCommand(strsql, conn)
Dim adp As New SqlDataAdapter(cmd)
Dim ds As New DataSet
adp.Fill(ds, "news")
TextBox1.Text = ds.Tables(0).Columns(0).ToString
TextBox2.Text = ds.Tables(0).Columns(1).ToString
TextBox3.Text = ds.Tables(0).Columns(2).ToString
TextBox4.Text = ds.Tables(0).Columns(3).ToString
End Sub

有没有知道的啊,谢谢各位了~~~

TextBox1.Text = ds.Tables(0).rows(0)(0).ToString
TextBox2.Text = ds.Tables(0).rows(0)(1).ToString
TextBox3.Text = ds.Tables(0).rows(0)(2).ToString
TextBox4.Text = ds.Tables(0).rows(0)(3).ToString
这是得到第一行的每列的值，想得到每行的值用个循环就行了