Valhalla Legends Forums Archive | Web Development | Datatable.Select

AuthorMessageTime
Imperceptus
I am trying to get the Select method for datatables to work and It never seems to like msdn says.

[code]
        Dim dtTempSnapshot As DataTable = dsTempSnapshot.Tables(0)
        Dim dsExisting As DataSet = UserInfo.Portfolios.Snapshot.Details(PortfolioID, SnapshotDate)
        Dim dtExisiting As DataTable = dsExisting.Tables(0)
        For Each dRow As DataRow In dtTempSnapshot.Rows
            Dim drFound() As DataRow = dtExisiting.Select("Ticker='" & dRow("Ticker") & "'")
        Next
[/code]
Im hoping to fill drFound with results that would say dtExisting has a ticker that was in dtTempsnapshot.  However which ever why I try I end up with nodda OR I get told that the value for dRow("Ticker") is a column could not be found.  "Ticker" Is a primary key within the dataset.  I am out of Idea's and Coffee.  Any thoughts/suggestions?
October 1, 2009, 10:28 PM
Camel
[quote author=Imperceptus link=topic=18078.msg183441#msg183441 date=1254436119]
I am out of ... Coffee.  Any thoughts/suggestions?
[/quote]

Buy more coffee.
October 5, 2009, 6:05 PM
Imperceptus
I need to figure a way to take my coffee intravenously, then I could improve efficiency of my work time! lol thanks for that.
October 5, 2009, 10:23 PM

Search