473,388 Members | 873 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,388 software developers and data experts.

saving XML into database

39
hi all,
I have developed a code which writes into an xml ,after writing im saving them as XML file only. i want to know how can i save it into a database.
Is there any function available for doing so ???


Thank u,
tezu
Dec 31 '08 #1
9 4650
Dormilich
8,658 Expert Mod 8TB
you can save it like any other text. make sure the encoding of the file and the database matches.

regards
Dec 31 '08 #2
tezu
39
Hi,

But how do i store it??? actually im new to this database and xml stuff so if u could lemme know more it would be helpfull

thank u
Dec 31 '08 #3
Dormilich
8,658 Expert Mod 8TB
@tezu
what do you mean? you store it like any other text, that's all.
Dec 31 '08 #4
tezu
39
i mean do i have to make a database connection or something???
Dec 31 '08 #5
tezu
39
im using this function to save to a file.


Expand|Select|Wrap|Line Numbers
  1. {
  2. _variant_t varString = strFileName;
  3.     parser->myComPtrDocument->save(varString);
  4.     return true;
  5. }
now i want to store this file to an existing database using void pointer ,
Dec 31 '08 #6
Dormilich
8,658 Expert Mod 8TB
@tezu
of course you have to. use the database functions your language provides. which are basicly 2: one for connecting and one to execute the query.
Dec 31 '08 #7
tezu
39
ok , il try it

thanks a lot
Dec 31 '08 #8
there is a number of databases that supports XML natively, one of their data types exactly XML when in simple databases maximum you could have is TEXT only. You want to deal with XML in database naturally you have two ways one is to use XML enabled databases like Microsoft SQL 2005/2008 or IBM DB2 (both of them have free Express editions) or use native XML databases like Berkeley DB XML (unfortunately was acquired by Oracle), Sedna, MarkLogic...
Jan 9 '09 #9
tezu
39
hey thank u so much

tezu
Jan 12 '09 #10

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Roy Gourgi | last post by:
Hi, Is it possible to save to a database as opposed to saving to a flat .txt file? It could be any database program, such as FoxPro (preferably), SQL Server, MySQL. Furthermore, I would also...
2
by: manning_news | last post by:
Has anyone had a problem with Access 2003 not saving their coding? I've been using 2003 for a couple of months now and just this week noticed that some coding I'd done for a database was not there...
6
by: Robm | last post by:
Since googling this issue only brings up the April fool's problem, which was solved years ago, I hope that somebody can help me with this. I have a large vc++/mfc application which needs to know...
4
by: Pedro Leite | last post by:
Good Afternoon. the code below is properly retreiving binary data from a database and saving it. but instead of saving at client machine is saving at the server machine. what is wrong with my...
3
by: sameer | last post by:
Hi all, ..net framwork 1.1 sql server 2000 I have a vb.net winforms application using webservices\ remoting to upload documents\ images to the webserver and i am gong to store them in the sql...
0
by: sameer | last post by:
Hi all, ..net framwork 1.1 sql server 2000 I have a vb.net winforms application using webservices\ remoting to upload documents\ images to the webserver and i am gong to store them in the sql...
6
by: Mark Denardo | last post by:
My question is similar to one someone posted a few months back, but I don't see any replies. Basically I want to be able to have users upload photos and save them in a database (as byte data)...
1
by: Allie | last post by:
Hi, all. This might be a silly question... but I am very new to programming in SQL so please bear with me :) So. I'm using MS SQL Server 2005 Management Studio Express. I have a table that...
0
by: madhu raju | last post by:
iam saving the data into Ms-Access database using Vb.net Application In that application iam using Data grid view to save the data into the database Here in the below code iam saving the name of...
10
by: Nathan Sokalski | last post by:
I am using ASP.NET 2.0, and need to know how to save and use an image that is stored in an SQL Server image datatype. How can I do this using ASP.NET? Thanks.
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
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...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.