dataGridView定时刷新问题求教
窗体如下:
在这个窗体中,加入了time控件,我想通过时间控件定时执行一个存储过程,并把结果显示到dataGridView1上;
我写的代码如下:
private DataTable MessageCount = new DataTable();
private SqlDataAdapter MyDs = new SqlDataAdapter();
private void timer1_Tick(object sender, EventArgs e)
{
string ServerIP = txtServerIP.Text;
string UserName = txtUserName.Text;
string PassWord = txtPassWord.Text;
string DataName = txtDataName.Text;
string strMyConn = "Server=" + ServerIP + ";user id=" + UserName + ";password=" + PassWord + ";initial catalog=" + DataName + ";";
SqlConnection MySQLConn = new SqlConnection(strMyConn);
SqlCommand Ds = new SqlCommand("EXEC CS_CountMessag", MySQLConn);
MyDs.SelectCommand = Ds;
MyDs.Fill(MessageCount);
dataGridView1.DataSource = MessageCount;
}
private DataTable MessageCount = new DataTable();