mysql - 用 ASP.NET 编写的 SQL 查询(后面的代码是 VB)未提供预期结果

Question

下面是我在 ASP.NET 应用程序中隐藏的代码的一部分，隐藏的代码是 Visual Basic。当providerOfficeQuery运行时，它没有提供预期的结果。您可以看到查询正在使用的数据库部分:

67          RUMINJO, ANNE MD    CHAPEL HILL - PROVIDENCE RD     chapelhillProvidenceRDArrayList
68          RUSSO, FRANK FNP-BC ASHEVILLE - RIDGEFIELD BLVD ashevilleRidgefieldBLVDArrayList
69          SAWYER, LOUIS PHD   DURHAM COUNSELING CENTER    durhamCounselingCenterArrayList
70          SAWYER, LOUIS PHD   DURHAM - SHANNON RD durhamShannonRDArrayList
71          SCHIAPPA, JENNIFER LCSW CARY COUNSELING CENTER  caryCounselingCenterArrayList

很抱歉格式错误，字段分别为 ID、PROVIDER、OFFICE、OFFICE_ARRAY_LIST。

当providerName等于“SAWYER，LOUIS PHD”时，我希望查询产生两个结果，第69行和第70行，然后为我提供办公室“DURHAM COUNSELING CENTER”和“DURHAM - SHANNON RD”，但是当运行查询实际发生的是我最终两次出现“DURHAM COUNSELING CENTER”。我已经通过将结果添加到列表框来验证结果来验证这一点。

我不是专家，我搜索过 Google 和各种论坛，但找不到为什么这没有产生预期结果。大家有什么想法吗？

谢谢。

            ' find the Provider's office and add it to the ListBox
        Dim providerOfficeQuery = From populateItem In db.Sheet3_
                                  Where populateItem.PROVIDER = providerName
                                  Select populateItem

        For Each x In providerOfficeQuery

            providerInfoOffice = x.OFFICE

            If providerInfoOffice = "ASHEVILLE - DOCTOR'S PARK" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS OF CENTRAL ASHEVILLE")
            ElseIf providerInfoOffice = "ASHEVILLE - RIDGEFIELD BLVD" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS OF SOUTH ASHEVILLE")
            ElseIf providerInfoOffice = "CARY - E CHATHAM ST" Then
                providerInfoListBox.Items.Add("CPMH AFFILIATE: CARY - DONNA PARRISH")
            ElseIf providerInfoOffice = "CARY - KILDAIRE FARM RD" Then
                providerInfoListBox.Items.Add("CPMH AFFILIATE: CARY - JENNY TART")
            ElseIf providerInfoOffice = "CARY - SE CARY PKWY" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS OF CARY")
            ElseIf providerInfoOffice = "CARY COUNSELING CENTER" Then
                providerInfoListBox.Items.Add("CARY COUNSELING CENTER")
            ElseIf providerInfoOffice = "CHAPEL HILL - FRANKLIN ST" Then
                providerInfoListBox.Items.Add("CPMH AFFILIATE: CHAPEL HILL - DANA BENNISON")
            ElseIf providerInfoOffice = "CHAPEL HILL - PROVIDENCE RD" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS Of CHAPEL HILL")
            ElseIf providerInfoOffice = "CHARLOTTE" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS OF CONCORD")
            ElseIf providerInfoOffice = "DURHAM - BROAD ST" Then
                providerInfoListBox.Items.Add("CPMH AFFILIATE: DURHAM - SARAH DAWSON")
            ElseIf providerInfoOffice = "DURHAM - NEW HOPE COURT" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS AT NEW HOPE COURT")
            ElseIf providerInfoOffice = "DURHAM - SHANNON RD" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS AT SHANNON RD")
            ElseIf providerInfoOffice = "DURHAM COUNSELING CENTER" Then
                providerInfoListBox.Items.Add("DURHAM COUNSELING CENTER")
            ElseIf providerInfoOffice = "NORTH RALEIGH COUNSELING CENTER" Then
                providerInfoListBox.Items.Add("NORTH RALEIGH COUNSELING CENTER")
            ElseIf providerInfoOffice = "RALEIGH - DRESSER COURT" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS OF RALEIGH")
            ElseIf providerInfoOffice = "RALEIGH - NEUROPSYCH CLINIC" Then
                providerInfoListBox.Items.Add("THE NEUROPSYCH CLINIC")
            ElseIf providerInfoOffice = "RALEIGH - RALEIGH ANNEX" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS RALEIGH ANNEX")
            ElseIf providerInfoOffice = "RALEIGH - WELLNESS CENTER" Then
                providerInfoListBox.Items.Add("THE WELLNESS CENTER")
            ElseIf providerInfoOffice = "WAKE FOREST - CAPCOM AVE" Then
                providerInfoListBox.Items.Add("CAROLINA PARTNERS OF WAKE FOREST")
            ElseIf providerInfoOffice = "WAKE FOREST - WFCC" Then
                providerInfoListBox.Items.Add("WAKE FOREST COUNSELING CENTER")
            ElseIf providerInfoOffice = "WILSON - NASH ST" Then
                providerInfoListBox.Items.Add("WILSON PSYCHIATRIC ASSOCIATES A CAROLINA PARTNERS PRACTICE")
            End If

            providerInfoOffice = Nothing

        Next

Answer 1

尝试添加:

Dim ResultCount = provierOfficeQuery.Count()

并输出“DURHAM COUNSELING CENTER”案例的 ResultCount 值，以确保您确实获得了返回的两个结果。

如果不是两个，那么您必须查看 Zaki 提到的源数据。例如，SAWYER、LOUIS PHD 的记录之一在 PROVIDER 字段中可能有多余的空格或其他内容。