I’m gonna try my best to explain to you what’s happening. I have this page where a user can assign multiple ids by entering a beginning and ending number. If they enter 1 as the beginning number and 15 as the ending, ids 1 thru 15 will be assigned. I have it to where it checks whether or not it’s duplicate, which is working. Thing is I’m trying to get where I could select which id is duplicate and display a message label or something to let the user know which one it is. Whether it’s id 1, 2, 15, 18. Am I making sense?


Sub CheckDuplicatePassNumber()
        'Sub proc that checks to see if pass number has been assigned

        'Production connection

        Dim objDataReader As SqlDataReader
        Dim cmdChkDuplicate As New SqlCommand("spAAPCheckMultipleDuplicatePassNumber" , connAAP)
        cmdChkDuplicate.CommandType = CommandType.StoredProcedure

        'Checks to pass number has already been assigned
        'Declare parameters to send to the stored proc
        With cmdChkDuplicate.Parameters
            .Add("@vchAAPNumber2", txtBeginNum.Text)
            .Add("@vchEndAAP", txtEndNum.Text)
        End With

        connAAP.Open()
        objDataReader = cmdChkDuplicate.ExecuteReader()

        Do While objDataReader.Read()
            intcount += 1
        Loop

        objDataReader.Close()
        connAAP.Close()
    End Sub

Why not pass the dupes back from the store procedure and write the contents of your data reader out to the screen?

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

I don't understand what you mean. Could you give me an example?

SELECT id from <table> where id between @vchAAPNumber2 and @vchEndAAP

This will either return 0 results (no dupes) or return ids that already exsist and those would be your dupes.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor :.
Wrox Books 24 x 7
================================================== =========

looks good to me. I'm about to leave work but I will most definitely try it.