Dim<\/span> findcrit as<\/span> string<\/span>\nDim<\/span> dt As<\/span> DataTable =<\/span> Ds_Pos.Employees<\/span>\n Dim<\/span> dv As<\/span> New<\/span> DataView(<\/span>dt)<\/span>\n \n Dim<\/span> _RowFilter As<\/span> String<\/span> =<\/span> ""<\/span>\n Dim<\/span> _FieldType =<\/span> dt.Columns<\/span>(<\/span>findcrit)<\/span>.DataType<\/span>.ToString<\/span>\n \n Select<\/span> Case<\/span> _FieldType\n Case<\/span> "System.Int32"<\/span>\n _RowFilter =<\/span> "convert("<\/span> &<\/span> findcrit &<\/span> ", 'System.String') like '"<\/span> &<\/span> Me<\/span>.TextBox1<\/span>.Text<\/span> &<\/span> "'"<\/span>\n Case<\/span> "System.Int64"<\/span>\n _RowFilter =<\/span> "convert("<\/span> &<\/span> findcrit &<\/span> ", 'System.String') like '"<\/span> &<\/span> Me<\/span>.TextBox1<\/span>.Text<\/span> &<\/span> "'"<\/span>\n Case<\/span> "System.Double"<\/span>\n _RowFilter =<\/span> "convert("<\/span> &<\/span> findcrit &<\/span> ", 'System.String') like '"<\/span> &<\/span> Me<\/span>.TextBox1<\/span>.Text<\/span> &<\/span> "'"<\/span>\n Case<\/span> "System.String"<\/span>\n _RowFilter =<\/span> findcrit &<\/span> " like '"<\/span> &<\/span> TextBox1.Text<\/span> &<\/span> "*'"<\/span>\n End<\/span> Select<\/span>\n dv.RowFilter<\/span> =<\/span> _RowFilter\n EmployeesDataGridView.DataSource<\/span> =<\/span> dv<\/pre><\/div><\/div>\nThe cases are to cast the type of variable from any type to string because you can only use the method on string data types.<\/p>\n
the idea is to move the content to a data table then filter then return it back to the datatable.<\/p>\n","protected":false},"excerpt":{"rendered":"
assuming you have a datagridview that has data in it. you want to avoid recalling sql from the database & just want to filter the datagrid. you can do the following, What you need (1 datagridview (data), 1 button (search), 1 textbox (string to search), 1 variable to precise the criteria your searching for) The […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[110],"tags":[33,34,37,75,78,131],"_links":{"self":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/159"}],"collection":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=159"}],"version-history":[{"count":0,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=\/wp\/v2\/posts\/159\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=159"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.raytawil.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![](\"http:\/\/www.raytawil.com\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/code.png\")
<\/a> ![](\"http:\/\/www.raytawil.com\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/printer.png\")
<\/a> ![](\"http:\/\/www.raytawil.com\/wp-content\/plugins\/wp-synhighlight\/themes\/default\/images\/info.gif\")
<\/a> <\/td><\/tr><\/table><\/div>