DataGrids & SProcs

  • Thread starter Thread starter ALPO
  • Start date Start date
A

ALPO

We are thinking of using sprocs for all selects, insert,
updates, and deletes. So our process may be something as
the following:

1) Retrieve dataset and fill grid( maybe by adapter )
2) Make updates to locally cached recordset
3) Once user is happy with results on cached recordset
user applies update to database through stored proc

HOw can we accomplish this? Any good examples out there?
 
ADO.NET supports retrieving data from stored procedure
calls. ADO.NET also supports submitting pending changes from a
DataSet using stored procedures.

For information on using DataAdapters to submit changes, see
"Updating the Database with a DataAdapter and the DataSet" in the
..NET Framework SDK. The examples use standard SQL INSERT,
UPDATE, and DELETE queries, but you could replace these queries
with stored procedure calls.

I hope this information proves helpful.

David Sceppa
Microsoft
This posting is provided "AS IS" with no warranties,
and confers no rights. You assume all risk for your use.
© 2003 Microsoft Corporation. All rights reserved.
 
Hi,

You may consider investigating on SQLXML. It allows you
to retrieve a block of data, update it offline and send
it back into the database.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/sqlxml3/htm/updategram_2icv.asp

Diffgrams:

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/sqlxml3/htm/dotnet_990h.asp

Updategram:

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/sqlxml3/htm/updategram_2icv.asp

DISCLAIMER: This posting is provided "AS IS" with no
warranties, and confers no rights.
 
Back
Top