473,320 Members | 1,976 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to Update Disconnected Dataset through Stored Procedure

Hi Guys,

i am beginer in the worls of Asp.net and C#.net
I have one problem that
I have stored my changes of data into dataset using
disconnected dataset and after completion of all changes i want to
update that change to the database using stored procedure.
But i am not getting How to do it,

So if anybody know the slution then please give me
Regards
Chandra Tiwari

Nov 24 '06 #1
2 8028
You need to send the changed DataSet into a DataAdapter that has the required
Update, Insert and Delete commands (they can be stored procedures) and then
call the Adapter's Update method.
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"chandu" wrote:
Hi Guys,

i am beginer in the worls of Asp.net and C#.net
I have one problem that
I have stored my changes of data into dataset using
disconnected dataset and after completion of all changes i want to
update that change to the database using stored procedure.
But i am not getting How to do it,

So if anybody know the slution then please give me
Regards
Chandra Tiwari

Nov 25 '06 #2
Sample code here....

SqlConnection connection = new SqlConnection(@"connection
String");
SqlDataAdapter dataAdpater = new SqlDataAdapter("Query",
connection);
DataSet dataset = new DataSet();

dataAdpater.Fill(dataset);

DataRow row = dataset.Tables["Table"].Rows[0];
row["Column"] = "new data";
dataAdpater.UpdateCommand.CommandType =
CommandType.StoredProcedure;
dataAdpater.UpdateCommand.CommandText = "StoredProcedure
name";

dataAdpater.Update();

Hope this is useful....

Thanks
-Srinivas,
chandu wrote:
Hi Guys,

i am beginer in the worls of Asp.net and C#.net
I have one problem that
I have stored my changes of data into dataset using
disconnected dataset and after completion of all changes i want to
update that change to the database using stored procedure.
But i am not getting How to do it,

So if anybody know the slution then please give me
Regards
Chandra Tiwari
Nov 27 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: jason | last post by:
Is there a way - possibly a disconnected rs? - to update the contents of an existing pulldown on a page without having to re-submit the page for the user to see the pulldown populated with an...
1
by: rawCoder | last post by:
Hi All Is there a way to Execute a query (possibly including two tables and joins) on a totally disconnected dataset. By 'Totally Disconnted' , I mean there is no DB and there is no DBConnection...
3
by: Simon | last post by:
Hi everyone, I have a small problem regarding a wizard that I'm making on my website. The wizard is obviously a series of pages that take values from the user. My question is: - Should I...
9
by: joun | last post by:
Hi all, i'm using this code to insert records into an Access table from asp.net, using a stored procedure, called qry_InsertData: PARAMETERS Long, Long, Text(20), Long, DateTime; INSERT...
9
by: Kevin Hodgson | last post by:
I'm experiencing a strange Dataset Update problem with my application. I have a dataset which has a table holding a set of customer information records. (address, contact, info, etc.) I have a...
3
by: dbuchanan | last post by:
Hello, (Windows forms - SQL Server) I fill my datagrid with a stored procedure that includes relationships to lookup tables so that users can see the values of the combobox selections rather...
30
by: Charles Law | last post by:
Here's one that should probably have the sub-heading "I'm sure I asked this once before, but ...". Two users are both looking at the same data, from a database. One user changes the data and...
8
by: Ornette | last post by:
Hello, I have a stored procedure which generates some values in the table. When I use update() how to populate the dataset with theses values ? For the moment I use output parameter but it...
5
by: Bogdan | last post by:
Hi, I have a stored procedure that uses JOINs to return columns from multiple tables. I also have another stored proc that that takes a series of params and updates multiple tables. I used the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.