DataTable Already Belongs to another dataset

Question

1.00/5 (1 vote)

See more:

C#

After adding a datatable to a dataset, can i disconnect that datatable from dataset?

Posted 26-Aug-11 19:01pm

RAJI @Codeproject

Updated 5-Oct-17 20:43pm

Add a Solution

9 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)

Abhinav S · Answer 1 · 2011-08-26T19:44:00

Solution 1

The best bet would be to try this out yourself.
Use the Fill method to fill a dataset with a datatable and then clear the datatable and see what happens.

Posted 26-Aug-11 19:44pm

Abhinav S

Updated 26-Aug-11 19:45pm

v2

josephbhaskar · Answer 2 · 2013-07-11T19:41:00

Solution 4

try this...
http://msdn.microsoft.com/en-us/library/sdc233k4.aspx[^]

Posted 11-Jul-13 19:41pm

josephbhaskar

Karthik J, Coimbatore · Answer 3 · 2013-07-11T21:38:00

Solution 6

Hi, try this

C#

DatasetName.Tables.Remove(DataTableName);

Posted 11-Jul-13 21:38pm

Karthik J, Coimbatore

RaisKazi · Answer 4 · 2011-08-26T22:03:00

Solution 2

Without looking at code, it's difficult to provide exact solution.

I searched exact text of your Question on Google and no wonder found so many links.

Google Search[^]

Posted 26-Aug-11 22:03pm

RaisKazi

berrymaria · Answer 5 · 2013-07-11T20:56:00

Solution 5

VB

dtCopy = dataTable.Copy()
ds.Tables.Add(dtCopy)

http://stackoverflow.com/questions/8830901/datatable-already-belongs-to-another-dataset[^]

Posted 11-Jul-13 20:56pm

berrymaria

User 8696850 · Answer 6 · 2013-07-11T21:50:00

Solution 7

try :

Datasetname.Tables.clear()

Posted 11-Jul-13 21:50pm

User 8696850

poiuytrewq12349876543 · Answer 7 · 2013-07-11T22:35:00

Solution 8

if you know the index value of table
dst.Tables.RemoveAt()

if you know the table name then
dst.Tables.Remove("TableName")

Posted 11-Jul-13 22:35pm

poiuytrewq12349876543

code.dineshgupta · Answer 8 · 2014-02-20T05:49:00

Solution 9

use table.copy() method

It will work :)

Posted 20-Feb-14 5:49am

code.dineshgupta

Comments

Richard MacCutchan 20-Feb-14 12:45pm

This question is more than two years old. Please don't do this.

Shailesh g 9-Dec-14 2:16am

table.copy() is the best way to get rid of this. This is not compulsory that same datatable is beeing used. Sometimes it happens when we modify the same datatable and same we are trying to add in any dataset.

Nilesh D Sonpasare · Answer 9 · 2014-05-18T19:47:00

Solution 10

//add not scanned data into dataset
DataSet ds = new DataSet();
dtdetails.TableName = "Table1";
dtnotscanDetails.TableName = "Table2";
ds.Tables.AddRange(new DataTable[] {dtdetails.Copy(),dtnotscanDetails.Copy() });

Posted 18-May-14 19:47pm

Nilesh D Sonpasare

Comments

CHill60 20-May-14 6:40am

Doesn't add anything to other solutions added much earlier - post is nearly 3 years old!