如何通过按下按钮执行gridview [英] How do I make a gridview execute with a button press

问题描述

如何通过按下按钮执行gridview？

How do I make a gridview execute with a button press?

<asp:Button ID="Button1" runat="server" Text="Button" />
<asp:GridView ID="GridView1"

            DataSourceID="SqlDataSource1"

            ...

            runat="server">
<asp:SqlDataSource 

            ID="SqlDataSource1" 

            ConnectionString="<%$ ConnectionStrings:reg %>"

            SelectCommand="SELECT * FROM [table];"

            ...

            runat="server">
</asp:SqlDataSource>

推荐答案

ConnectionStrings：reg％>

< span class =code-attribute> SelectCommand = SELECT * FROM [table];

...

< span class =code-attribute> runat = server >
< / asp：SqlDataSource >

ConnectionStrings:reg %>" SelectCommand="SELECT * FROM [table];" ... runat="server"> </asp:SqlDataSource>

从aspx中删除数据源，您可以从后面的代码创建数据源在下面的按钮点击事件上绑定到gridview

点击事件代码：

remove the data source from aspx and you can create data source from code behind and bind to gridview on button click event like below
click event code:

Dim SqlDataSource1 As New SqlDataSource()
SqlDataSource1.ID = "SqlDataSource1"
Me.Page.Controls.Add(SqlDataSource1)
SqlDataSource1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings("reg").ConnectionString
SqlDataSource1.SelectCommand = "SELECT * FROM [table]"
GridView1.DataSource = SqlDataSource1
GridView1.DataBind()

只需添加：



GridView1.DataBind（）



到Button_Click函数，它会更新它

Just add:

GridView1.DataBind()

to the Button_Click function and it will update it

这篇关于如何通过按下按钮执行gridview的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！