Create XML file with C# or ASP

4 New Member

I want to creat this XML file with C# or ASP

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" standalone="yes"?>

<Info>

  <News>

    <Item>

      <Id>1</Id>

      <Title>Test1</Title>

      <Body>testing1 testing1 testing1</Body>

    </Item>

    <Item>

      <Id>2</Id>

      <Title>Test2</Title>

      <Body>testing2 testing2 testing2</Body>

    </Item>

    <Item>

      <Id>3</Id>

      <Title>Test3</Title>

      <Body>testing3 testing3 testing3</Body>

    </Item>

  </News>

  <Press>

    <Item>

      <Id>1</Id>

      <Title>t1</Title>

    </Item>

    <Item>

      <Id>2</Id>

      <Title>t2</Title>

    </Item>

  </Press>

</Info>

I have done this:

Expand|Select|Wrap|Line Numbers

 using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.IO;

using System.Xml;

using System.Xml.Schema;

using System.Xml.Serialization;
 
namespace test6

{

    public partial class _Default : System.Web.UI.Page

    {

        DataSet ds = new DataSet("Info");

        DataTable dt = new DataTable("News");
 
        protected void Page_Load(object sender, EventArgs e)

        {

            DataColumn dc = new DataColumn("ID");

            DataColumn dc1 = new DataColumn("Title");
 
            dt.Columns.Add(dc);

            dt.Columns.Add(dc1);
 
            dt.Merge(dt);

            ds.Tables.Add(dt);
 
        }
 
        protected void Button1_Click(object sender, EventArgs e)

        {

            test();

        }
 
        private void test()

        {
 
            DataRow dr = ds.Tables["News"].NewRow();

            dr["ID"] = TextBox1.Text;

            dr["Title"] = TextBox2.Text;

            ds.Tables["News"].Rows.Add(dr);

            ds.WriteXml(Server.MapPath(Request.ApplicationPath) + "DB.xml");

            Label1.Text = "testing testing testing";
 
        }
 
    }

}

but the Result is:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" standalone="yes"?>

<Info>

  <News>

    <ID>1</ID>

    <Title>d</Title>

  </News>

</Info>

I know that one of the problems is that everytime that I run the the code, a new table will be created so that a new table with new data will be replaced to the file

what can I do to creat that xml file?

Aug 31 '08 #1

Subscribe Reply

1299

NegarZaeem

New Member

I want to creat this XML file with C# or ASP

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" standalone="yes"?>

<Info>

  <News>

    <Item>

      <Id>1</Id>

      <Title>Test1</Title>

      <Body>testing1 testing1 testing1</Body>

    </Item>

    <Item>

      <Id>2</Id>

      <Title>Test2</Title>

      <Body>testing2 testing2 testing2</Body>

    </Item>

    <Item>

      <Id>3</Id>

      <Title>Test3</Title>

      <Body>testing3 testing3 testing3</Body>

    </Item>

  </News>

  <Press>

    <Item>

      <Id>1</Id>

      <Title>t1</Title>

    </Item>

    <Item>

      <Id>2</Id>

      <Title>t2</Title>

    </Item>

  </Press>

</Info>

I have done this:

Expand|Select|Wrap|Line Numbers

 using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.IO;

using System.Xml;

using System.Xml.Schema;

using System.Xml.Serialization;
 
namespace test6

{

    public partial class _Default : System.Web.UI.Page

    {

        DataSet ds = new DataSet("Info");

        DataTable dt = new DataTable("News");
 
        protected void Page_Load(object sender, EventArgs e)

        {

            DataColumn dc = new DataColumn("ID");

            DataColumn dc1 = new DataColumn("Title");
 
            dt.Columns.Add(dc);

            dt.Columns.Add(dc1);
 
            dt.Merge(dt);

            ds.Tables.Add(dt);
 
        }
 
        protected void Button1_Click(object sender, EventArgs e)

        {

            test();

        }
 
        private void test()

        {
 
            DataRow dr = ds.Tables["News"].NewRow();

            dr["ID"] = TextBox1.Text;

            dr["Title"] = TextBox2.Text;

            ds.Tables["News"].Rows.Add(dr);

            ds.WriteXml(Server.MapPath(Request.ApplicationPath) + "DB.xml");

            Label1.Text = "testing testing testing";
 
        }
 
    }

}

but the Result is:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" standalone="yes"?>

<Info>

  <News>

    <ID>1</ID>

    <Title>d</Title>

  </News>

</Info>

I know that one of the problems is that everytime that I run the the code, a new table will be created so that a new table with new data will be replaced to the file

what can i do to creat that xml file?

Aug 31 '08 #2

NegarZaeem

New Member

I want to creat this XML file with C# or ASP

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" standalone="yes"?>

