SELECT SQL语句用于datagridview [英] SELECT SQL Statement for a datagridview
本文介绍了SELECT SQL语句用于datagridview的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
您好,我在数据库中插入记录。当按下按钮时,我需要在Datagridview中显示我的记录。 Datagridview应该只显示记录 SensorValue是< 20
。
我知道,SELECT,来自where语句将被使用但不知道,我应该如何在这里使用它。
谢谢
试用
{
SqlConnection sqlconn = new SqlConnection( 数据源= AN-PC;初始目录= Feb12;集成安全性=真);
SqlDataAdapter sa = new SqlDataAdapter();
string 查询;
query = 插入Table_1(SensorID,SensorValue,DateTime)值(@TM, @NT,@ MN);
sa.InsertCommand = new SqlCommand(query,sqlconn);
sa.InsertCommand.Parameters.AddWithValue( @ TM,y);
sa.InsertCommand.Parameters.AddWithValue( @ NT,x);
sa.InsertCommand.Parameters.AddWithValue( @ MN,DateTime.Now.ToString ());
sqlconn.Open();
尝试
{
sa.InsertCommand.ExecuteNonQuery();
}
catch (FormatException ex){MessageBox.Show(ex.Message); }
feb12DataSet.GetChanges();
table_1TableAdapter4.Fill(feb12DataSet.Table_1);
sqlconn.Close();
}
catch (SqlException ea){MessageBox.Show(ea.Message);你可以查询数据集
DataTable tblMEN = dsView.Tables [ MEN];
DataRow [] results = tblMen.Select( SensorValue< 20);
参考链接
如何在数据集上运行查询 [ ^ ]
您可以像这样使用Select语句。
DataTable dtSensor = feb12DataSet.Tables [ 0 ]。选择( SensorValue< ; 20) // 使用表索引或表名
Hello, I am inserting Records in a Database. I need my records to be shown in a Datagridview, when a button is pressed. Datagridview should show records only with SensorValue is < 20
.
I know, that SELECT, from where statement will be used but dont know , how should i use it here.
Thank you
try
{
SqlConnection sqlconn = new SqlConnection("Data Source=AN-PC;Initial Catalog=Feb12;Integrated Security=True");
SqlDataAdapter sa = new SqlDataAdapter();
string query;
query = "insert into Table_1( SensorID,SensorValue,DateTime) values( @TM, @NT, @MN)";
sa.InsertCommand = new SqlCommand(query, sqlconn);
sa.InsertCommand.Parameters.AddWithValue("@TM", y);
sa.InsertCommand.Parameters.AddWithValue("@NT", x);
sa.InsertCommand.Parameters.AddWithValue("@MN", DateTime.Now.ToString());
sqlconn.Open();
try
{
sa.InsertCommand.ExecuteNonQuery();
}
catch (FormatException ex) { MessageBox.Show(ex.Message); }
feb12DataSet.GetChanges();
table_1TableAdapter4.Fill(feb12DataSet.Table_1);
sqlconn.Close();
}
catch (SqlException ea) { MessageBox.Show(ea.Message); }
解决方案 you can query the data set
DataTable tblMEN = dsView.Tables["MEN"];
DataRow[] results = tblMen.Select("SensorValue < 20");
reference link
how to run query on dataset[^]
You can use Select statement like this.
DataTable dtSensor = feb12DataSet.Tables[0].Select("SensorValue < 20") // use Table index or Name of table
这篇关于SELECT SQL语句用于datagridview的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文