DataSet updates

  • Thread starter Thread starter Random
  • Start date Start date
R

Random

What I want to do is to carry a DataSet through a multi-page process. Each
page will have an interface for updating and/or inserting records in
individual DataTables. At the end of the process, I will submit the entire
DataSet (through DataAdapters) back to the database.

Filling the DataSet schema seems simple enough. Binding controls to the
DataTables/DataViews is fine as well. But I am coming up woefully short on
resources to instruct me on how to update the in-memory DataSet when edits
are made, and how the DataSet processes multiple records on the database
when it's Update method is called.
 
You sure already know that HTTP is a stateless protocol. So I guess you're
saving your DataSet into a Session variable.

You can bind your asp:Repeater, asp:DataGrid etc. controls in the Page_Load
event:

MyDataGrid.DataSource = Session["MyDataSet"];
MyDataGrid.DataMember = "MyDataTableName";
MyDataGrid.DataBind();

HTH,
Axel Dahmen
 
David Sceppa's book on ADO.Net is a fantastic resource.
It explains all of this in great detail.
 
Back
Top