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
-----------------------
Show quoteHide quote

Sending mail from page
Syntax error in INSERT INTO statement
User Control saving properties
How to attach an exe to the debugger?
question about opening SQL results in Excel from ASP.NET via XML
Is my interpretation of COM interface correct?
byte array concatenation
Getting the generated name attribute for use in JavaScript
problem with DataSet.GetXml() method
Throwing an exception on a thread....