Re: Filter a dataform

From: Val Mazur (group51a_at_hotmail.com)
Date: 06/30/04 

Date: Tue, 29 Jun 2004 21:44:04 -0400

Hi Aaron,

What you need is to create DataView based on some filter, but since you
cannot just pass this dataview back to the DataSet, you need to bind
DataView to the grid. In this case DataGrid will display filtered data.
There is no direct way to copy filtered DataView into dataSet and you would
need to do this row-by-row. Next version of ADO.NET should have such
capabilities 

-- 
Val Mazur
Microsoft MVP
"Aaron Moore" <Aaron Moore@discussions.microsoft.com> wrote in message 
news:EB4D74BE-BC98-4D0A-AF50-44249B1CD727@microsoft.com...
> Hello, I used the dataform wizard and made a nice looking data entry form 
> in vb.net.  I have added a search button to the page, and it works great. 
> I am having a problem with a button that will allow me to filter the data 
> that is in the form.  I think I have to create a dataview from my dataset, 
> filter the data and then return it to the dataset that is bound to the 
> form somehow?? I dont really know. I have tried many things, and cant 
> figure it out.  The data has been loaded into a dataset, I want to pull 
> out only records where a column = 1 and then display only that data in the 
> form. How can I do this?? Any help would be great! Thank you,
>
> Aaron Moore