Hi
I have a sub method that has been passed a dataset as parameter. I need to
insert this dataset into a table. What is the code that I need to do this?
The dataset does not have any conflicting keys so it is a very easy scenario
from conflict resolution point of view.
Thanks
Regards 8 1151
John,
I assume that you don't confuse alone me.
A dataset is a kind of wrapper around datatables which holds datarows.
In what kind of table do you want to put the dataset?
Cor
Just a normal sql server table.
Thanks
Regards
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:eT******** ******@TK2MSFTN GP11.phx.gbl... John,
I assume that you don't confuse alone me.
A dataset is a kind of wrapper around datatables which holds datarows.
In what kind of table do you want to put the dataset?
Cor
John,
Than you mean probably the datatable of the dataset.
Is that in an existing table with the same description or do you want to
store a datatable as a complete new datatable.
In other words do you want to use the description of the dataset/datatable
to create new table(s) in your server?
Cor
No, the dataset comes from a table which is identical in structure to the
destination table. I only need the current data in the dataset (datatable?)
to be inserted in the destination table.
Thanks
Regards
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:e$******** ******@TK2MSFTN GP12.phx.gbl... John,
Than you mean probably the datatable of the dataset. Is that in an existing table with the same description or do you want to store a datatable as a complete new datatable.
In other words do you want to use the description of the dataset/datatable to create new table(s) in your server?
Cor
Cor,
I think his scenario is that he gets a dataset with one datatable in it,
with a bunch of rows. He then wants to insert these rows into the database.
I already told him in another thread, that this question has been asked many
many times, and that he should search old postings as well as do research on
the internet on how to do this. But he just wants us to do it all for him?
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message
news:e$******** ******@TK2MSFTN GP12.phx.gbl... John,
Than you mean probably the datatable of the dataset. Is that in an existing table with the same description or do you want to store a datatable as a complete new datatable.
In other words do you want to use the description of the dataset/datatable to create new table(s) in your server?
Cor
Saying how to insert the dataset is doing it all for me? Hardly. Its easy to
search for broad topics in Google but specifics are hard to find specially
when almost everything in net has million variations.
Regards
"Marina" <so*****@nospam .com> wrote in message
news:O7******** ******@TK2MSFTN GP15.phx.gbl... Cor,
I think his scenario is that he gets a dataset with one datatable in it, with a bunch of rows. He then wants to insert these rows into the database.
I already told him in another thread, that this question has been asked many many times, and that he should search old postings as well as do research on the internet on how to do this. But he just wants us to do it all for him?
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message news:e$******** ******@TK2MSFTN GP12.phx.gbl... John,
Than you mean probably the datatable of the dataset. Is that in an existing table with the same description or do you want to store a datatable as a complete new datatable.
In other words do you want to use the description of the dataset/datatable to create new table(s) in your server?
Cor
Are you saying you have found nothing on this topic? This is not all that a
specific thing, it's pretty basic.
Have you tried writing anything to do this? Have you tried actually finding
information?
Have you been reading about how datasets work? Looking at examples that use
dataset to do various operations? Reading documentation?
I suspect that if you had been, you would have had a more specific question
then 'how do move data into a database'. I can't even imagine what sort of
answer you expected - code that is ready to go and working? It's not as if
there is one subtle aspect of this that is causing you problems - you sort
of want the whole thing.
It's not as if you are going to find something that 100% is your situation.
But you will find something close. You will find articles that teach you
about how to use these objects, and you will start to experiment and try
writing code, and learn that way.
I put the following search terms into google: insert rows dataset database
I got the following hits just on the first page of the results that talk
about various techniques for moving data from a dataset into the database,
as well as the ADO.NET object model. http://samples.gotdotnet.com/quickst...ataFromDB.aspx http://msdn.microsoft.com/library/de...terdataset.asp http://www.akadia.com/services/dotnet_update_form.html
I think with a little bit of effort you could have found this, and much more
as well.
"John" <Jo**@nospam.in fovis.co.uk> wrote in message
news:%2******** **********@TK2M SFTNGP15.phx.gb l... Saying how to insert the dataset is doing it all for me? Hardly. Its easy to search for broad topics in Google but specifics are hard to find specially when almost everything in net has million variations.
Regards
"Marina" <so*****@nospam .com> wrote in message news:O7******** ******@TK2MSFTN GP15.phx.gbl... Cor,
I think his scenario is that he gets a dataset with one datatable in it, with a bunch of rows. He then wants to insert these rows into the database.
I already told him in another thread, that this question has been asked many many times, and that he should search old postings as well as do research on the internet on how to do this. But he just wants us to do it all for him?
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message news:e$******** ******@TK2MSFTN GP12.phx.gbl... John,
Than you mean probably the datatable of the dataset. Is that in an existing table with the same description or do you want to store a datatable as a complete new datatable.
In other words do you want to use the description of the dataset/datatable to create new table(s) in your server?
Cor
Sheer amount of information retrieved and the need to look for the specific
point in the code haystack proves my point but hey I am not complaining...
"Marina" <so*****@nospam .com> wrote in message
news:Ok******** ********@TK2MSF TNGP10.phx.gbl. .. Are you saying you have found nothing on this topic? This is not all that a specific thing, it's pretty basic.
Have you tried writing anything to do this? Have you tried actually finding information?
Have you been reading about how datasets work? Looking at examples that use dataset to do various operations? Reading documentation?
I suspect that if you had been, you would have had a more specific question then 'how do move data into a database'. I can't even imagine what sort of answer you expected - code that is ready to go and working? It's not as if there is one subtle aspect of this that is causing you problems - you sort of want the whole thing.
It's not as if you are going to find something that 100% is your situation. But you will find something close. You will find articles that teach you about how to use these objects, and you will start to experiment and try writing code, and learn that way.
I put the following search terms into google: insert rows dataset database
I got the following hits just on the first page of the results that talk about various techniques for moving data from a dataset into the database, as well as the ADO.NET object model.
http://samples.gotdotnet.com/quickst...ataFromDB.aspx http://msdn.microsoft.com/library/de...terdataset.asp http://www.akadia.com/services/dotnet_update_form.html
I think with a little bit of effort you could have found this, and much more as well.
"John" <Jo**@nospam.in fovis.co.uk> wrote in message news:%2******** **********@TK2M SFTNGP15.phx.gb l... Saying how to insert the dataset is doing it all for me? Hardly. Its easy to search for broad topics in Google but specifics are hard to find specially when almost everything in net has million variations.
Regards
"Marina" <so*****@nospam .com> wrote in message news:O7******** ******@TK2MSFTN GP15.phx.gbl... Cor,
I think his scenario is that he gets a dataset with one datatable in it, with a bunch of rows. He then wants to insert these rows into the database.
I already told him in another thread, that this question has been asked many many times, and that he should search old postings as well as do research on the internet on how to do this. But he just wants us to do it all for him?
"Cor Ligthert [MVP]" <no************ @planet.nl> wrote in message news:e$******** ******@TK2MSFTN GP12.phx.gbl... John,
Than you mean probably the datatable of the dataset. Is that in an existing table with the same description or do you want to store a datatable as a complete new datatable.
In other words do you want to use the description of the dataset/datatable to create new table(s) in your server?
Cor
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: theWizK |
last post by:
Hello all.
I have noticed that when I generate a strongly-typed dataset from an xml
schema that the DataTables that are generated have their constructors marked
as internal. What this means is when I try to instantiate one of the
strongly-typed tables from this dataset from a different assembly, I cannot.
Let me provide examples...
If I have a simple dataset like this:
|
by: Bill C. |
last post by:
Hi,
I've got a simple console app that just reads an XML file into a DataSet
then prints out a description of each table in the DataSet, including
column names and row values for each column. I'm getting some strange
results depending the input XML file I use. I was wondering if somebody
could help me understand what is going on or point me to a good reference.
The code for my program looks like this:
|
by: Adie |
last post by:
Hi, is this not possible?
public DataSet getDimensions()
{
}
public SqlDataReader getDimensions()
{
}
|
by: Sharon |
last post by:
I have successfully loaded a DataSet object with a XML schema (XSD).
Now I wish to populate the tables that was created in the DataSet.
I have an XML file/string that contain all the needed data in the same
format as the XSD (the XML file/string was created using this same schema).
The XML file/string may contain data for a single table or for several
tables at once.
The question is:
|
by: JIM.H. |
last post by:
Hello,
Can I send a dataset as a parameter into stored procedure and import data to
a table in the stored procedure?
Thanks,
Jim.
| |
by: Roy Lawson |
last post by:
I am having no problems connecting to a DB, creating a DataAdapter,
and creating a dataset...and connecting to the data. Using the
builtin data objects to do all this.
My only problem now is navigating through the data. I can get the
data into a datagrid without any problems, but I want the data to show
up in textboxes and use some sort of move next, move previous, move
last, etc (like in VB6) command to navigate the data (using...
|
by: EMW |
last post by:
Hi,
I managed to create a SQL server database and a table in it. The table is
empty and that brings me to my next chalenge:
How can I get the info in the table in the dataset to go in an empty SQL
table?
Is there a short way like the FILL method to get data into the dataset or do
I have to read each datarow in the table and write it one at the time to the
|
by: Geoff Jones |
last post by:
Hi
Can anybody help me with the following, hopefully simple, question?
I have a table which I've connected to a dataset. I wish to add a new column
to the beginning of the table
and to fill it with incremental values e.g. if the tables looks
like this:
23 56
|
by: P K |
last post by:
Hello,
I have a dataset which is already loaded with data in one table.
so dataset.tables("data") exists and has data.
Now, I have to add another table to the dataset. The source for this table
is a XMLDoc. So I have the XML in a XMLDoc and I need to create a table in
the dataset which would read xml from the XMLDoc .
So in essence I need something like
|
by: codefragment |
last post by:
Hi
I have a dataset which holds (amongest other things) a string.
- The dataset gets loaded from the database via a middle tier
- The string value contains "\r\n"
- Its serialised to the web application
- The web application deletes the row. I can see using the below that
before and after the delete the
string value is what it should be
(string)rows;
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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: 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: 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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: 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...
| |