public static void UpdateOrder(UpdateOrder u) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("update Orders set status = @status where ID = @ID", u); } }
private void button1_Click(object sender, EventArgs e) { if ((string)orderListBox.SelectedItem != "") { UpdateOrder u = new UpdateOrder(); u.ID = orderListBox.SelectedIndex; u.status = "Completed"; DataBase.UpdateOrder(u); FillOrderData(); RefreshOrderList(); } else { MessageBox.Show("Please select not completed order at first!"); } }