how to update the data in asp.net using C#

you can try this one..

 

 

string CN = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

using (SqlConnection cn = new SqlConnection(CN))

{

      cn.Open();

      string strCmd = "update Users set Username=@Username,Email=@Email,Password =@Password,City =@City,ContactNo =@ContactNo where ( Id =@Id)";

      SqlCommand cmd = new SqlCommand(strCmd, 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);

      SqlDataAdapter sda = new SqlDataAdapter(cmd);

      DataSet ds = new DataSet();

      sda.Fill(ds);

      cmd.ExecuteNonQuery();

      con.Close();

      Response.Write("Your data SuccessFully Updated");

}

 

Hope this will help..

Hi shubham,

 

Your code looks correct.Please make sure your connection string is also valid and correct.

 

else let me know what error you are getting. 

Hi Subham,

 

Your code is fine there is not an any issue i think there is issue of your code is not organized well so youre getting too confused.

 

Take time organize code, give proper id name to controls and meaning full object name check value which  you are updating is into textbox 6 must have  any value which must exist in database.

 

If you still not get result let me know what is the error  youre getting.

Hi Subham,

 

Your code is fine there is not an any issue i think there is issue of your code is not organized well so youre getting too confused.

 

Take time organize code, give proper id name to controls and meaning full object name check value which  you are updating is into textbox 6 must have  any value which must exist in database.

 

If you still not get result let me know what is the error  youre getting.