更改資料,ExecuteNonQuery()

標籤：vat   set   return   date   out   tostring   open   show   日期格   

using (mycon)
{
mycon.Open();

string MyTime;
DateTime dtDate;
MyTime = textBox1.Text.ToString();
string sql;
if (!DateTime.TryParse(MyTime, out dtDate))
{
MessageBox.Show("日期格式不正確!");
}
else
{
sql = "update [hf_zw].[dbo].[t_reservation] set reservation_service_time= ‘" + MyTime + "‘,state=1 where reservation_id=566";
SqlCommand mycom = new SqlCommand(sql, mycon);

//更改資料,ExecuteNonQuery()
mycom.ExecuteNonQuery();
MessageBox.Show("修改成功!");
}

}

}
else
{
MessageBox.Show("請勿快速控制項目！");
return;
}

}
catch
{

}
finally
{
mycon.Close();
// Console.WriteLine("成功關閉");
}

更改資料,ExecuteNonQuery()