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. 3 1191
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.Data Source = Session["MyDataSet"];
MyDataGrid.Data Member = "MyDataTableNam e";
MyDataGrid.Data Bind();
HTH,
Axel Dahmen
-- www.sportbootcharter.com
-------------------------
"Random" <ci*******@hotm ail.com> schrieb im Newsbeitrag
news:ee******** ******@TK2MSFTN GP10.phx.gbl... 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.
David Sceppa's book on ADO.Net is a fantastic resource.
It explains all of this in great detail.
--
Joe Fallon
"Random" <ci*******@hotm ail.com> wrote in message
news:ee******** ******@TK2MSFTN GP10.phx.gbl... 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.
Thanks for the referral. I'll check it out.
"Joe Fallon" <jf******@nospa mtwcny.rr.com> wrote in message
news:up******** *****@TK2MSFTNG P11.phx.gbl... David Sceppa's book on ADO.Net is a fantastic resource. It explains all of this in great detail. -- Joe Fallon "Random" <ci*******@hotm ail.com> wrote in message news:ee******** ******@TK2MSFTN GP10.phx.gbl... 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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Vijay Balki |
last post by:
This might be a dumb question to ask. Can someone answer me with patience..
When I have a typed or un-typed dataset, the only way I can update is like
below?
Dim con As New SqlConnection(ConnectionString)
con.Open()
Dim daProductsDS As New SqlDataAdapter("Select * from ProductsDS", con)
Dim oCommandBuilder As New SqlCommandBuilder(daProductsDS)
|
by: PV |
last post by:
When performing a parent-child table updates using DataAdapters, the
updates have to be performed in at least two passes. The deletes must
be done child first, then parent. Conversely, the inserts must be done
parent first, then child. This is generally accomplished by using
DataSet.GetChanges(DataRowState.Deleted) and
DataSet.GetChanges(DataRowState.Inserted) respectively.
My question is: What is the best way after this to sync up...
|
by: Frnak McKenney |
last post by:
I'm using an in-core DataSet as an image of my application's
'database' (a multi-table Access97 mdb file). Updates are made to
the DataTables within the DataSet via forms with bound TextBoxes,
then written to the database... or at least that's what's supposed
to be happening.
Unfortunately, I've discovered that while it appears that when I
create a new record/row I'm successfully updating the Access
database, once the Update is...
|
by: suzy |
last post by:
hello.
how can i sort data in a dataset? all the examples i have seen on msdn, etc
are sorting a dataview. this works fine, but i want to return the results
in xml and the dataview doesn't have a .getxml method (unlike the dataset).
any ideas?
thanks.
|
by: JJ |
last post by:
Hi,
I have a DataSet that has no records in it from Database. I use this for
just collecting records that I have been working on. I have a new worker
dataset that goes out to database and gets a single record from database for
updates to existing record is necessay. Now I want to take the dataset that
has been updated and update the collection Dataset. Once everything is done I
send the whole thing at one time to database to do...
| |
by: Kenny |
last post by:
Hello all, I am wondering about the memory arrangement in C#.
If I am going to load, say, 20000 data rows from about 20 tables at once,
where will be the data stored in my machine? All save on RAM? Or a portion of
them is fetched to RAM for processing?
Thanks.
|
by: paul |
last post by:
Hi,
Im trying to add a dataset to the app_code directory using vs2005 \
SQL2005 beta 2. When I run through the wizard I select the option to
auto create new Stored Procedures (Select, update, delete, insert
commands) after already specifying a very basic select command that
consists of two fields.
All procedures are created fine and i'm able to save the xsd file.
Then I create a new gridview in which i use the xsd file object as my
|
by: Peter Proost |
last post by:
Hello group,
what would be the best way to do the next thing: I've got a grid form with
about 15000 records, when I double click a row a detail form is opened and
the user can modify and save the record, this all works just fine, then the
user closes the detail form and ofcourse I want to show his modifications in
the grid form, but now my question is what's the best way to do this without
completely reloading the dataset that holds the...
|
by: Jean Christophe Avard |
last post by:
Hi! I have a dataset that retreive all the item information from the
database. I need to be able to edit them, in the dataset and in the
database.
I have this code, could anyone tell me if I'm in the good way, cause I build
that code from a book example, but nothing works.
I HAVE THIS CODE TO SAVE THE CHANGE OF THE DATASET
dstPlant.Tables("plant").Rows(intEditRow)("latin_name") = "KLHJJKJKJKHHHHHH"
|
by: palgre |
last post by:
Hi ALL,
I am working in an windows based application using SQL Server 2000 as
database. There are few tables (refer parent tables) in the
application which are uploaded by a seprate application.
My application fetches data from parent tables and put data in
separate tables (chils tables) of application.
I am using dataset to fetch data from parent tables and insert/update
data in child table.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |