insert,update,delete

Question

insert,update,delete code in windows form using back end sqlserver2005.pls.

Satyapriya Nayak · Answer

http://www.c-sharpcorner.com/uploadfile/suthish_nair/datagridview-insert-update-delete-and-retrieve-records-using-stored-procedure/default.aspx

Jignesh Trivedi · Answer

hi, please refer below link it might help you. http://nareshkamuni.blogspot.com/2012/04/how-to-insert-edit-update-and-delete.html http://geekswithblogs.net/dotNETvinz/archive/2009/02/22/gridview-insert-edit-update-and-delete--the-ado.net-way.aspx

Vishal Gilbile · Answer

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.