send data to a special xml schema in asp.net

Question

0.00/5 (No votes)

See more:

Hi every body;

my XML Schema is like this :

XML

<?xml version="1.0" encoding="UTF-8"?>
<Letter xmlns="http://www.irica.com/ECE/1383-12/SendSchema">
  <Protocol Name="ECE" Version="1.01"/>
<Software SoftwareDeveloper="data from sql" Version="3.0" GUID="A62E7B29-3AE3-4E13-B15E-5E7E10247726" />
  <Sender Organization="data from sql" Code="A62E7B29-3AE3-4E13-B15E-5E7E10247726" Department="" Position="" Name=""/>
  <Receiver Organization="data from sql" Code="100003083" ReceiveType="Origin" Department="" Position="" Name=""/>
  <LetterNo>data from sql</LetterNo>
  <LetterDateTime ShowAs="gregorian">2010-01-18T08:21:40.0000000+03:30</LetterDateTime>
  <Subject>data from sql</Subject>
  <Priority Name="عادي" Code="1"/>

and I have these data for ex:

CSS

Software
SoftwareDeveloper:"";
Version:"";
.
Sender
Organization="";
.
.
LetterNo="":

how can I send these data to that xml in asp?

Posted 15-Sep-14 21:54pm

Angela 10293848

Updated 16-Sep-14 0:48am

v3

Add a Solution

Comments

Kornfeld Eliyahu Peter 16-Sep-14 4:31am

Have you done anything so far? Please show some effort (search or code)! As is it ain't a question...

ChintanShukla 16-Sep-14 4:31am

And what have you tried so far?

Angela 10293848 16-Sep-14 4:33am

I dont know how can I send data to a xml file is not it clear?

ChintanShukla 16-Sep-14 4:58am

What is your table structure? what is the XML format you expect?..Pls click on Improve Question and add more information.

Angela 10293848 16-Sep-14 4:59am

I have updated my question

1 solution

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)

George Jonsson · Accepted Answer · 2014-09-15T23:24:00

Solution 1

There are different ways you can do this.

* Create a typed DataSet that reflects the XML structure.
Working with Datasets in Visual Studio[^]
If you load the XML file in Visual Studio, you can auto create a DataSet using the XML menu.

* You can use XML LINQ.
XDocument Class[^]
If you explore the classes XDocument, XElement, XAttribute etc. you will find many examples in MSDN.

Then of course you need to create an SQL query in order to get the data from the database.
Without knowing the structure of your tables, the only help I can give is this: SQL Tutorial[^]

Posted 15-Sep-14 23:24pm

George Jonsson

Updated 15-Sep-14 23:25pm

v2

Comments

Angela 10293848 16-Sep-14 5:33am

forget sth about sql imagine I have these strings in asp
Software
SoftwareDeveloper:"";
Version:"";
.
Sender
Organization="";
.
.
LetterNo="":
now how can I put them in above xml schema in asp?
thanks

George Jonsson 16-Sep-14 5:37am

Please use the 'Improve question' thingy in order to update your question.

Angela 10293848 16-Sep-14 7:24am

I found that how I can create it with below code
protected void Button1_Click(object sender, EventArgs e)
{
XDocument tree = new XDocument(
new XComment("This is a comment"),
new XElement("Letter",
new XElement("Protocol", new XAttribute("Name", Pname), new XAttribute("Version", Pname))
, new XElement("Software", new XAttribute("SoftwareDeveloper", Pname), new XAttribute("Version", Pname), new XAttribute("GUID", Pname))
, new XElement("Sender", new XAttribute("Organization", Pname), new XAttribute("Code", Pname), new XAttribute("Department", Pname), new XAttribute("Position", Pname), new XAttribute("Name", Pname))

)

);

}

now how can I save it ?finally I want to attach this xml in an email?

George Jonsson 16-Sep-14 7:31am

Have you tried tree.Save(@"C:\SomeFolder\SomeFileName.xml"); ?

Angela 10293848 16-Sep-14 7:35am

Yes George it works but I want to save it on server side not in client side

George Jonsson 16-Sep-14 7:40am

Well, what is your problem with that?

Angela 10293848 16-Sep-14 7:43am

tree.save("").. saves the xml in client computer,I want to save it in a folder in server side not client computer

George Jonsson 16-Sep-14 7:49am

Maybe this is too simplistic, but why not use a path on the server?
Otherwise you can save to a stream and send the stream to the server, but then you functionality to receive the stream.

Angela 10293848 16-Sep-14 7:59am

oh yeah,
thank u so much George I used this and worked tree.Save(Server.MapPath("a\\")+"TestDeviceFilter.xml");
thanks again:)

George Jonsson 16-Sep-14 8:02am

You're welcome.