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.

How to update sql database without using dataadapter?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)