• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

Getting data assigned to a variable from a rowfilter

I am pulling back data from a SQL server and building a table with it. From there I am applying a filter to look for a specific row in that table. After this how do I assign data to a variable? If I have the IndexID I need the SwitchName.

            command = conn.CreateCommand()
            command.CommandText = "Select IndexID, SwitchNameIndex from Network_NameIndex"
            rs = command.ExecuteReader


            Dim dsData As New Data.DataSet
            Dim SwitchNameIndex As New Data.DataTable
            With SwitchNameIndex.Columns
                .Add(New DataColumn("IndexID"))
                .Add(New DataColumn("SwitchNameIndex"))
            End With
            dsData.Tables.Add(SwitchNameIndex)

            While rs.Read()

                If Not IsDBNull(rs("IndexID")) Then
                    NameIndex = rs("IndexID")
                End If
                If Not IsDBNull(rs("SwitchNameIndex")) Then
                    SwitchName = rs("SwitchNameIndex")
                End If

                Dim row As DataRow = SwitchNameIndex.NewRow()
                row(0) = NameIndex
                row(1) = SwitchName
                SwitchNameIndex.Rows.Add(row)
            End While

            Dim DataView As DataView = New DataView(SwitchNameIndex)
            DataView.RowFilter = "IndexID = '1'"
0
malich1
Asked:
malich1
1 Solution
 
gangwischCommented:
you should just use:
dim dr() as datarow=SwitchNameIndex.select("indexid='1'")
your information will be contained in dr(0)("fieldname")
0
 
malich1Author Commented:
Excelent!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now