且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用IF条件将值添加到数据库表

更新时间:2023-11-30 23:16:46

try
{
   SqlConnection sqlconn = new SqlConnection("Data Source=AAN-PC;Initial Catalog=mon26;Integrated Security=True");
   SqlDataAdapter sa = new SqlDataAdapter();

   string query;
   if(hexvalue =""AA")
    query = "insert into Table_1(SensorValue,Time) values(@SV, @TM)";
   else
    query = "insert into Table_2(SensorValue,Time) values(@SV, @TM)";

   sa.InsertCommand = new SqlCommand(query, sqlconn);
   sa.InsertCommand.Parameters.AddWithValue("@SV", hexvalue);
   sa.InsertCommand.Parameters.AddWithValue("@TM", DateTime.Now.ToString());

   sqlconn.Open();
   try
   {
       sa.InsertCommand.ExecuteNonQuery();
    }
    catch (FormatException ex) { MessageBox.Show(ex.Message); }
                MessageBox.Show("Record Inserted");
               
    //  Update Datagridview
    mon26DataSet1.GetChanges();
    table_1TableAdapter.Fill(mon26DataSet1.Table_1);

    sqlconn.Close();
}