private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Please Enter Student's Name","Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
try
{
string cs = @"Data Source=NADEEM-PC\SQLEXPRESS;Initial Catalog=School Managment System;Integrated Security=True";
SqlConnection con = new SqlConnection(cs);
SqlCommand cmd = new SqlCommand(
"DELETE FROM [Students Records] WHERE [Reg.No] = @Reg, con);
cmd.Parameters.AddWithValue("@Reg", textBox1.Text
);
cmd.Connection = con;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Deleted");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}