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(s trConn)

da = New SqlDataAdapter( "Select * from Products", conn)
da.Fill(ds, "Products")
ds.Tables("Prod ucts").PrimaryK ey = New DataColumn()
{ds.Tables("Pro ducts").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("Prod ucts").Rows.Fin d(strNewValue)
Return dr Is Nothing
End Function

Ken
-----------------------
"amanda" <am**********@y ahoo.comwrote in message
news:11******** **************@ j44g2000cwa.goo glegroups.com.. .

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.