private void Delete_Click(object sender, EventArgs e)
{
try
{
Connect connectObj = new Connect();
con = connectObj.connect();
SqlCommand cmd = new SqlCommand("DELETE FROM MYORDER WHERE ORD_ID = @oid", con);
cmd.Parameters.AddWithValue("@oid", OrderID.Text);
int i = cmd.ExecuteNonQuery();
con.Close();
//If count is equal to 1, than show frmMain form
if (i != 0)
{
MessageBox.Show("Order Deletion Successful!", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Order Deletion Failed", "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
OrderID.Clear();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Captions", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
private void clear_Click(object sender, EventArgs e)
{
OrderID.Clear();
}