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.

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

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …

A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way.
I've always enjoyed working with graphics, but it's never too clever to re-invent …

Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…