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