473,407 Members | 2,314 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,407 software developers and data experts.

Datatable / Dataset Save

I have a Datatable/Dataset that I'd like to update back to the server. How do
I go about saving changes to my Datatable or Dataset back to the database?
Mar 23 '08 #1
5 1250
"Greg" <Ac**********@newsgroups.nospamschrieb
I have a Datatable/Dataset that I'd like to update back to the
server. How do I go about saving changes to my Datatable or Dataset
back to the database?

http://msdn2.microsoft.com/en-us/library/xzb1zw3x.aspx
Armin
Mar 23 '08 #2

By calling the table adapters update method

Michel

"Greg" <Ac**********@newsgroups.nospamschreef in bericht
news:98**********************************@microsof t.com...
>I have a Datatable/Dataset that I'd like to update back to the server. How
do
I go about saving changes to my Datatable or Dataset back to the database?

Mar 23 '08 #3
Are there any examples, showing the whole process, from creating the
DataAdapter, DataSet/DataTable and then updating it?

"Armin Zingler" wrote:
"Greg" <Ac**********@newsgroups.nospamschrieb
I have a Datatable/Dataset that I'd like to update back to the
server. How do I go about saving changes to my Datatable or Dataset
back to the database?


http://msdn2.microsoft.com/en-us/library/xzb1zw3x.aspx
Armin
Mar 24 '08 #4
This link shows a whole series of "walk throughs", which illustrate the main
building blocks of building a database app.

http://msdn2.microsoft.com/en-us/library/fxsa23t6.aspx
Greg wrote:
Are there any examples, showing the whole process, from creating the
DataAdapter, DataSet/DataTable and then updating it?

"Armin Zingler" wrote:
>"Greg" <Ac**********@newsgroups.nospamschrieb
>>I have a Datatable/Dataset that I'd like to update back to the
server. How do I go about saving changes to my Datatable or Dataset
back to the database?


http://msdn2.microsoft.com/en-us/library/xzb1zw3x.aspx
Armin

Mar 24 '08 #5
Hi Greg,

I have created a sample project that shows the whole solution for you and I
send it to your msn mailbox.

Before you run the sample application, please create a table in the
database. The table is named "Teacher" and contains four fields:

Column Name Data Type Allow Nulls
ID int no
Name varchar(50) yes
Age int yes
Address varchar(50) yes

If you have any question, please feel free to let me know.

Sincerely,
Linda Liu
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
ms****@microsoft.com.

This posting is provided "AS IS" with no warranties, and confers no rights.
Apr 1 '08 #6

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

Similar topics

1
by: Job Lot | last post by:
Is it possible to use Aggregate functions with GROUP BY Clauses on DataTable. I have a DataTable with following values: Date Amount Int Balance 1/1/2004 5000.00 50.00 5050.00...
3
by: Plumer | last post by:
Good morning everyone Using C# I create a bog-standard System.Data.DataTable which I then Add to a System.Data.Dataset (At the moment I'm in the guess-and-test phase so the table has only one...
8
by: Aleksey | last post by:
Hi! I need save data from DataTable to XML file. Is there any standard method do that? Thanks a lot
4
by: bijoy | last post by:
My page has a Listbox called Rooms, a text field called chairPerson and a button called Add. When Add is clicked, the script needs to display the selected info in a datagrid. For example, if...
6
by: Danny Ni | last post by:
Hi, If I want to programatically add rows to a DataTable, do I call AcceptChanges per row? Or do I call AcceptChanges after all rows added? TIA
3
by: stockblaster | last post by:
Hello all.. Is it possible to convert a DataTable (i create the DataTable from a CSV file) into binary data and save it into an sql 2005 table (into binary field). After that I want to...
9
by: Anil Gupte | last post by:
After reading a tutorial and fiddling, I finally got this to work. I can now put two tables created with a DataTable class into a DataRelation. Phew! And it works! Dim tblSliceInfo As New...
2
by: DubSport | last post by:
I have created a datatable in a function, and it is populated with data. I want to call a new function from an ASP button, and write out some of the values in the datatable, using: string...
7
by: =?Utf-8?B?QWxla3MgS2xleW4=?= | last post by:
I use in my asp.net code dataset and populate datatable using dataadapter. The problem is that my code demand huge amount of memory and I am looking for way reduce this demand. At this time I...
2
by: PulkitZery | last post by:
Hello, I am trying to create a Dataset and save it to an XML file. I have one column “JobID” for which I have set the autoincrement property to true. Here is the function that creates and save the...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
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,...
0
jinu1996
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...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
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...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.