How to get the minimum of a specified row with a filtered column. on the DataTable with the select method

Question

How to get the minimum of a specified row with a filtered column. on the DataTable with the select method

Mansour_Dalir 2,036

hi

I have a select row with two filters. He is not replying

need Output row 5 with MyDataTable.Select() ..

Always be healthy .thank


       Dim MyDataTable As New DataTable
        MyDataTable.Columns.Add("Group", GetType(Integer))
        MyDataTable.Columns.Add("Level", GetType(Integer))
        MyDataTable.Rows.Add(1, 100) '1
        MyDataTable.Rows.Add(2, 70)  '2
        MyDataTable.Rows.Add(1, 60)  '3
        MyDataTable.Rows.Add(2, 50)  '4
        MyDataTable.Rows.Add(1, 40)  '5
        Dim DataRow() As DataRow = MyDataTable.Select("[Group]=1 And [Level]=Min([Level])")  'is Error

Accepted answer

0 additional answers

Your answer

Answer 1

Anonymous

Hi

I can not get any error. Screenshot shows the result I get from exactly your code.

111

Mansour_Dalir 2,036

But the length of DataRow() was 0.

I changed the code and it was fixed. I don't know why it was 0. In a larger DataTable


 Dim MyDataTable As New DataTable
        MyDataTable.Columns.Add("Group", GetType(Integer))
        MyDataTable.Columns.Add("Level", GetType(Integer))
        MyDataTable.Rows.Add(1, 100) '1
        MyDataTable.Rows.Add(2, 70)  '2
        MyDataTable.Rows.Add(1, 60)  '3
        MyDataTable.Rows.Add(2, 50)  '4
        MyDataTable.Rows.Add(1, 40)  '5
Dim ValCompute = MyDataTable.Compute("Min([Level])", "[Group]=1")
        Dim DataRow() As DataRow = MyDataTable.Select("[Group]=1 And [Level]=" & ValCompute)

Share via

How to get the minimum of a specified row with a filtered column. on the DataTable with the select method

0 additional answers

Your answer