[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

[warrenayen]

Well to get the value it would be like this:

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

For the updating, I don't know.

[UsefulIdiot]

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.

[Aspnot]

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.

[UsefulIdiot]

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?

[warrenayen]

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?