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?

[quote author=Imperceptus link=topic=18078.msg183441#msg183441 date=1254436119]
I am out of ... Coffee.  Any thoughts/suggestions?
[/quote]

Buy more coffee.

I need to figure a way to take my coffee intravenously, then I could improve efficiency of my work time! lol thanks for that.