SQl Query against a Dataset ???

  • Thread starter Thread starter Rhyno Linde
  • Start date Start date
R

Rhyno Linde

Is it possible to run a query against a Dataset or create a Dataview that
only displays selected columns from the Dataset.
 
Hi,
You can create a DataView, which can filter data only on a single DataTable.
Dataview does have rich filtering and sorting capabilities.
 
Thanks for the reply, but what I need to do is: Display only certain columns
in a table through a DataView.
Sorting is possible, but it doesnt seem possible to exclude certain columns
from the view without deleting them from the dataset.

Manoj G said:
Hi,
You can create a DataView, which can filter data only on a single DataTable.
Dataview does have rich filtering and sorting capabilities.

--
HTH,
Manoj G [.NET MVP]
http://www15.brinkster.com/manoj4dotnet

Rhyno Linde said:
Is it possible to run a query against a Dataset or create a Dataview that
only displays selected columns from the Dataset.
 
Displaying a value is a separate process... You can use TableStyles in a DataGrid to restrict the
displayed columns, coming from a DataTable or DataView...

What kind of control do you you to display the data ?

Rhyno Linde said:
Thanks for the reply, but what I need to do is: Display only certain columns
in a table through a DataView.
Sorting is possible, but it doesnt seem possible to exclude certain columns
from the view without deleting them from the dataset.

Manoj G said:
Hi,
You can create a DataView, which can filter data only on a single DataTable.
Dataview does have rich filtering and sorting capabilities.

--
HTH,
Manoj G [.NET MVP]
http://www15.brinkster.com/manoj4dotnet

Rhyno Linde said:
Is it possible to run a query against a Dataset or create a Dataview that
only displays selected columns from the Dataset.
 
Back
Top