update coding for visual studio with database connection

Question

plz provide me coding for update????

Munesh Sharma · Answer

You use this Code For Updating in gridview To read the connection string into your code, use the ConfigurationManager class. string connStr = ConfigurationManager. ConnectionStrings[ "connect" ].ConnectionString; protected void GridView1 _RowUpdating( object sender, GridViewUpdateEventArgs e) { int id = Convert .ToInt32(gvDetails.DataKeys[e.RowIndex].Value.ToString()); string name = gvDetails.DataKeys[e.RowIndex].Values[ "Name" ].ToString(); TextBox city = ( TextBox )gvDetails.Rows[e.RowIndex].FindControl( "city" ); con.Open(); SqlCommand cmd = new SqlCommand ( "update Employee_Details set City='" + city.Text + "',name='" + name.Text + "' where UserId=" + userid, con); cmd.ExecuteNonQuery(); con.Close(); lblresult.ForeColor = Color .Green; lblresult.Text = username + " Details Updated successfully" ; gvDetails.EditIndex = -1; BindEmployeeDetails(); } In Web config File connectionStrings > add name = "connect" connectionString = "server=servername;database=myDb; uid=myUser;password=myPass;" /> connectionStrings >

update coding for visual studio with database connection

Answers (1)