How to write the delete query in sqlserver

i have created one design for that i done insert command,successfully all the datas are stored in the datasbase. i want to write the delete query how to do?

Design as follows;

Employeed id textbox1

Name textbox2

DOB textbox3

Age textbox4

Address textbox5

Area textbox6

Mobile textbox7

Insert Code as follows;

con = new SqlConnection("Server=(local);initial catalog=master;Trusted_Connection=True");

con.Open();

SqlCommand cmd = new SqlCommand("Employee", con);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add(new SqlParameter("@EmployeeID", DropDownList1.SelectedValue));

cmd.Parameters.Add(new SqlParameter("@EmployeeName", TextBox1.Text));

cmd.Parameters.Add(new SqlParameter("@DOB", TextBox2.Text));

cmd.Parameters.Add(new SqlParameter("@Age", TextBox3.Text));

cmd.Parameters.Add(new SqlParameter("@Address", TextBox4.Text));

cmd.Parameters.Add(new SqlParameter("@Area", TextBox5.Text));

cmd.Parameters.Add(new SqlParameter("@Mobile", TextBox6.Text));

cmd.Parameters.Add(new SqlParameter("@Phone", TextBox8.Text));

cmd.ExecuteNonQuery();

SqlCommand cmd1 = new SqlCommand("select * from Empdet", con);

SqlDataAdapter adp = new SqlDataAdapter(cmd1);

DataSet ds = new DataSet();

adp.Fill(ds);

con.Close();

GridView1.DataSource = ds;

GridView1.DataBind();

DetailsView1.DataSource = ds;

DetailsView1.DataBind();

how to write the delete query please help me.

Regards,

Rao.,

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Santhosh Kumar Jayaraman14y ago
con = new SqlConnection("Server=(local);initial catalog=master;Trusted_Connection=True");
con.Open();
SqlCommand cmd = new SqlCommand("delete Employee where employeeid=@EmployeeID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@EmployeeID", DropDownList1.SelectedValue));
cmd.ExecuteNonQuery();
0