How to update sql database without using dataadapter?

Question

Hi everyone, How to update sql database without using dataadapter?

Satyapriya Nayak · Answer

Hi black, con.Open(); str = "update student set sname='" + txtname.Text.Trim() + "',smarks=" + txtmarks.Text.Trim() + ",saddress='" + txtaddress.Text.Trim() + "',year='" + txtyear.Text.Trim() + "' where sid='" + txtid.Text.Trim() + "'"; com = new SqlCommand(str, con); com.ExecuteNonQuery(); con.Close(); ---------------------------------------------------------------------------------------------------------------------------- con.Open(); str = "update student set sname=@sname,smarks=@smarks,saddress=@saddress,year=@year where sid=@sid"; com = new SqlCommand(str, con); com.Parameters.Add("@sid", txtid.Text); com.Parameters.Add("@sname", txtname.Text); com.Parameters.Add("@smarks", txtmarks.Text); com.Parameters.Add("@saddress", txtaddress.Text); com.Parameters.Add("@year", txtyear.Text); com.ExecuteNonQuery(); con.Close(); ------------------------------------------------------------------------------------------------------------------------------ Stored Procedure CREATE PROCEDURE update1 (@sid varchar(50),@sname varchar(50),@smarks int,@saddress varchar (50),@year varchar(50)) AS update student set sname=@sname,smarks=@smarks,saddress=@saddress,year=@year where sid=@sid con.Open(); com = new SqlCommand("update1", con); com.CommandType = CommandType.StoredProcedure; com.Parameters.Add("@sid", txtid.Text); com.Parameters.Add("@sname", txtname.Text); com.Parameters.Add("@smarks", int.Parse(txtmarks.Text)); com.Parameters.Add("@saddress", txtaddress.Text); com.Parameters.Add("@year", txtyear.Text); com.ExecuteNonQuery(); con.Close(); ------------------------------------------------------------------------------------------------------------------------------------ Thanks If this post helps you mark it as answer

Black Diamond · Answer

hi! satyapriya Nayak, Thanks for your response and the code, it's work perfectly.