Capture.JPG

<div>
If you wish to filter rows from being displayed in the DataGridView and the DataSource of the DataGridView is a DataTable object then you can use the RowFilter property of the DefaultView to do the Filtering. For example if you created a DataTable from a SQL query then you can change the RowFilter as follows assuming the DataTable is called dt.<br />
<br />
'' where a,b and f are a numeric value <br />
dt.DefaultView.RowFilter = &quot;Style = a Or Style = b Or Style = f&quot;;<br />
<br />
or this version if the column data type is String<br />
dt.DefaultView.RowFilter = &quot;Style = 'a' Or Style = 'b' Or Style = 'f'&quot;;<br />
<br />
The following documentation will show how to make valid expressions for RowFilter property.<br />
<a href="https://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression(v=vs.110).aspx" rel="ugc nofollow">DataColumn.Expression Property</a>
</div>


<div>
Thank you Fernando. &nbsp;This works. &nbsp;You directed me to DataColumn.Expression Property. &nbsp;I looked at it but could not quite figure out how to use it. &nbsp;After the filtering has been done, I have a column called Quantity and I need to place the sum of that quantity in the filtered view in a textbox at the top of the form. &nbsp;Can you tell me how to do that?<br />
<br />
Thank you,<br />
<br />
T
</div>


<div>
Thank you Fernando. &nbsp;Works perfectly.
</div>


<div>
Not a problem, glad I was able to help.
</div>


<div>
<div class="content wysiwyg-content">
Is there a vb.net process that allows filtering in a datagridview? &nbsp;Suppose, for example, I have a column called Style and there are 15 possible styles. &nbsp;I want to be able to filter the dgv, so that I only see records where the Style column has a value of a, b, or f. &nbsp;Right now I am using a separate form to select the filtering criteria and then sending parameters to a SQL stored procedure and, finally, populating a table with the filtered rows and using that table as the source for the datagridview.<br />
<br />
I would rather do the filtering in the dgv itself, if there is a way.<br />
<br />
T
</div>
</div>


Is there a vb.net process that allows filtering in a datagridview?  Suppose, for example, I have a column called Style and there are 15 possible styles.  I want to be able to filter the dgv, so that I only see records where the Style column has a value of a, b, or f.  Right now I am using a separate form to select the filtering criteria and then sending parameters to a SQL stored procedure and, finally, populating a table with the filtered rows and using that table as the source for the datagridview.

I would rather do the filtering in the dgv itself, if there is a way.

T

vb.net filtering in datagridview

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,