vb.net - How to filter datagridview column -

for example have datagridview1 data imported text file , there 3 columns: id, name, gender.

what want select/show male in gender column.

i dont have database here can't use sql queries or there way manipulate datagridview using sql queries? this:

select * datagridview1 gender='male' 

any response appreciated.

i c# developer, don't know if there built in functions in vb this, simplest way think loop through datagridview , filter manually, can either remove row or make in invisible.

you can implement basic search way too. of course not fastest nor effective way it, job done. alternatively can store data in list or array make loop run faster. improve performance can hide datagrid when loop started , show again when loop finished, way system won't waste time on showing datagrid animations.

for example you have number column , want show rows have values between 50-100, simple code this:

for(int i=0; i<datagridview1.rows.count; i++) {    int t = convert.toint32(datagridview.rows[i].cells[0].value);    if(t<50 || t>100) datagridview.rows[i].visible = false;    else datagridview.rows[i].visible = true; } 

code in c# , need spellchecking think got idea. hope able help. cheers.