how to Update database

The follow code are add the new data( ID, Pasword) to database(Access) from the
Textbox items

Please to tech me to change or offer the code , some sample about update the
record like as:

Textbox1 is ID number,Textbox2 is new password, when people insert the ID number
and new password then click buttom, it will update the record

thank you~

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & Server.MapPath("Account.mdb") & ";"

        Dim MySQL As String = "INSERT INTO member (ID, password) VALUES
('" & txtID.Text & "','" & txtpassword.Text &
"')"
        Dim MyConn As New Data.OleDb.OleDbConnection(strConn)
        Dim cmd As New Data.OleDb.OleDbCommand(MySQL, MyConn)
        MyConn.Open()
        cmd.ExecuteNonQuery()
        MyConn.Close()

Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=" & Server.MapPath("Account.mdb") & ";"
        Dim MySQL As String = "UPDATE member SET password = '" &
txtpassword.Text & "' WHERE ID = '" & txtID.Text &
"')"
        Dim MyConn As New Data.OleDb.OleDbConnection(strConn)
        Dim cmd As New Data.OleDb.OleDbCommand(MySQL, MyConn)
        MyConn.Open()
        cmd.ExecuteNonQuery()
        MyConn.Close() 

 

hope it helps./.

kaushalparik27:Dim MySQL As String = "UPDATE member SET password = '"
& txtpassword.Text & "' WHERE ID = '" & txtID.Text &
"')"

Please.  You should encourage newcomers to use parameters:
http://www.mikesdotnetting.com/Article.aspx?ArticleID=26

Mikesdotnetting:

kaushalparik27:Dim MySQL As String = "UPDATE member SET password = '"
& txtpassword.Text & "' WHERE ID = '" & txtID.Text &
"')"

Please.  You should encourage newcomers to use parameters:
http://www.mikesdotnetting.com/Article.aspx?ArticleID=26


 

yes, i agree. i think i should.. will take care in future.. thanx to point
out.

kaushalparik27:yes, i agree. i think i should