Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
|
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 3rd, 2006, 02:17 AM
Registered User
 
Join Date: Feb 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default How to update diffgram through stored procedure

I have a windows application (using Windows forms, C#) that uses SQL2005 as database server. I am using a typed dataset in my app that will be filled with data from corresponding table in my database. Now I need to update my database table with the changes made at the client side dataset. I am creating a Diffgram from the Dataset and I want to use this to update the table in database. I have to pass this Diffgram as a parameter to a stored procedure that would in turn use this modified data to update the table. How do I achieve this? The Diffgram is necessary as I am using .net remoting for connecting to the remote server.
Can anyone provide me with some sample code to get this right?

Thanks in advance

Raj Jr.

Raj Jr.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Stored procedure - batch update timeware SQL Server ASP 2 December 12th, 2007 04:13 PM
Executing an UPDATE Stored Procedure ashg657 Access VBA 1 June 9th, 2006 06:29 AM
ADP Update Stored Procedure ashg657 Access 0 June 2nd, 2006 05:29 AM
Update Tables in Stored Procedure Talsiter SQL Server 2005 1 April 10th, 2006 03:32 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.