manipulating XML in memory

Hi all,
I need to manipulate a XML document in memory and then save that document to the disk.
Can this be done??

Please suggest me a link or post some sample code.

Basically, I need to write some values to a xml document based on the user input.

Like a user may enter some text in a Text box. This value should be stored in a XML doc. residing in the memory.

When he clicks save this info or the doc gets saved to disk.

Many thanks.

May 18 '07 #1

Subscribe Post Reply

4222

dorinbogdan

839

Expert 512MB

Please tell what language you are using (Java, C#, Javascript....?)

May 18 '07 #2

querry

Sorry a bit late...
I use C#

Thanks.

May 21 '07 #3

dorinbogdan

839

Expert 512MB

I would use XMLDocument.
See this link.

May 21 '07 #4

querry

Thanks dorinbogdan

Really helped a lot.

Now one more question. I am creating a XML file with the XMLDocument Class that has the tags to define a HTML table. It looks like this.

<Table ID=...>
<TR>
<TC>
<Data with some attributes />
</TC>
</TR>
</Table>

Now I need to recreate the table.

Can you suggest how I should do this??

Thanks.

May 22 '07 #5

dorinbogdan

839

Expert 512MB

See this link at the section Adding a Filled Child Element.

May 22 '07 #6

querry

See this link at the section Adding a Filled Child Element.

Thanks a lot dorinbogdan.

May 24 '07 #7

dorinbogdan

839

Expert 512MB

You are always welcome.

God bless you,
Dorin.

May 24 '07 #8

querry

Hi dorinbogdan, :)

Again a bit late.... but I have a problem. I am developing a web application that needs to manipulate XML files in memory. As of now I am Loading and Saving XML files in every event handler. Let me explain....

Expand|Select|Wrap|Line Numbers

 page_Init()

{

 //Load XML

 ....

 //Manipulate XML

 ....

 //Save XML

}
 
page_load()

{

 //Load XML

 ....

 //Manipulate XML

 ....

 //Save XML

}
 
Event_Handler1()

{

 //Load XML

 ....

 //Manipulate XML

 ....

 //Save XML

}
 
Event_Handler2()

{

 //Load XML

 ....

 //Manipulate XML

 ....

 //Save XML

}

I suppose that this causes as much disk activity because we are loading and saving XML file again and again. Which, (if my supposition is correct) will cause more time to load my pages between the postbacks. I am a bit confused :(. Please let me know if I am going in the right direction.

Regards and thanks.

P.S. Also I would appreciate if you can point me to a URL or post a code for manipulating XML in such a scenario. Thanks again.

Jun 13 '07 #9

dorinbogdan

839

Expert 512MB

You could use few public xml objects or strings that will keep the Xml data in memory too. Then, if is postback, it doesn't need to open again the XML file, just use the appropriate public object or load data from string.

Later, it may appear other suggestions too.

Dorin.

Jun 13 '07 #10

querry

Thanks very much. I will try and revert back.

Jun 14 '07 #11

querry

Hi Dorin,

I have gone through and found that the XML file needs to be stored in a Database. Can you suggest anything related to storing a XML file in a MS SQL Server 2000/2005 Database using C#.

Thanks very much.

Jun 19 '07 #12

dorinbogdan

839

Expert 512MB

In SQL 2005 there is a new data type: XML Data Type.
For SQL 2000 you should store the XML string in a Text data type field (not VarChar which is limited to 8000).

Then you can use ADO.NET to save / read the xml as a regular String.

Jun 19 '07 #13

querry

In SQL 2005 there is a new data type: XML Data Type.
For SQL 2000 you should store the XML string in a Text data type field (not VarChar which is limited to 8000).

Then you can use ADO.NET to save / read the xml as a regular String.

Thanks very much. I think, I need to do a bit of "googleing" on the topic.

Jun 21 '07 #14

querry

Ok fine I am able to save XML file into a database.

But, now I have another question. Something related to the XML namespaces.

I have a XML file of the following format.

Expand|Select|Wrap|Line Numbers

 <ns1:Table xmlns:ns1="http://something.com/ns1">

    <ns1:TR> 

           <ns1:TD >some text </ns1:TD>

           <ns1:TD >some text </ns1:TD>

           <ns1:TD >some text </ns1:TD>

           <ns1:TD >some text </ns1:TD>

     </ns1:TR>

</ns1:Table>

I want to transform this XML Document using a .xsl file. I use something like this...

Expand|Select|Wrap|Line Numbers

 <?xml version="1.0" encoding="utf-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
 
<xsl:output method="xml" indent="yes" encoding="utf-8" omit-xml-declaration="yes"/>
 
<xsl:template match="/">

  <xsl:for-each select="//Table">

    <HTML>

      <HEAD><TITLE>Some Title</TITLE></HEAD>

      <TABLE>

          <xsl:apply-templates select="TR"/>

      </TABLE>

    </HTML>

  </xsl:for-each>

</xsl:template>
 
<xsl:template match="/TR">

   <TR>

           <xsl:apply-templates select="TD"/>

   </TR>

</xsl:template>
 
<xsl:template match="/TD">

   <TD>

           Some thing.......

   </TD>

</xsl:template>
 
</xsl:stylesheet>

How should I modify the above .xsl file so that I get the desired output.

Many thanks.

Jun 22 '07 #15

Similar topics

Manipulating large blobs in Python

by: Tim Stone | last post by:

I'm working on a module that will manipulate large blobs. I'm using a C dll to allocate big blocks of memory, using PyMem_Malloc, which is working quite well up until I try to manipulate a blob...

Python

Manipulating and writing bytes (8 bits) in ANSI/ISO C++?

by: Kristian Nybo | last post by:

Hi, I'm writing a simple image file exporter as part of a school project. To implement my image format of choice I need to work with big-endian bytes, where 'byte' of course means '8 bits', not...

C / C++

manipulating void* in array

by: Stijn van Dongen | last post by:

A question about void*. I have a hash library where the hash create function accepts functions unsigned (*hash)(const void *a) int (*cmp) (const void *a, const void *b) The insert function...

C / C++

Manipulating wav files

by: clojinted | last post by:

Hey, I want to break up a wav file using c# into smaller more managable chunks. I'm thinking a buffer to store part of the file may be the way to go. If anyone has any suggestions or could...

C# / C Sharp

Memory Management extremely poor in C# when manipulating string..

by: Segfahlt | last post by:

I have a fairly simple C# program that just needs to open up a fixed width file, convert each record to tab delimited and append a field to the end of it. The input files are between 300M and...

C# / C Sharp

Manipulating bits

by: felixnielsen | last post by:

If im not mistaken, a char variable allocates 1 byte of memory, as it is the case with a bool variable. I need 2 bool and 1 char variable which only need to contain a value between 0 and 63...

C / C++

Manipulating binary data

by: brainflakes.org | last post by:

Hi guys, I need to manipulate binary data (8 bit) stored in a 2 dimensional array. I've tried various methods (arrays, using a string filled with chr(0), using gd lib) and so far the fastest...

PHP

gc penalty of 30-40% when manipulating large data structures?

by: Aaron Watters | last post by:

Poking around I discovered somewhere someone saying that Python gc adds a 4-7% speed penalty. So since I was pretty sure I was not creating reference cycles in nucular I tried running the tests...

Python

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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

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

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

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

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

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

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