insertupdatedelete

Question

insertupdatedelete 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 (EmpidENameEAddressESalary) in my Database and I want to fire insertupdate 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(@nametxtName.Text); cmd.Parameters.AddWithValue(@addtxtAdd.Text); cmd.Parameters.AddWithValue(@saltxtSal.Text); con.Open(); int rows=cmd.ExecuteNonQuery(); if(rows>0) { MessageBox.Show(Data saved SuccessfullyData 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=@idcon); cmd.Parameters.AddWithValue(@nametxtName.Text); cmd.Parameters.AddWithValue(@addtxtAdd.Text); cmd.Parameters.AddWithValue(@saltxtSal.Text); cmd.Parameters.AddWithValue(@idtxtID.Text); con.Open(); int rows=cmd.ExecuteNonQuery(); if(rows>0) { MessageBox.Show(Data Updated SuccessfullyData saved); con.Close(); } Delete Code SqlConnection con=new SqlConnection(Your Connection String); SqlCommand cmd=new SqlCommand(Delete From Emp where Empid=@idcon); cmd.Parameters.AddWithValue(@idtxtID.Text); con.Open(); int rows=cmd.ExecuteNonQuery(); if(rows>0) { MessageBox.Show(Data Updated SuccessfullyData saved); con.Close(); } Hope that Solves your problem. With Regards Vishal Gilbile.

insert,update,delete