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
==============================================![]()
![]()
![]()
![]()




Reply With Quote