I have the following:
Dim dt As DataTable = ds.Tables(0)
Tables(0) has about 20 columns. I like to select only a couple. "PrID" is one of the fields.
I tried
Dim dt As DataTable = ds.Tables(0).Select("PrID")
without any success. Any idea?
One way is using the DataRow extension method Field which is strongly typed and supports nullable types:
For Each row As DataRow in ds.Tables(0).Rows
Dim PrID As Int32 = row.Field(Of Int32)("PrID")
Next
Edit: If you want another DataTable with a subset of columns of the original DataTable you can use the DataView of the table and it's ToTable method:
Dim displayView = New DataView(ds.Tables(0))
' if you're only interested in: PrID, Col2, Col3
Dim subset As DataTable = displayView.ToTable(false, "PrID", "Col2", "Col3")
You can get PRID column using.
Dim dt As New DataTable
Dim columns As String() = "PrID".Split(",")
dt = ds.Tables(0).DefaultView.ToTable(String.Empty, False, columns)
'first create a new Dataview
Dim [Dataview] As New DataView
'here add the table to Dataview you want to filter its columns
[Dataview].Table = Ds.Tables(" here Write TableName ")
'here you can display selected Columns in Datatable
Dim [datatable] As DataTable = [Dataview].ToTable(False, "desired column Name ", "desired Column Name")
'here you can display selected Columns in DatagridView1
DataGridView1.DataSource = [Dataview].ToTable(False, "desired column Name ", "desired Column Name")
