how to represent data from datatable in xml format.

Question

0.00/5 (No votes)

See more:

I have a data in my datatable which i want in xml format.I have no idea where to start with.Any help is appreaciated.Below is the code where i get the data from my datatable.Please help me out with some good links or suggestions.

string querystring = Request.QueryString["Userid"];


DataTable dtfrnameid = new DataTable();
connfordata.Open();
SqlCommand cmdfrnameid = new SqlCommand("select s000_UserId from s000_users where (s000_firstname+s000_lastname) = '" + querystring + "'", connfordata);
SqlDataAdapter dafrnameid = new SqlDataAdapter(cmdfrnameid);
dafrnameid.Fill(dtfrnameid);
connfordata.Close();

string id = dtfrnameid.Rows[0][0].ToString();



lblfrogridview.Text = "";
string weekending = gvweeklysum.Rows[rindex].Cells[1].Text;
DateTime getweekending = Convert.ToDateTime(weekending);
DateTime dtmonday = getweekending.AddDays(-4);
DateTime castdttime = dtmonday.AddHours(12);
var monday = castdttime.Date.ToString("yyyy-MM-dd 12:mm:ss");

DataTable dtfrmonday = new DataTable();
connfordata.Open();
SqlCommand cmdfrmonday = new SqlCommand("SRTSWeeklySummaryWednesday", connfordata);
SqlDataAdapter dafrmonday = new SqlDataAdapter(cmdfrmonday);
cmdfrmonday.CommandType = CommandType.StoredProcedure;
cmdfrmonday.Parameters.Add(new SqlParameter("@createddate", SqlDbType.DateTime)).Value = monday;
cmdfrmonday.Parameters.Add(new SqlParameter("@userid", SqlDbType.Int)).Value = id;

dafrmonday.Fill(dtfrmonday);
connfordata.Close();

Posted 29-Jul-13 13:57pm

Amit Karyekar

Add a Solution

Comments

berrymaria 29-Jul-13 20:20pm

Do you mean Reading XML Data into a DataTable?

Amit Karyekar 29-Jul-13 20:24pm

I mean getting my datatable data into xml for example my datatable is having having col. name and age having a row (mango,1).So it should give result.
name mango /name
age 1 /age

berrymaria 29-Jul-13 21:34pm

Ahh, okay. I didn't get any notifications. You didn't reply on my comment. See my answer below. It might help you. :)

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

Winston Madiano · Answer 1 · 2013-07-29T14:46:00

Solution 3

try WriteXml Method

C#

/*Export datatable to xml */
dtfrmonday.TableName = "MyTable";
dtfrmonday.WriteXml("Path\FileName.xml", XmlWriteMode.WriteSchema);

/*Import xml to datatable */
dtfrmonday.TableName = "MyTable";
dtfrmonday.ReadXml("Path\FileName.xml");

Posted 29-Jul-13 14:46pm

Winston Madiano

ExcelledProducts CEO · Answer 2 · 2013-07-29T14:40:00

Solution 2

I suggest you take a look at the XML classes. You will need to do most of it yourself but once you have the data it is just a matter of writing the XML file.

Click Here[^] for a good simple tutorial on creating an XML once you have the data.

Posted 29-Jul-13 14:40pm

ExcelledProducts CEO

berrymaria · Answer 3 · 2013-07-29T15:33:00

Solution 4

See this link:

DataTable.WriteXml Method[^]

Hope it helps! :)

Posted 29-Jul-13 15:33pm

berrymaria