声明gridview selectcommand

Question

当页面加载时，应该使用我的第一个SQL SELECT语句加载GridView (位于更新面板中)。

单击按钮时，将使用新数据加载相同的GridView。

我做错了什么？在启动时，GridView不会出现。

Public cmd As New SqlCommand()
    Public percentp As New SqlCommand()
    Public da As New SqlDataAdapter(cmd)
    Public conn As New SqlConnection("Data Source=TEST-TEST-TEST01;Initial Catalog=TEST;Integrated Security=True")

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    cmd.Connection = conn
    conn.Open()
    Dim ds As New DataSet
    cmd.CommandText = "Select * from test1"
    da.Fill(ds)
    GridView1.DataSource = ds.Tables(0)
    da.FillSchema(ds, SchemaType.Mapped)
    conn.Close()        
End Sub   

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles Button1.Click
    cmd.Connection = conn
    conn.Open()
    Dim ds As New DataSet
    cmd.CommandText = "SELECT * from test"
    da.Fill(ds)
    GridView1.DataSource = ds.Tables(0)
    da.FillSchema(ds, SchemaType.Mapped)
    conn.Close()        
    TextBox1.Text="aaaaaaaaaaa"
End Sub
End Class

我尝试过GridView1.DataSource = ds.Tables(0) GridView1.DataBind

Answer 1

你需要打电话给

GridView1.DataSource = ds.Tables(0)
GridView1.DataBind() // this is needed to bind the datasource to GridView

Answer 2

设置好数据源后，需要调用GridView1.DataBind();。

Answer 3

在从数据库检索数据之后，您忘记了包含GridView1.Databind()命令。通常在检索数据后设置数据源，因此Page_Load方法会更好地工作：

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    cmd.Connection = conn
    conn.Open()
    Dim ds As New DataSet
    cmd.CommandText = "Select * from test1"
    da.Fill(ds)
    conn.Close()        
    GridView1.DataSource = ds.Tables(0)
    GridView1.DataBind()        
End Sub