代码如下:
在page_lode函数中,引用getData();即可
public void getData()
{
SqlConnection con = new SqlConnection("Data Source=PC-PC;Initial Catalog=TunnelMonitor;Integrated Security=True");
//定义字符串sql,其含义为从数据表中查找列LoginName中TextBox1.Text的记录,列Password中TextBox2.Text的记录
string sql = "select * from RealData2 where Temp > '" + Label4.Text + "' or Temp < '" + Label3.Text + "' or Humid < '" + Label5.Text + "' or Humid > '" + Label6.Text + "' or Deform < '" + Label7.Text + "' or Deform > '" + Label8.Text + "' ";
SqlCommand cmd = new SqlCommand(sql, con);
//定义数据适配器da,将da的数据填充至Dataset类的对象dt中
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new D