CODEWITHSUNDEEP
c#.netado.netdataset
Manikandan Sigamani
Manikandan Sigamani

Reputation: 1984

adding a datatable in a dataset

I'm adding a datatable to a dataset like this:

DataTable dtImage = new DataTable();
//some updates in the Datatable
ds.Tables.Add(dtImage);

But the next time, when the datatable gets updated, will it be reflected in the dataset? or we need to write some code to make it reflected?

Also, I'm checking the dataset if the datatable exists in the dataset already using:

if(!ds.Tables.Contains("dtImage"))
    ds.Tables.Add(dtImage);

In the first iteration, ds.Tables.Contains("dtImage") is false, so, ds.Tables.Add(dtImage) adds the table to the dataset. But in the second iteration, ds.Tables.Contains("dtImage") is false again, but ds.Tables.Add(dtImage) throws an error:

Datatable already belongs to this dataset.

If the dataset doesn't contain the datatable named "dtImage", why is it throwing an error?

Update: Thanks, that issue got solved. Pls answer this:

But the next time, when the datatable gets updated, will it be reflected in the dataset? or we need to write some code to make it reflected?

Upvotes: 15

Views: 138381

Answers (4)

Ata Hoseini
Ata Hoseini

Reputation: 137

DataSet ds = new DataSet();

DataTable activity = DTsetgvActivity.Copy();
activity.TableName = "activity";
ds.Tables.Add(activity);

DataTable Honer = DTsetgvHoner.Copy();
Honer.TableName = "Honer";
ds.Tables.Add(Honer);

DataTable Property = DTsetgvProperty.Copy();
Property.TableName = "Property";
ds.Tables.Add(Property);


DataTable Income = DTsetgvIncome.Copy();
Income.TableName = "Income";
ds.Tables.Add(Income);

DataTable Dependant = DTsetgvDependant.Copy();
Dependant.TableName = "Dependant";
ds.Tables.Add(Dependant);

DataTable Insurance = DTsetgvInsurance.Copy();
Insurance.TableName = "Insurance";
ds.Tables.Add(Insurance);

DataTable Sacrifice = DTsetgvSacrifice.Copy();
Sacrifice.TableName = "Sacrifice";
ds.Tables.Add(Sacrifice);

DataTable Request = DTsetgvRequest.Copy();
Request.TableName = "Request";
ds.Tables.Add(Request);

DataTable Branchs = DTsetgvBranchs.Copy();
Branchs.TableName = "Branchs";
ds.Tables.Add(Branchs);

Upvotes: 0

Himanshu Shukla
Himanshu Shukla

Reputation: 145

Just give any name to the DataTable Like:

DataTable dt = new DataTable();
dt = SecondDataTable.Copy();    
dt .TableName = "New Name";
DataSet.Tables.Add(dt );

Upvotes: 6

Hassan Boutougha
Hassan Boutougha

Reputation: 3929

you have to set the tableName you want to your dtimage that is for instance

dtImage.TableName="mydtimage";


if(!ds.Tables.Contains(dtImage.TableName))
        ds.Tables.Add(dtImage);

it will be reflected in dataset because dataset is a container of your datatable dtimage and you have a reference on your dtimage

Upvotes: 6

Tim Schmelter
Tim Schmelter

Reputation: 460018

I assume that you haven't set the TableName property of the DataTable, for example via constructor:

var tbl = new DataTable("dtImage");

If you don't provide a name, it will be automatically created with "Table1", the next table will get "Table2" and so on.

Then the solution would be to provide the TableName and then check with Contains(nameOfTable).

To clarify it: You'll get an ArgumentException if that DataTable already belongs to the DataSet (the same reference). You'll get a DuplicateNameException if there's already a DataTable in the DataSet with the same name(not case-sensitive).

http://msdn.microsoft.com/en-us/library/as4zy2kc.aspx

Upvotes: 14

Related Questions