Solved

Getting data assigned to a variable from a rowfilter

Posted on 2006-10-19
2
207 Views
Last Modified: 2006-11-18
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
Comment
Question by:malich1
2 Comments
 
LVL 10

Accepted Solution

by:
gangwisch earned 100 total points
ID: 17767236
you should just use:
dim dr() as datarow=SwitchNameIndex.select("indexid='1'")
your information will be contained in dr(0)("fieldname")
0
 

Author Comment

by:malich1
ID: 17767872
Excelent!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now