Query CSV data in Dataset

[Dodger]

Hey All,

I have loaded CSV data into a dataset, but I'm not sure how to query this dataset with SQL, is it possible?

TIA.

_Dodger.

[DevGrp]

You do something like this

Dim rows() as DataRow = MyDS.Table("myTable").Select(SQL statement here)

Hope that helps.

[Dodger]

Hi DevGrp,

Here is my code, it seems to be selecting the correct number of rows, but all data is null, I'm obviously doing something wrong (new to .NET). Please assist if you can.

        Dim fxDataSet As New Data.DataSet()
        Dim fxTable As New DataTable()
        Dim fxFile As StreamReader = New StreamReader("C:\_Trading\History\25-06-03_02-09-03.txt")

        With fxTable.Columns
            .Add("Date")
            .Add("Price")
        End With

        While fxFile.Peek <> -1
            fxTable.Rows.Add(Split(fxFile.ReadLine, ",", , CompareMethod.Text))
        End While

        Dim rows() As DataRow = fxTable.Select("Units = ' 150'")

        fxTable.Clear()

        Dim i As Integer
        For i = 0 To rows.GetUpperBound(0)
            fxTable.Rows.Add(rows(i))
        Next

        fxDataSet.Tables.Add(fxTable)
        DataGrid1.DataSource = fxDataSet

        TextBox1.Text = fxDataSet.Tables(0).Rows.Count()

TIA.

_Dodger.

[DevGrp]

If you are doing it like that, then you can just use a DataView. I'll post some code when I get home.

[Dodger]

Thanks DevGrp! I think I have it working correctly.