SqlConnection myConn = new SqlConnection();
myConn.ConnectionString = "Data Source=192.168.15.252;Initial Catalog=TestDB;User ID=sa;Password=Pdindia123;";
myConn.Open();
string strqry = "UPDATE Registration SET Password = ' " + Text2.Text + " ',PhoneNo = ' " + Text3.Text + " ', Email = '" + Text4.Text + "' WHERE (UserName = ' " + Text1.Text + " ')";
Response.Write("UPDATE Registration SET Password = ' " + Text2.Text + " ',PhoneNo = ' " + Text3.Text + " ', Email = '" + Text4.Text + "' WHERE (UserName = ' " + Text1.Text + " ')");
Label1.Text = Text3.Text;
SqlCommand myCom = new SqlCommand(strqry, myConn);
myCom.ExecuteNonQuery();
myConn.Close();
no error not updating anything.....