Randy,

Well, you can filter your DataSets by using a DataView, which I've done for only a few things.. Sounds like to me though, that by creating a SQL Server View, you're bring down less data from the backend, which is a good thing and probably the best way to handle your particular situation.

~~Bonnie


>thanks for the input Bonnie. So what do you do, since you don't use views. Here is my case scenario. I have to do a cross tabulation on two tables. Then based on certain criteria, I filter the rows. Then I have to do a join with several other tables to get the information I need. Since you can't do Select statements on tables within a dataset, I am creating a view to hold the cross tabulation and then only have one Select statement to run to populate my final resulting dataset.