Dim dt As Date dt = dtp_Expired.Value sqlad.UpdateCommand = New SqlCommand(" UPDATE tbl_CustomerCard SET fld_custPhone = " & txt_Phone.Text & ", fld_ExpireDate = " & dt & " WHERE fld_CardNo = " & txt_MembershipID.Text & " ", sqlc) Try sqlad.UpdateCommand.ExecuteNonQuery() MsgBox("Customer Data Update") Catch ex As Exception MsgBox(ex.Message) End Try
UPDATE tbl_CustomerCard SET fld_custPhone = @Phone, fld_ExpireDate = @Exdate WHERE fld_CardNo = @CardNo
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)