为何同一个dbread,绑定一个datalist,一个gridview,datalist就有数据,gridview就是空的呢?
Protected Sub Page_Load1(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim conn As SqlConnection
Dim dbstring
dbstring = System.Configuration.ConfigurationManager.ConnectionStrings("connstr").ToString
conn = New SqlConnection(dbstring)
conn.Open()
Dim comm As SqlCommand
Dim sql As String
Dim dbread As SqlDataReader
sql = "select * from [table]"
comm = New SqlCommand(sql, conn)
dbread = comm.ExecuteReader()
dl1.DataSource = dbread
dl1.DataBind()
gv1.DataSource = dbread
gv1.DataBind()
End Sub
dl1是一个datalist,gv1是一个gridview,前台能显示出datalist的内容,gridview就显示不出来。
gridview asp.net vb
------解决方案--------------------------------------------------------
绑定datatable,不要绑定datareader