nothing happens in update table when it executes...

[sarvanhsr]

    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 table... simply remains same.....

The update statement is not working in my website, no error in C# and no error in sql server. When I paste the update query into the sql query tool and replace the parameter values (+...) with real values, it updates the record.

[sashi]

Dear sarvanhsr,

Try to implement exception handling [try...catch] :)

[Frinavale]

Please take a look at the .NET articles:

How to use a database in your program part I

How to use a database in your program part II

Notice how in part I that parameters are used to create the SQL query. I recommend that you give that at try and see if it fixes the problem.

-Frinny