Hi,

If I wish to validate whether the user input is a duplicate data in database, how can I code it? Is there any sample code that are available?

I'm using ADO to perform add, delete, update and etc...

Thank you...


Gary

You can add code under object lost focus events. If users input is duplicate then through an exception.

like

    Private Sub TextBox2_LostFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox2.LostFocus

   if bduplicate("write an sql query here") then
      msgbox "duplicate data please try again."
      textbox2.Focus
    End Sub

function bDuplicate(sql as string) as boolean
'below is not command just for your idea.
'open connection
'check for duplicate data by using passed parameter (sql)
'if duplicate data then 'bDuplicate = true else 'bduplicate = false
end function


shahid

Thanks sir,

I have better idea on it but may I know what SQL query I should write inside the bduplicate("SQL statement") because Im quite new in using SQL.

Anyway, thank you for your time...


Gary