Error: DataTable already belongs to this DataSet.

Question

question

BenTam-3003 asked Apr 21, '22 karenpayneoregon commented Apr 23, '22

Error: DataTable already belongs to this DataSet.

Dear All,

The red ellipse line causes an error "Datatable already belongs to this DataSet." How to fix it?

dotnet-csharp

error.gif (38.6 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-21T09:42:05.397Z

karenpayneoregon answered Apr 21, '22 karenpayneoregon commented Apr 23, '22

You will need to make a copy of that table via DataTable.Copy. Once done, use the copy.

· 13

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BenTam-3003 · Apr 21 at 01:49 PM

Hi @karenpayneoregon

How to make a copy? I tried the following syntax. However, "Copy" is redlined. Please help!

0 ·

error.gif (7.2 KiB)

karenpayneoregon BenTam-3003 · Apr 21 at 01:54 PM

Greetings, Copy is a method so use Copy()

0 ·

BenTam-3003 karenpayneoregon · Apr 21 at 02:08 PM

Hi @karenpayneoregon

After adding a pair of brackets, it is still redlined.

0 ·

error.gif (5.4 KiB)

Show more comments

karenpayneoregon BenTam-3003 · Apr 21 at 02:35 PM

Here is how to use Copy

 DataSet ds = new DataSet();
 DataView dv = new DataView();
 dv = ds.Tables["StudentList_Table"].DefaultView;
    
 DataTable dataTable = dv.Table;
 DataTable copyTable = dataTable.Copy();
 ds.Clear();
    
 var count = copyTable.Rows.Count;
 Console.WriteLine(count);

0 ·

f1.png (31.7 KiB)

BenTam-3003 karenpayneoregon · Apr 21 at 03:10 PM

Dear @karenpayneoregon

After copying your code, the redline disappears. However, after pressing the down arrow, the following error still appears.

  A DataTable named 'StudentList_table' already belongs to this DataSet.

0 ·

error.gif (18.6 KiB)

Show more comments

question