>> I have a class method that returns a DataSet to my application. I bind the >> DataSet to an DataGridView and would like to do the Add/Edit/Delete stuff > > This is just done by any basic grid by default (when not disabled). > Just bind your DataSet to Grid and you're done.
I'm using a DataGridView. When I add a record with auto-insert and then move off the new record, it isn't saved and no exceptions are thrown. There seem to be several ways to bind a DataSet to a grid. I've tried it assigning the DataSet directly to the grid.DataSource property and using a BindingSource assigning the DataSet to it's DataSource property and then assigning the BindingSource to the grid.DataSource. There are probably other ways as well. Can you give me an example of settings that will allow the grid to perform the updates? >> from within the grid. How do I update the database from the DataSet? The >> only examples I've seen use a DataAdapter but all I have access to in my >> application is a DataSet. Is it possible to update a DataAdapter from an >> existing DataSet or is there another way to update the database? > > If you have instance of DataAdapter, you just specify Update-, Delete- > and InsertCommand and call Update method for this particular table. > Or you can go thru DataTable in DataSet and check inserted, deleted > and modified rows and performs correspondent steps to update DB. I don't have access to the DataAdapter unless I can create one and populate it from the DataSet. ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
