Dataset and dataadapter

[Ronny]

Using a dataset I can retrieve data, modify and than update the database.
Can I also add some rows to the database, based on the dataset calculation?
I actually have to insert some rows based on the dataset calculation,
without modifying the existing data.
Regards
Ronny

 

[William Vaughn \(MVP\)]

A DataSet (a container for DataTable objects) is simply an in-memory
(snapshot) representation of rows in the database. You can execute UPDATE or
INSERT or other DML commands against the database independently without
affecting the current state of the local rowsets. However, if you're
fetching rows to run expressions to change server-side data, it makes more
sense to perform these operations on the server (assuming you're not using a
toy database).

--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________

 

[Ronny]

Thanks,
I use FireBird and I'm doubtful if the power of the language would let me
implrmemrnt my logic with a stored procedure(if that what you meant).
Anyhow since I'm a beginner in database programming I'd like to implement it
in the client side first.
Regards
Ronny