Updating Multiple columns in mysql DB

See more:

MySQL

COde

cn.ConnectionString = ConfigurationManager.ConnectionStrings("my").ConnectionString
       cn.Open()
       s = "select * from mat_profile where pid='" & Session(uname) & "' "
       cd = New MySqlCommand(s, cn)
       d = cd.ExecuteReader()
       If d.Read() Then
          
           TextBox1.Text = d("name").ToString()
       
      

           d.Close()
           cn.Close()

All this go well

when i try to update the it again update the values of textbox which i read earlier , means it doesn't take the new values

Example

On page load , it reads name of the login person
and retrieve as below
Name = Textbox1 (Naren)

then i change the value in the same textbox
Name = Textbox1 (Narendra)

And Try To Update

update mat_profile set name= Textbox1.text where pid= Session(uname)

It Update Successful the Table but not the new value i wrote , it update the old value which it read on page load in Textbox1

mean the Value it update is old one ,

then what i do take a new Textbox2

I write the new value in textbox2

update mat_profile set name= textbox2.text where pid= Session(uname)

Bingo It Update it , what is this , how do i solve it

I can't take more textbox to update more fields ,

Does Have Any Idea

Waiting ......