Update Problem

[ninjaX]

i got a problem to update my data
the command like below

==============================================

Me.Visible = False

Dim Cmd As New OleDbCommand("UPDATE Employee SET efirstname='" & Me.empfirstname.Text & "',elastname='" & Me.emplastname.Text & "',ephone='" & Me.empphone.Text & "',eaddress='" & Me.empaddress.Text & "',eaddress1='" & Me.empaddress1.Text & "',eaddress2 ='" & Me.empaddress2.Text & "',eemail='" & Me.empemail.Text & "' where efirstname='" & Me.empfirstname.Text & "'And elastname = '" & Me.emplastname.Text & "'", conn)

Try
conn.Open()
Cmd.ExecuteNonQuery()
conn.Close()
Catch ex As Exception
'catch the exception
End Try

==============================================

is there any problem with my code ?

or can somebody post up a sample coding with the update command !!
thank you very much

==============================================

[SnappleBoy]

Do you get an error message of any sort? if so, what is it?

I think you have at least one problem, you can't update the private and last name, the reason: you have only two text boxes for them, you should have four, currentfirstname, currentlastname, newfirstname, newlastname...

[ninjaX]

i know what u mean already ~
thanx for helping