Dataset and datatables

Question

0.00/5 (No votes)

See more:

Hello all,

(I am a noob to c#)
reading from a .xml file
I need to get certain coloms from a data set into different tables.
splitting the file into 3 tables.
any ideas would help.

C#

DataSet mydata = new DataSet("mydata");
mydata.ReadXml("C:\\Program Files (x86)\\MaxID\\MaxID Fastskan Driver\\Data\\FastSkanDriver.xml");
dataGridView1.DataSource = mydata.Tables[0];

Say I have data "id number" "name" "address" "tel number" ect. but only want address and tel number in table 1 and name and address in table 2.

Posted 31-Oct-11 21:54pm

Nic'Kemp

Updated 31-Oct-11 22:02pm

RaisKazi

v3

Add a Solution

Comments

RaisKazi 1-Nov-11 3:57am

Your Question is unclear. Please elaborate.

Nic'Kemp 1-Nov-11 4:06am

say i have 10 coloms of data that need to be split into two tables
datset name surname adress telnumber idnumber

i want to split maybe name and adress into table1
and name and idnumber into table2

CodingLover 1-Nov-11 4:01am

Break down your question into simple steps, if you are not clear with the complete. Then address a step at a time. If you could explain each step clearly we can comment easily.

Nic'Kemp 1-Nov-11 4:18am

say i have 10 coloms of data that need to be split into two tables datset name surname adress telnumber idnumber i want to split maybe name and adress into table1 and name and idnumber into table2

2 solutions

Solution 1

You could read the XML file 'manually' and transfer each item into the appropriate dataset which you can then bind to the relevant datagrid. Alternatively you could take your dataset as created above and manually copy columns of data from that into other datasets. In either case it requires a bit of work.

Posted 31-Oct-11 23:09pm

Richard MacCutchan

Comments

Nic'Kemp 1-Nov-11 5:13am

How would i go about copying data manualy from the dataset to other datasets

Richard MacCutchan 1-Nov-11 5:29am

Well I would start at the documentation and see what functions are available to extract columns or cells and copy them to columns or cells elsewhere, and use that information to copy them to another dataset.

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)

RaisKazi · Accepted Answer · 2011-10-31T23:38:00

Solution 2

Try as below code.

C#

DataSet mydata = new DataSet("mydata");
mydata.ReadXml("YourXmlFilePath");

DataTable firstDataTable = new DataTable();
DataTable secondDataTable = new DataTable();

if (mydata.Tables.Count > 0)
{
  firstDataTable = mydata.Tables[0].Copy();
  secondDataTable = mydata.Tables[0].Copy();

  //Remove columns from the first DataTable which you want to remove.
  firstDataTable.Columns.Remove("ColumnNameToRemove1");

  //Remove columns from the second DataTable which you want to remove.
  secondDataTable.Columns.Remove("ColumnNameToRemove2");
}

Posted 31-Oct-11 23:38pm

RaisKazi

Comments

BobJanova 1-Nov-11 6:46am

Good, although if it is a large data set it would make more sense to do everything on the first table then everything on the second so you don't have three copies at once (or just use Tables[0] as one of the tables directly).

RaisKazi 1-Nov-11 6:49am

Thank you Bob. :)

Nic'Kemp 1-Nov-11 10:02am

Thank you RaisKasi
do I then just put the datatables back into datasets to gridview them?

RaisKazi 1-Nov-11 10:05am

You are welcome. :)
No need to do that, Just assign DataTable to your GridView as below.
dataGridView1.DataSource = firstDataTable;

Nic'Kemp 1-Nov-11 10:32am

Thank you you have been a great help!!!!!!!

Nic'Kemp 1-Nov-11 13:40pm

How would i remove rows that meet certain criteria in a column ???

Nic'Kemp 1-Nov-11 15:47pm

for (int i = dt.Rows.Count-1; i >= 0; i--)

{

// whatever your criteria is

if (dt.Rows[i]["mycolumn"].ToString() == "")

dt.Rows[i].Delete();

}

RaisKazi 2-Nov-11 3:20am

This should work.