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
2  8053 
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
Sample code here....
SqlConnection connection = new SqlConnection(@ "connection
String");
SqlDataAdapter dataAdpater = new SqlDataAdapter( "Query",
connection);
DataSet dataset = new DataSet();
dataAdpater.Fil l(dataset);
DataRow row = dataset.Tables["Table"].Rows[0];
row["Column"] = "new data";
dataAdpater.Upd ateCommand.Comm andType =
CommandType.Sto redProcedure;
dataAdpater.Upd ateCommand.Comm andText = "StoredProcedur e
name";
dataAdpater.Upd ate();
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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 additional value?
I realise there are javascript possibilities (and I am still searching for a
usable one) but I thought perhaps it may be possible to allow a user to add
a new entry to a drop down box that had been dynamically populated from an...
|
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
/ DBCommand - all the data and structure is in memory.
The query is to be used to databind a grid, so some sort of view is needed
( i.e. its not a one time query ).
Its like having a mini in-memory DB on the client side and looking for a way
|
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 store all the values entered until the last page and then update
the database, or should I do it as I go.
|
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 INTO Table ( ID, Cod, CodArt, Q1, DataUscita )
VALUES (pID, pCod, pCod, pQ1, pDataUscita);
|
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 series of ComboBoxes (Client Number for selection), and text fields
to show the other data bound to this Dataset.table
If I change a value for the first client in the list, and press my update
client button, the data is successfully updated to the...
| | |
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 than the key value that are stored in the table.
It works well if the comboboxes are selected when the row is created.
|
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 commits it. How does the other user get the updated
view without polling for changes? Is there some sort of callback mechanism
that can be set up on the dataset or connection?
TIA
|
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 just works for 1 row and as the
dataset doesn't have the value I should put it after and the rowstate goes
to "modified"...
Any ideas ?
|
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 framework to auto-generate a table
adapter specifying both stored procs as Get/Fill and Update. The problem is
that columns from the JOINed table seem to marked as 'read-only' so trying
to update a row results in an exception. BTW, by default a...
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
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: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
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...
| |
