473,320 Members | 1,958 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,320 software developers and data experts.

How to save xml file to SQL2000? with c#

hi, How to save next xml file to SQL2000? with c#

thanks!

<?xml version="1.0" encoding="gb2312"?>
<MyData>
<CLIENT>
<CLIENTID><![CDATA[2300021923]]></CLIENTID>
<CLIENTNAME><![CDATA[guest1]]></CLIENTNAME>
<LOCALWEBSITE><![CDATA[index.shtml]]></LOCALWEBSITE>
<SOURCEWEBSITE><![CDATA[www.sogou.com]]></SOURCEWEBSITE>
<SOURCEAREA><![CDATA[China]]></SOURCEAREA>
<REQUESTSORT><![CDATA[infor]]></REQUESTSORT>
<USERID><![CDATA[8061266]]></USERID>
<USERNAME><![CDATA[peter]]></USERNAME>
<MSG><![CDATA[Welcome!]]></MSG>
</CLIENT>
<CLIENT>
<CLIENTID><![CDATA[2300022020]]></CLIENTID>
<CLIENTNAME><![CDATA[guest2]]></CLIENTNAME>
<LOCALWEBSITE><![CDATA[null]]></LOCALWEBSITE>
<SOURCEWEBSITE><![CDATA[null]]></SOURCEWEBSITE>
<SOURCEAREA><![CDATA[China]]></SOURCEAREA>
<REQUESTSORT><![CDATA[report]]></REQUESTSORT>
<USERID><![CDATA[8061266]]></USERID>
<USERNAME><![CDATA[peter]]></USERNAME>
<MSG><![CDATA[Welcome!]]></MSG>
</CLIENT>
</MyData>
May 30 '06 #1
3 1662
and not with DataSet.

thanks.

"Shuan" <sh***@163.com> дÈëÏûÏ¢ÐÂÎÅ:u6**************@TK2MSFTNGP05.phx.gbl ...
hi, How to save next xml file to SQL2000? with c#

thanks!

<?xml version="1.0" encoding="gb2312"?>
<MyData>
<CLIENT>
<CLIENTID><![CDATA[2300021923]]></CLIENTID>
<CLIENTNAME><![CDATA[guest1]]></CLIENTNAME>
<LOCALWEBSITE><![CDATA[index.shtml]]></LOCALWEBSITE>
<SOURCEWEBSITE><![CDATA[www.sogou.com]]></SOURCEWEBSITE>
<SOURCEAREA><![CDATA[China]]></SOURCEAREA>
<REQUESTSORT><![CDATA[infor]]></REQUESTSORT>
<USERID><![CDATA[8061266]]></USERID>
<USERNAME><![CDATA[peter]]></USERNAME>
<MSG><![CDATA[Welcome!]]></MSG>
</CLIENT>
<CLIENT>
<CLIENTID><![CDATA[2300022020]]></CLIENTID>
<CLIENTNAME><![CDATA[guest2]]></CLIENTNAME>
<LOCALWEBSITE><![CDATA[null]]></LOCALWEBSITE>
<SOURCEWEBSITE><![CDATA[null]]></SOURCEWEBSITE>
<SOURCEAREA><![CDATA[China]]></SOURCEAREA>
<REQUESTSORT><![CDATA[report]]></REQUESTSORT>
<USERID><![CDATA[8061266]]></USERID>
<USERNAME><![CDATA[peter]]></USERNAME>
<MSG><![CDATA[Welcome!]]></MSG>
</CLIENT>
</MyData>

May 31 '06 #2
The easiest way is to iterate the nodes, cut out the values (evaluating
nodes names/ids as you go). Will work fine if you have a rough idea of
what the xml will always look like. If like the example you've
included. Should be a snap.

~ John Fullmer

Shuan wrote:
and not with DataSet.

thanks.

"Shuan" <sh***@163.com> дÈëÏûÏ¢ÐÂÎÅ:u6**************@TK2MSFTNGP05.phx.gbl ...
hi, How to save next xml file to SQL2000? with c#

thanks!

