How to make commands work?

[MrNorth]

I have a scenario like this:


"select ib1,ib2,ib3 from TABLE1 WHERE ib4= 'g' "

I use the dataadapeter to fill a dataset with this data...


Then I modify the data offline by editing the dataset


The I want to update the database by using the dataadapter "Update" command

For that to work I need to specify an updatecommand and an insert command.

How do I do that? I haven't been able to find good info? I want to use stored procedures.


help
Henrik

[RhinoBull]

Here are two quick samples for "Update ..." and "Insert Into ..." sql statements:

Update Table1 Set Field1 = 'abc' Where Field2 = 123

Insert Into Table1 (Field1, Field2) Values ('abc', 123)

Note:
if field type is char/varchar/text then value must be embraced in a single quotes and no quotes for numeric fields.

[MrNorth]

Hi!

Thanks for the reply, but I thik you misunderstood my question (perhaps I was unclear)
I know sql, have been writing pl/sql for three years now.

What was unclear to me was how I bind an update pl/sql prcedure to the dataadapter updatecommand. Which parameters that need to match if I perform

da.Update(ds).

/Henrik
ps Forget what I wrote about the commandbuilder... it is not very effective when it comes to query performance ds