帮我改一段代码(取字段值),谢谢
没分了,不好意思,只有20分:)
两个按纽,我在第一个按纽中绑定数据,然后想在第二个按纽中取到某个字段中的值,请问要怎样改一下?谢谢
Imports System.Data
Partial Class Default2
Inherits System.Web.UI.Page
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
'绑定数据
Dim ds As New DataSet()
Dim ConStr As String = "Data Source=B;Initial Catalog=DotNet;Persist Security Info=True;User ID=sa"
Dim cn As SqlClient.SqlConnection = New SqlClient.SqlConnection(ConStr)
Dim sqlstr As String
sqlstr = " select * from T_user order by FIndex "
Dim da As SqlClient.SqlDataAdapter = New SqlClient.SqlDataAdapter(sqlstr, cn)
da.Fill(ds)
GridView1.DataSource = ds.Tables(0).DefaultView
GridView1.DataBind()
'(1)
MsgBox(ds.Tables(0).Rows(0).Item(2).ToString)
End Sub
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
'取数据
Dim tb As DataTable
Dim ds As DataSet = GridView1.DataSource
If ds Is Nothing Then
MsgBox("ds is Nothing")
Return
Else
tb = ds.Tables(0)
If tb Is Nothing Then
MsgBox("tb is Nothing")
Else
'(2)
'为什么(1)能取到字段中的值但(2)却取不到呢?
MsgBox(tb.Rows(0).Item(2).ToString)
End If
End If
End Sub
End Class