views:

51

answers:

0
 'Dim dbReader As System.Data.IDataReader
            '******* Ordinal values*******
            '0: ClientKey  
            '1: pkey 
            '2: TeamName 
            '3: Active 
 While dbReader.Read
                If (IsDBNull(dbReader.Item(1))) Then
                    Exit While
                End If
                If Convert.ToBoolean(dbReader.Item(3)) = True Then
                    pTeamCnt += 1
                    Try
                        pTeamKeyList(pTeamCnt) = dbReader.Item(1).ToString
                    Catch ex As Exception
                    End Try
                    pTeamNameList(pTeamCnt) = dbReader.Item(2)
                    SelectInsert3 = SelectInsert3 + "<OPTION VALUE=" & pTeamKeyList(pTeamCnt) & ">" & pTeamNameList(pTeamCnt) & "</OPTION>"
                End If
            End While
            dbReader.Close()
            dbReader.Dispose()
            dbReader = Nothing