Adding Datatable to an existing Dataset

Question

5.00/5 (1 vote)

See more:

Dear Friends,

I have a dataset in which there are multiple tables for e.g. at index 0,1,2.

I want to filter the table data at index 1, which i am doing and after the method (which returns the filtered datatable) returns the datatable..I want to add it to my existing dataset at index 1 only.

I am not able to do that.

Kindly help.

Thanks

Varun Sareen

Posted 15-Mar-11 1:09am

Varun Sareen

Add a Solution

Comments

Sunasara Imdadhusen 15-Mar-11 7:13am

You can access it by Name!!

Varun Sareen 15-Mar-11 7:39am

thanks :)

2 solutions

Solution 1

ADO.NET enables you to create DataTable objects and add them to an existing DataSet. You can set constraint information for a DataTable by using the PrimaryKey and Unique properties.

For more information check this

http://msdn.microsoft.com/en-us/library/aeskbwf7%28v=vs.80%29.aspx[^]

Posted 15-Mar-11 1:25am

demouser743

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)

avigodse · Accepted Answer · 2011-03-15T01:38:00

//<summary>
       /// Routine to filter first table and replace exiting table with filtered records.
       // </summary>
       // <param name="sourceSet">Dataset instance to be manipulated</param>\n
      private void _FilterAndInsert(DataSet sourceSet)
       {
           ///Apply your filter clauses in Select() function parameter
           DataRow[] rows = sourceSet.Tables[0].Select("filter clauses here...");
           ///Get the structure of source table
           DataTable tempTable = sourceSet.Tables[0].Clone();
           ///Add the filtered rows in temp table
           foreach (DataRow row in rows)
           {
               tempTable.Rows.Add(row.ItemArray);
           }
           tempTable.AcceptChanges();
           ///Create new dataset
           DataSet resultSet = new DataSet();
           ///Add temp table at first index or modify this code sequence as you require
           resultSet.Tables.Add(tempTable);
           for (int index = 1; index < sourceSet.Tables.Count; index++)
           {
               ///Set the copy of source table in local instance
               DataTable tableToAdd = sourceSet.Tables[index].Copy();
               ///Remove from source to avoid any exceptions
               sourceSet.Tables.RemoveAt(index);
               ///Add the copy to result set
               resultSet.Tables.Add(tableToAdd);
           }
           ///Set the copy to source table from result set
           sourceSet = resultSet.Copy();
       }