syntax to compare data from text field, when adding a record, to a field in a table for duplicates

  • Thread starter Thread starter amanda
  • Start date Start date
A

amanda

What will be the syntax if I want to compare whether the phone number I
am entering when adding a record already exists in database. The phone
field in that table is set to primary key.

We are using binding source in this application.
 
Hi,

Try something like this.

Load dataset and define primary key
Dim strConn As String
Dim da As SqlDataAdapter
Dim conn As SqlConnection

strConn = "Server = .;Database = NorthWind; Integrated Security =
SSPI;"
conn = New SqlConnection(strConn)

da = New SqlDataAdapter("Select * from Products", conn)
da.Fill(ds, "Products")
ds.Tables("Products").PrimaryKey = New DataColumn()
{ds.Tables("Products").Columns("ProductID")}

I would try to find the new key. If there is no return value it is ok to
add that key. Here is a simple function to check if it is ok to add


Private Function OkToAdd(ByVal strNewValue As String) As Boolean
Dim dr As DataRow = ds.Tables("Products").Rows.Find(strNewValue)
Return dr Is Nothing
End Function

Ken
 
Back
Top