在数据库表中有10000个数据行,表中有个ID字段,其范围0-9999.
每隔一秒刷新一次,往datagridview中添加一个数据,并用一个timer定时器。 我采用的方法可能占用了较大资源,有什么效率更高的办法?谢谢!
下面是定时器中的代码。
QZBdatanumber++;
string connectionString_QZB = "Data Source=20090226-1504\\SQLEXPRESS;Initial Catalog=705D;Integrated Security=True";
SqlConnection con_QZB = new SqlConnection(connectionString_QZB);
con_QZB.Open();
string command_QZB = "select * from QZBdata where ID = '" + QZBdatanumber + "'";
SqlCommand sqlCommand_QZB = new SqlCommand();
sqlCommand_QZB.Connection = con_QZB;
sqlCommand_QZB.CommandText = command_QZB; SqlDataAdapter sqlDataAdapter_QZB = new SqlDataAdapter();
sqlDataAdapter_QZB.SelectCommand = sqlCommand_QZB;
DataSet DataSet_QZB = new DataSet(); sqlDataAdapter_QZB.Fill(DataSet_QZB);
BindingSource BindingSource_QZB = new BindingSource();
BindingSource_QZB.DataSource = DataSet_QZB.Tables[0];
dataGV_qiuzuobiao.DataSource = BindingSource_QZB;
每隔一秒刷新一次,往datagridview中添加一个数据,并用一个timer定时器。 我采用的方法可能占用了较大资源,有什么效率更高的办法?谢谢!
下面是定时器中的代码。
QZBdatanumber++;
string connectionString_QZB = "Data Source=20090226-1504\\SQLEXPRESS;Initial Catalog=705D;Integrated Security=True";
SqlConnection con_QZB = new SqlConnection(connectionString_QZB);
con_QZB.Open();
string command_QZB = "select * from QZBdata where ID = '" + QZBdatanumber + "'";
SqlCommand sqlCommand_QZB = new SqlCommand();
sqlCommand_QZB.Connection = con_QZB;
sqlCommand_QZB.CommandText = command_QZB; SqlDataAdapter sqlDataAdapter_QZB = new SqlDataAdapter();
sqlDataAdapter_QZB.SelectCommand = sqlCommand_QZB;
DataSet DataSet_QZB = new DataSet(); sqlDataAdapter_QZB.Fill(DataSet_QZB);
BindingSource BindingSource_QZB = new BindingSource();
BindingSource_QZB.DataSource = DataSet_QZB.Tables[0];
dataGV_qiuzuobiao.DataSource = BindingSource_QZB;
http://msdn.microsoft.com/zh-cn/library/system.windows.forms.datagridview.virtualmode(VS.80).aspx