Elke
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)
i get an error now, but it's better than nothing.
i think i'll be able to solve the error.
thx heaps...
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.
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.