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