<?xml version="1.0" encoding="gb2312"?>
<MyData>
<CLIENT>
<CLIENTID><![CDATA[2300021923]]></CLIENTID>
<CLIENTNAME><![CDATA[guest1]]></CLIENTNAME>
<LOCALWEBSITE><![CDATA[index.shtml]]></LOCALWEBSITE>
<SOURCEWEBSITE><![CDATA[www.sogou.com]]></SOURCEWEBSITE>
<SOURCEAREA><![CDATA[China]]></SOURCEAREA>
<REQUESTSORT><![CDATA[infor]]></REQUESTSORT>
<USERID><![CDATA[8061266]]></USERID>
<USERNAME><![CDATA[peter]]></USERNAME>
<MSG><![CDATA[Welcome!]]></MSG>
</CLIENT>
<CLIENT>
<CLIENTID><![CDATA[2300022020]]></CLIENTID>
<CLIENTNAME><![CDATA[guest2]]></CLIENTNAME>
<LOCALWEBSITE><![CDATA[null]]></LOCALWEBSITE>
<SOURCEWEBSITE><![CDATA[null]]></SOURCEWEBSITE>
<SOURCEAREA><![CDATA[China]]></SOURCEAREA>
<REQUESTSORT><![CDATA[report]]></REQUESTSORT>
<USERID><![CDATA[8061266]]></USERID>
<USERNAME><![CDATA[peter]]></USERNAME>
<MSG><![CDATA[Welcome!]]></MSG>
</CLIENT>
</MyData>


May 31 '06 #3
Would you give me an example, Please.
"John Fullmer" <jk***@hotmail.com>
??????:11**********************@h76g2000cwa.google groups.com...
The easiest way is to iterate the nodes, cut out the values (evaluating
nodes names/ids as you go). Will work fine if you have a rough idea of
what the xml will always look like. If like the example you've
included. Should be a snap.

~ John Fullmer

Shuan wrote:
and not with DataSet.

thanks.

"Shuan" <sh***@163.com>
дÈëÏûÏ¢ÐÂÎÅ:u6**************@TK2MSFTNGP05.phx.gbl ...
hi, How to save next xml file to SQL2000? with c#

thanks!

<?xml version="1.0" encoding="gb2312"?>
<MyData>
<CLIENT>
<CLIENTID><![CDATA[2300021923]]></CLIENTID>
<CLIENTNAME><![CDATA[guest1]]></CLIENTNAME>
<LOCALWEBSITE><![CDATA[index.shtml]]></LOCALWEBSITE>
<SOURCEWEBSITE><![CDATA[www.sogou.com]]></SOURCEWEBSITE>
<SOURCEAREA><![CDATA[China]]></SOURCEAREA>
<REQUESTSORT><![CDATA[infor]]></REQUESTSORT>
<USERID><![CDATA[8061266]]></USERID>
<USERNAME><![CDATA[peter]]></USERNAME>
<MSG><![CDATA[Welcome!]]></MSG>
</CLIENT>
<CLIENT>
<CLIENTID><![CDATA[2300022020]]></CLIENTID>
<CLIENTNAME><![CDATA[guest2]]></CLIENTNAME>
<LOCALWEBSITE><![CDATA[null]]></LOCALWEBSITE>
<SOURCEWEBSITE><![CDATA[null]]></SOURCEWEBSITE>
<SOURCEAREA><![CDATA[China]]></SOURCEAREA>
<REQUESTSORT><![CDATA[report]]></REQUESTSORT>
<USERID><![CDATA[8061266]]></USERID>
<USERNAME><![CDATA[peter]]></USERNAME>
<MSG><![CDATA[Welcome!]]></MSG>
</CLIENT>
</MyData>

Jun 2 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: LizP | last post by:
Hi, guys - looking for a bit of help/advice on moving a database from SQL 7 to SQL 2000. We've a third party application which currently uses a SQL7 database. This database has a number of views...
2
by: Ger Eielts | last post by:
Hi all, I am brandnew with SQL2000, so sorry in advance for stupidities.... SQL2000, SP3, running on a SBS2003-server with WindowsSharePoint Services. I want to make a dataconnection (from...
4
by: Chris Thunell | last post by:
I have a memory stream that i would like to save to an sql2000 database and then retreave it later on. I currently have the field set as an sql2000 -> VarBinary type of field. Any suggestions in...
22
by: Br | last post by:
First issue: When using ADPs you no longer have the ability to issue a me.refresh to save the current record on a form (the me.refresh does a requery in an ADP). We usually do this before...
2
by: Ryan | last post by:
I've re-written a stored procedure and when I post the following code into the existing SP in EM, is saves OK. However, when I re-edit the SP, the last line 'Commit Transaction' has been removed. ...
2
by: PointMan | last post by:
i make a project in vs2005 that use ASPNETDB.MDF and use <asp:LoginView ID="LoginView1" runat="server" > server control for vs2005 in this case , i'd like to use hosting service but this...
0
by: parameswar | last post by:
Hi friends Now I am working in SQL2000 as back end .I want to load jpeg file in database and retrieve from database. Please guide me.
0
by: basuritta | last post by:
I am trying to add a SQL2000 subscriptor to a SQL2005 publisher and distributor using the Management Studio. I'm using a non-standard port in both ends, but I have set the port for the TCP/IP...
3
by: Blasting Cap | last post by:
I am working on a web app that I want to be able to use a separate config file on, in addition to the web.config file that's already working in the application. If I put the following in the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.