Hi,
I have a grid from a txt file that contains:
I want to filter by colum b from more than a number that is in a txtbox
But i don't know how.
The problem is that the grid is a string and not intenger?
I think that the best solution is working with a dataset ,pass all grid to a dataset and work from there
And after:
But it's not working
Can anybody help me?
Thanks for all ,and sorry for my english
I have a grid from a txt file that contains:
VB.NET:
A B C D
0.733333 120.000 20007.047 9365.221
6.731220 50.000 9292.373 9562.563
12.111977 62.627 1250.000 9661.794
I want to filter by colum b from more than a number that is in a txtbox
But i don't know how.
The problem is that the grid is a string and not intenger?
I think that the best solution is working with a dataset ,pass all grid to a dataset and work from there
Dim dr1 As DataRow For i As Integer = 0 To DataGridView1.RowCount - 1 dr1 = dset.Tables(0).NewRow For j As Integer = 0 To DataGridView1.Columns.Count - 1 dr1(j) = DataGridView1.Rows(i).Cells(j).Value Next dset.Tables(0).Rows.Add(dr1) Next
And after:
Dim dv As New DataView(dset.Tables(0)) dv.RowFilter = "CONVERT(B, 'System.Int32')" > textbox1.text
But it's not working
Can anybody help me?
Thanks for all ,and sorry for my english
Last edited by a moderator: