每20秒刷新一次DataGridView？ [英] Refresh DataGridView every 20 seconds?

问题描述

我正在使用Microsoft Visual Studio 2005



我有一个带有以下代码的datagridview：

I am using Microsoft Visual Studio 2005

I have a datagridview with the following code:

sqlSA = "SELECT * FROM Mas_Display"
DGVsa.DataSource = con.ReturnQuery(sqlSA)

这是我的load_form

如何每20秒刷新一次？< br $>


i创建了一个计时器，但我不确定如何使用它每20秒刷新一次dgv。

这是我唯一的计时器代码：

it is my load_form
how do i refresh it every 20 seconds?

i created a timer but im not sure how to use it for refreshing a dgv every 20 seconds.
this is my only code for my timer:

LBLdate.Text = DateTime.Now.ToLongDateString() & " | " & DateTime.Now.ToLongTimeString()

超级帮助！在此先感谢

Super Help! Thanks in advance

推荐答案

<asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>

      <asp:Timer ID="Timer1" runat="server" Interval="20000" OnTick="Timer1_Tick"></asp:Timer>
 <asp:UpdatePanel runat="server">
          <ContentTemplate>
         <asp:GridView ID="DGVsa" runat="server"></asp:GridView>
          </ContentTemplate>
          <Triggers>
              <asp:AsyncPostBackTrigger ControlID="Timer1" EventName="Tick" />
              
          </Triggers>

      </asp:UpdatePanel> 

in .Cs

in .Cs

protected void Timer1_Tick(object sender, EventArgs e)
       {
Gridbinding()

       }
public void Gridbinding()
{
        sqlSA = "SELECT * FROM Mas_Display"
        DGVsa.DataSource = con.ReturnQuery(sqlSA);
        DGVsa.DataBind();
}

使用名为Timer的控件。您放置代码以在方法Tick中刷新数据网格。 （timer.tick）

Use a control that is called Timer. You place the code to refresh your datagrid in method Tick. (timer.tick)

timer.interval=20000 'Time in miliseconds

timer.enable=true
timer.start()

我希望这就是你要找的东西。

I hope this is what you are looking for.

这篇关于每20秒刷新一次DataGridView？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！