Datatable.Select

[Imperceptus]

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

Code Select Expand


        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

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?

[Camel]

I am out of ... Coffee.  Any thoughts/suggestions?

Buy more coffee.

[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.