Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
how to update the data in asp.net using C#
Shubham Agrawal
Sep 19 2017 2:42 AM
181
Reply
i can't update data with tihs Code. So can Anyone suggest me as soon as possible.
string
CN = ConfigurationManager.ConnectionStrings[
"DBCS"
].ConnectionString;
using
(SqlConnection cn =
new
SqlConnection(CN))
{
cn.Open();
string
s =
"update Users set Username=@Username,Email=@Email,Password =@Password,City =@City,ContactNo =@ContactNo where ( Id =@Id)"
;
SqlCommand cmd =
new
SqlCommand(s, cn);
cmd.Parameters.AddWithValue(
"@Username"
, textbox1.Text);
cmd.Parameters.AddWithValue(
"@Email"
, textbox2.Text);
cmd.Parameters.AddWithValue(
"@Password"
, textbox3.Text);
cmd.Parameters.AddWithValue(
"@City"
, textbox4.Text);
cmd.Parameters.AddWithValue(
"@ContactNo"
, textbox5.Text);
cmd.Parameters.AddWithValue(
"@Id"
, textbox6.Text);
cmd.ExecuteNonQuery();
Response.Write(
"Your data SuccessFully Updated"
);
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Want to Make my Existing MVC4 website responsive.
Gridview Row Count Issue