insert,update,delete

Hello Friend,
                Lets consider I've an employee Table with fields (Empid,EName,EAddress,ESalary) in my Database and I want to fire insert,update and delete query on that Table. Following code will do the same.

Insert Code

SqlConnection con=new SqlConnection("Your Connection String");
SqlCommand cmd=new SqlCommand("Insert into Emp values(@name,@add,@sal)",con);
cmd.Parameters.AddWithValue("@name",txtName.Text);
cmd.Parameters.AddWithValue("@add",txtAdd.Text);
cmd.Parameters.AddWithValue("@sal",txtSal.Text);
con.Open();
int rows=cmd.ExecuteNonQuery();
if(rows>0)
{
MessageBox.Show("Data saved Successfully","Data saved");
con.Close();
}




Update Code

SqlConnection con=new SqlConnection("Your Connection String");
SqlCommand cmd=new SqlCommand("update Emp Set EName=@name, EAddress=@add, Esalary=@sal where Empid=@id",con);
cmd.Parameters.AddWithValue("@name",txtName.Text);
cmd.Parameters.AddWithValue("@add",txtAdd.Text);
cmd.Parameters.AddWithValue("@sal",txtSal.Text);
cmd.Parameters.AddWithValue("@id",txtID.Text);
con.Open();
int rows=cmd.ExecuteNonQuery();
if(rows>0)
{
MessageBox.Show("Data Updated Successfully","Data saved");
con.Close();
}



Delete Code


SqlConnection con=new SqlConnection("Your Connection String");
SqlCommand cmd=new SqlCommand("Delete From Emp where Empid=@id",con);
cmd.Parameters.AddWithValue("@id",txtID.Text);
con.Open();
int rows=cmd.ExecuteNonQuery();
if(rows>0)
{
MessageBox.Show("Data Updated Successfully","Data saved");
con.Close();
}


Hope that Solves your problem.

With Regards,
Vishal Gilbile.