The following code is the implementation of every 2 seconds to refresh the display of the current database objects, respectively, using three kinds of timers:
1, Winform timer (System.Windows.Forms.Timer)
Forms.timer is a single-threaded timer and relies on the current form. The simplest use:
public partial class Form1 : Form
{
System.Windows.Forms.Timer t;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
t = new System.Windows.Forms.Timer();
t.Interval = 2000;//间隔时间
t.Enabled = true;
t.Tick += new EventHandler(timersTimer_Elapsed);
t.Start();
}
private void timersTimer_Elapsed(object source, EventArgs e)
{
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(
"select * from sysobjects order by newid()",
"server=.;uid=sa;pwd=sa;database=master;");
sda.Fill(ds);
sda.Dispose();
dataGridView1.DataSource = ds.Tables[0].DefaultView;
}
}