<Info>

  <News>

    <Item>

      <Id>1</Id>

      <Title>Test1</Title>

      <Body>testing1 testing1 testing1</Body>

    </Item>

    <Item>

      <Id>2</Id>

      <Title>Test2</Title>

      <Body>testing2 testing2 testing2</Body>

    </Item>

    <Item>

      <Id>3</Id>

      <Title>Test3</Title>

      <Body>testing3 testing3 testing3</Body>

    </Item>

  </News>

  <Press>

    <Item>

      <Id>1</Id>

      <Title>t1</Title>

    </Item>

    <Item>

      <Id>2</Id>

      <Title>t2</Title>

    </Item>

  </Press>

</Info>

I have done this:

Expand|Select|Wrap|Line Numbers

 using System;

using System.Collections;

using System.Configuration;

using System.Data;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.IO;

using System.Xml;

using System.Xml.Schema;

using System.Xml.Serialization;
 
namespace test6

{

    public partial class _Default : System.Web.UI.Page

    {

        DataSet ds = new DataSet("Info");

        DataTable dt = new DataTable("News");
 
        protected void Page_Load(object sender, EventArgs e)

        {

            DataColumn dc = new DataColumn("ID");

            DataColumn dc1 = new DataColumn("Title");
 
            dt.Columns.Add(dc);

            dt.Columns.Add(dc1);
 
            dt.Merge(dt);

            ds.Tables.Add(dt);
 
        }
 
        protected void Button1_Click(object sender, EventArgs e)

        {

            test();

        }
 
        private void test()

        {
 
            DataRow dr = ds.Tables["News"].NewRow();

            dr["ID"] = TextBox1.Text;

            dr["Title"] = TextBox2.Text;

            ds.Tables["News"].Rows.Add(dr);

            ds.WriteXml(Server.MapPath(Request.ApplicationPath) + "DB.xml");

            Label1.Text = "testing testing testing";
 
        }
 
    }

}

but the Result is:

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" standalone="yes"?>

<Info>

  <News>

    <ID>1</ID>

    <Title>d</Title>

  </News>

</Info>

Aug 31 '08 #3

DonBytes

New Member

I believe you'd have to create it yourself using XmlDocument and CreateElement for each row/column. You can save it and then load it (if it exists) prior to adding items.

I really don't see any other way of getting the extra level (<item>) in there neither.

Aug 31 '08 #4

Dormilich

8,658

Recognized Expert Moderator Expert

Hi, maybe this thread is placed better in the C# or ASP section (for I don't know any of those languages).
You can ask a moderator to move it for you.

Sep 1 '08 #5

acoder

16,027

Recognized Expert Moderator MVP

Threads have been merged. Please use code tags when posting code.

Moderator.

Sep 3 '08 #6

Similar topics

6756

Best way to create temporary file?

by: Frank Millman | last post by:

Hi all I need to generate potentially large reports from a database, and I want to offer the option of print preview before actually printing (using wxPython). I figure that the best way to...

Python

8821

How do I create pdf reports from Access?

by: dog | last post by:

I've seen plenty of articles on this topic but none of them have been able to solve my problem. I am working with an Access 97 database on an NT4.0 machine, which has many Access reports. I...

Microsoft Access / VBA

4382

Create Shortcut (Setup question..)

by: I_AM_DON_AND_YOU? | last post by:

There is one more problem I am facing but didn't get the solution. In my Setup Program I am not been able to create 2 things (when the program is intalled on the client machine ) : (1) create...

Visual Basic .NET

6725

Using Python To Create An Encrypted Container

by: Michael Sperlle | last post by:

Is it possible? Bestcrypt can supposedly be set up on linux, but it seems to need changes to the kernel before it can be installed, and I have no intention of going through whatever hell that would...

Python

20327

How to use Irfanview freeware to create web thumbnail galleries

by: barb | last post by:

So that the world at large benefits from our efforts, here is one fully documented way to use Windows Irfanview freeware to create thumbnail web galleries (http://www.irfanview.com). STEP 1:...

HTML / CSS

7366

create a dynamic array of pointers with initial values of NULL

by: sandy | last post by:

I need (okay, I want) to make a dynamic array of my class 'Directory', within my class Directory (Can you already smell disaster?) Each Directory can have subdirectories so I thought to put these...

C / C++

6875

File.Create - ArgumentException was unhandled - illegal characters in path

by: Vlad | last post by:

I am having problems using the file.create method within a function that is called when looping through an array of filepaths. If I call my function with a hardcoded file path --C:\Temp.txt the...

Visual Basic .NET

3914

how to create a set up project in vb.net

by: sanghavi | last post by:

how to create a set up project in vb.net..how to run an application on a different machine

.NET Framework

2036

how do you create a file using php?

by: brook | last post by:

hey all - i´m new to php and having trouble writing a simple code which should create a file. here is the most simplified version: <?php $content = "my content"; $path = "test.txt";...

PHP

5237

create html from flat file

by: lxyone | last post by:

Using a flat file containing table names, fields, values whats the best way of creating html pages? I want control over the html pages ie 1. layout 2. what data to show 3. what controls to...

PHP

7199

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7074

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

6982

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7451

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5000

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

3161

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3150

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1501

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

374

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General