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

[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.

 

[Ken Tucker [MVP]]

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