How to Add multiple datatables to existing dataset

Question

0.00/5 (No votes)

See more:

Dear Friends,

I have below code, where in I am creating a dataset based on a query to Oracle mdb.

C#

....
      OracleDataAdapter adapter = new OracleDataAdapter(sqlstr, conn);
       OracleCommandBuilder builder = new OracleCommandBuilder(adapter);
       DataSet dataset = new DataSet();
       adapter.Fill(dataset);

       DataTable dataTable = dataset.Tables[0];
....

I would like to have the highlighted code in a loop, and then add the dataset objects to a common datatable outside the loop.

How can this be implemented?

Thanks

Posted 1-May-14 23:50pm

srinivasmn

Updated 1-May-14 23:51pm

Thanks7872

v2

Add a Solution

Comments

[no name] 5-May-14 6:17am

http://msdn.microsoft.com/en-us/library/aeskbwf7(v=vs.110).aspx

[no name] 5-May-14 6:17am

http://www.codeproject.com/Questions/168959/Adding-Datatable-to-an-existing-Dataset

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ravikhoda · Answer 1 · 2014-05-02T00:04:00

Solution 1

well you can simply add the datatables to dataset by usign below method

C#

ds.tables.add(dt);

add some for loop if you want to add multiple datatables to your dataset.

Posted 2-May-14 0:04am

ravikhoda

Comments

agent_kruger 30-May-14 10:09am

+5 sir, simple solution (not my question).

Bhushan Gogia · Answer 2 · 2014-06-01T22:49:00

Solution 6

DataSet ds = new DataSet();
        DataTable dt = new DataTable();
        ds.Merge(dt);

Posted 1-Jun-14 22:49pm

Bhushan Gogia

frostcox · Answer 3 · 2014-05-02T13:18:00

Ok to add datatables to a dataset you first need to declare you dataset outside your loop. Otherwise you are creating your dateset everytime you loop so you are always only gonna have one value.
So code would look like

DataSet dsCompleteDataSet = new DataSet();

//Loop
for(int i = 0; i < counter; i++)
{
  OracleDataAdapter adapter = new OracleDataAdapter(sqlstr, conn);
       OracleCommandBuilder builder = new OracleCommandBuilder(adapter);
       DataSet dataset = new DataSet();
       adapter.Fill(dataset);
      dsCompleteDataSet.Tables.Add(dataset.Tables[0]);
}

Hope that helps.

**Dnyaneshwar**@Pune · Answer 4 · 2014-05-05T00:18:00

Solution 4

Refer
Adding Datatable to an existing Dataset[^]

Posted 5-May-14 0:18am

Dnyaneshwar@Pune