[2005] Modifying a dataset/tableadapter via code

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

Well to get the value it would be like this:

VB Code:

datasetvariable.Tables(0).Rows(index)("ColumnName")

For the updating, I don't know.

Ok That works, but now, With having visually databound everything to controls, how can I via code modify that query and have all the values updated on the form? via the fill method on my tableadapter? I cant quite figure out this works.

If you want to modify the query, then you would have to modify the query used by the command object that is referenced as the SelectCommand for the TableAdapter.

Those methods and properties arent available(Intellisense doesnt show them generates compile errors) on the autogenerated ones for some reason, is there a way to make them available?

To modify the query, you create a new select command and fill the datadapter again.

What do you mean they aren't available? Do you have a reference to System.Data?