Hi all

I am a bit new to .net and vb.

Working with the datgridcontrol. I manage to fill it fine with information from an access database.

What I would like is that when I click the datagrid I select the entire row of fields. I have manged to isolate the rownumber and thereplan to sql with an select statement. My question is:
how do I do this the best way. The documentation is a bit confusing. Do I need to make a new Oledbdataadapter object or? or can I use the existing one and then somehow write the sql statement "select * from persons where id = somevariable"

I am quite used to asp. But wonder a bit when it comes to vb can I write sql statements directly in the vb editor or do I need oledbdataadapters each and every time so that I can retrieve info from the database and in that case how do I get it to understand that only the id number that matches my varaile is what it should select

Thx you very much for any help