insert, update, delete is not saved in DB (sqlsvr)

459

insert, update, delete is not saved in DB (sqlsvr)

elke posted over 16 years ago

Hello, I have a project containing a dataset “dsNetwerk”.I have programmed a SqlDataAdapter with a select command, wich works fine with the ultrawebgrid ‘uwgNetwerk’. Now, I try to programm insert, update and delete commands.It seems to work fine. When I debug, I see the changes in the dataset (fe. me.sqlDataset.tblNetwerkDocumentatie.Rows(3).Item(4)). But the changes are not saved in the database itself.I suppose you’ll need more information about my project, but I don’t know what specific information you’ll need. Thx in advance

Elke

350

lao posted over 16 years ago in reply to [Infragistics] Helen Emerson

I have a DataSet object with two tables and I am sure the DataSet object have the proper relation of my tables.I bind UltraWebGrid to the ObjectDataSource object builded from the DataSet object and set the UltraWebGrid to hierarchical view. I can't get the second band working.

Any idea?

Thanks.
Cancel
Reply

Verify Answer

Cancel
1171

[Infragistics] Helen Emerson posted over 16 years ago in reply to elke

The grid won't automatically write the changes back to your dataset object after postback. The grid only uses the DataSource object when it is data binding and works disconnected from it for the rest of the time. The reason for this is that you get an entirely different Page object after postback so there's a good chance the DataSource object won't be around anymore.

If you're using a DataSet, the easiest way to get the grid to update your database is to connect the grid to the DataSet using an ObjectDataSource object. Then the grid will be able to automatically call the select, insert, update and delete methods from the table adapter associated with your dataset.

Alternatively, if you don't want to use an ObjectDataSource, the grid will fire events like AddRow and UpdateRow to let you know when the data has changed and you can write the changes back to your database yourself. There is some good information and examples showing how to do this in the knowledge base.
Cancel
Reply

Verify Answer

Cancel
459

elke posted over 16 years ago in reply to Andre Kraemer

i get an error now, but it's better than nothing.

i think i'll be able to solve the error.

thx heaps...
Cancel
Reply

Verify Answer

Cancel
1922

Andre Kraemer posted over 16 years ago

Hi Elke,

a dataset is disconnected from the database and will not automatically updated to the database. Instead you have to do it manually through a dataadapter.

So for example you would have to write

sqlDataAdapter1.Update(dsNetzwerk)
Cancel
Reply

Verify Answer

Cancel