[2005] Modifying a dataset/tableadapter via code

[UsefulIdiot]

I have a couple of questions here. The first being, I have set up a bunch of fields to be databound to a sql server table. My first problem is how do I get the value of a field in the dataset(primary key in this case).

My next question is, If I databind another set of fields to another table, if i fill my tableadapter with a custom sql string(ie select * from blah where primary_key = " & primarykey_val), will it update all the bound fields or is there a way to achieve this behavior?

Thanks
chris