XML from SQL Server 2000 tables - .NET 1.1 & higher versions

i've to write an utility that runs all the time as a service, which extracs data from multiple sql tables and should generate xml data based on a particular schema (some data are optional, some are required in schema) and should store this xml in a file (say xml file). 

db is sql server 2000.  .net we currently use 1.1 but planning to change soon to vs.net 2008.

I have to write a program that extracts data from multiple tables (in the schema defined by us) and store it as xml in a file.

This tables will have atleast 100-10000 records daily and i have to convert this data quickly and store this file in a particular location at the end of the day.

so my question:

1. is there any xml class or control in .net 1.1 that does the data conversion from sql to xml quickly (based on my schema)? same for vs.net 2008.
2. is there any sql statement that can do this based on my schema from multiple tables?

which is best solution in terms of performance.

thanks in advance.

 

0
arnet
1/9/2008 6:18:21 PM
asp.net.getting-started 91979 articles. 3 followers. Follow

1 Replies
571 Views

Similar Articles

[PageSpeed] 44

Hi Arnet,

As far as controls go, I don't think you'll find any that would help you here; your scenario isn't really a presentation-layer kind of problem.  However, in case you haven't already, you might want to take a look at the methods ReadXmlSchema and WriteXml on System.Data.DataSet, which may already do exactly what you're looking for.

Good luck,
Clay

0
ClayCo
1/10/2008 2:10:07 AM
Reply:

Similar Artilces:

Where is a list of getting started walkthroughs for version 1.1?
This is a great list of walkthroughs for Asp.Net 2.0: http://msdn2.microsoft.com/en-us/library/ms186109.aspx I have to go back and do a project in version 1.1 and I can not find a similar page that lists the walkthroughs in order that would teach my how to do things in the older version.     they didn't have the same type of quickstarts for 1.1 - but they did have a quickstarthttp://www.dotnetjunkies.com/quickstart/aspplus/doc/quickstart.aspx Hope That HelpsAll that wander, are not lost...What were we talkin bout...

How to copy a table from SQL Server 1 to SQL Server 2
I have 2 SQL Server. I need copy a table from SQL Server 1 to SQL Server 2.  Does someone know how to do it? Please help! In Enterprise Manager, right click on the table, go to "All Tasks", "Export Data", then follow the steps in the wizard....

How to use Treeview control with SQL Server generated XML in Ver 1.1
Hi,  Can anybody please help me. I am using a treeview control in asp.net 1.1 . I downloaded and installed the control.Now I want to populate treeview dynamically. I given a TreenodeSrc = "Practice.aspx"In practice.aspx page, i want to fetch xml using the sql query. I did but, when i executing it is saying, XML exceptionand <Treenodes> tag is missed. Can anybody help me, how to do this one. Thanks,...

error starting fox: 1.9.1.5 xulrunner version needs to be upgraded to 1.9.1.7.
Name: Product: Firefox Summary: error starting fox: 1.9.1.5 xulrunner version needs to be upgraded to 1.9.1.7. Comments: my firefox was automagically updated a few days ago, and now when i triy to start it, even in safe mode, i get an error that more or less says 1.9.1.5 xulrunner version needs to be upgraded to 1.9.1.7. OS is win 7 Browser Details: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0) From URL: ...

superreview granted: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246922] 1.8 patch: SeaMonkey version -> 1.1, localeVers
neil@parkwaycc.co.uk <neil@httl.net> has granted Robert Kaiser <kairo@kairo.at>'s request for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246922: 1.8 patch: SeaMonkey version -> 1.1, localeVersion -> 1.8.1 https://bugzilla.mozilla.org/attachment.cgi?id=246922&action=edit ...

superreview requested: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246922] 1.8 patch: SeaMonkey version -> 1.1, localeVe
Robert Kaiser <kairo@kairo.at> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246922: 1.8 patch: SeaMonkey version -> 1.1, localeVersion -> 1.8.1 https://bugzilla.mozilla.org/attachment.cgi?id=246922&action=edit ------- Additional Comments from Robert Kaiser <kairo@kairo.at> ...and here's the 1.8 branch patch, setting SeaMonkey version to 1.1 for final, and locale...

Versions 1.0 and 1.1
I have Visual Studio 2002 and Framework !.0. If I install Asp.net1.1 will that work?Doo I actually have to install just Framework to get version 1.1?If I make solutions with my 2002 VS it doesn't work on VS2003 'cos of version 1.0! Visual Studio 2002 was built on .Net framework 1.0 and cannot use 1.1. You have to ugrade to Visual Studio 2003.    It's all over and I'm standin' prettyIn this dust that was a cityIf I could find a souvenierJust to prove the world was here How can I upgrade it and that doesn't cost lots of money?Is it better if I get clean version 2003 or upgrade...

SQL Server 2000 Developer Edition, Windows XP and DNN 3.1.1 Development?
I have a DNN 2.1.2 site and pay for hosting.  I've been using DNN 2.1.2 on my local machine with Windows XP Pro for development utilizing the Access database on my local machine.  I have Visual Studio Enterprise Architect for custom module development.  I'm not a very good programmer but I've been able to make custom modules that work for my site although they all use independent Access databases.  I'd like to move away from this practice and use the SQL database like real module developers do.I would like to upgrade my local development machine to DNN 3.1.1 and then even...

wine version 1.1.28 or 1.1.44?
Here's a question about the wine emulator choices. I'm very happy using openSUSE Linux and I have installed a few applications, but only using the Yast2 methods and RPM groups. The latest available wine version on the Yast2 enabled installation is 1.1.28-2.3 which was built last October. The latest available wine version on the winehq.org web site is 1.1.44 How safe is it to use the non-Yast approach for a new user such as myself to try to install 1.1.44? [Acer Aspire 5520-5891 laptop,AMD Athlon 64x2 (TK57), NVIDIA GeForce 7000M] -- 3bitsShortOfaByte ------...

Upgrading from version 3.6.1 to EA Server 4.1.1
One of the special upgrade instructions indicates that connection caches and server properties that are defined are not automatically upgraded. I changed afconfig.old<timestamp> in the $JAGUAR/ini and not in the $JAGUAR/config. I copied the afconfig.old<timestamp> to afconfig.dat. I restarted the server The restart created a new $JAGUAR/ini/afconfigconversion.log_<timestamp> I went into Jaguar Manager under Servers => Jaguar and had no "Installed Connection Caches" folder. Further down under Jaguar Manager was a folder called "Connection ...

Getting a 1:1 copy from my production server to a test server
Hi everybody, I'm in the good luck of starting a new test server nearly similar to my production server. Both Windows NT 4.0 Server machines, but with different volumes. I have two user databases. O.K. I can backup and restore my two user databases, but how do I have to proceed with my system databases? What will be the easiest way of getting a 1:1 copy of my production server to the new test server? Thank's for help. Oliver -- Oliver Lorenz IT-Development-Manager ADT Jalex GmbH / Germany o-lorenz@wellcom.de o-lorenz@wellcom.de wrote... > Hi...

Is Open Client/Server Products Version 11.1.1 for Windows NT compatible with Window 2000 ?
Is Open Client/Server Products Version 11.1.1 for Windows NT compatible with Window 2000 > Is Open Client/Server Products Version 11.1.1 for Windows NT compatible > with Window 2000 I am using Open Client with Windows 2000 Prof without any problems. Stephan It is certified by Sybase. The 11.1.1 version was made for NT but works and is certified with 2000. One small wrinkle is that Microsoft changed the default locations for programs that get run from the start button. NT had: winnt -> Profiles -> all users -> start menu -> Programs -> Sybase S...

superreview granted: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246921] 1.8.0 patch: SeaMonkey version -> 1.0.7
neil@parkwaycc.co.uk <neil@httl.net> has granted Robert Kaiser <kairo@kairo.at>'s request for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246921: 1.8.0 patch: SeaMonkey version -> 1.0.7 https://bugzilla.mozilla.org/attachment.cgi?id=246921&action=edit ...

superreview requested: [Bug 362139] bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch : [Attachment 246921] 1.8.0 patch: SeaMonkey version -> 1.0.7
Robert Kaiser <kairo@kairo.at> has asked neil@parkwaycc.co.uk <neil@httl.net> for superreview: Bug 362139: bump SeaMonkey versions to 1.0.7/1.1 on 1.8.0/1.8 branches, localeVersion to 1.8.1 on 1.8 branch https://bugzilla.mozilla.org/show_bug.cgi?id=362139 Attachment 246921: 1.8.0 patch: SeaMonkey version -> 1.0.7 https://bugzilla.mozilla.org/attachment.cgi?id=246921&action=edit ------- Additional Comments from Robert Kaiser <kairo@kairo.at> This is the 1.8.0 branch patch for bumping SeaMonkey version to 1.0.7 ...

Can't get to SQL Server 7.0 via OpenClient 11.1.1 Solaris
Greetings friends. Anyone tried to connect via OpenClient's (Solaris) version 11.1.1 to a SQL Server 7.0 database server? I am receiving errors, which leads me to believe that OpenClient may not support it. I did create an interfaces file entry using sybsetup, and used tl tcp as the protocol. Thanks for your thoughts. -Tom Galfano Strong Capital Management, Inc. Milwaukee, WI 414-359-3358 This is a cryptographically signed message in MIME format. --------------ms6C4D71F99E2A123EED0E03C5 Content-Type: multipart/mixed; boundary="------------A0B8C3C68F34154A...

Web resources about - XML from SQL Server 2000 tables - .NET 1.1 & higher versions - asp.net.getting-started

Authorized King James Version - Wikipedia, the free encyclopedia
The title page to the 1611 first edition of the Authorized Version Bible by Cornelis Boel shows the Apostles Peter and Paul seated centrally ...

Former Secretary of Defense Donald Rumsfeld releases new diabolical version of Solitaire for iOS
... of iOS Devices , Apps , and iPad . What do you think? Discuss "Former Secretary of Defense Donald Rumsfeld releases new diabolical version ...

Punishment Instead Of Education, The Campus Sexual Assault Version
Universities are changing the rules on sexual assault. That's good. How they're implementing it? That's bad.

Google Hangouts version 7.0 rolling out, quick replies and conversation shortcuts on board
... worthy of celebration. It is the IM service all Android users have by default, after all (whether you use it or not). Reports of Hangouts version ...

Dell XPS 15 review: A bigger version of the best PC laptop
... XPS 13 system has won widespread plaudits, with many regarding it as the 13-inch PC laptop to beat. I recently reviewed the new Skylake version ...

PC users, get rid of Adobe Flash end of life versions
... The key finding of the UK Country Report says that 78 percent of users have Adobe Flash Player 19 installed. This is an end-of-life version ...

Samsung tipped to launch only two Galaxy S7 versions
In spite of some early reports, which claimed that Samsung will have three Galaxy S7 versions in stores early this year, a new rumor indicates ...

Microsoft quietly released a powerful new version of its laptop
Microsoft has quietly released two new, and more powerful, versions of the Surface Book and Surface Pro. The old high-end Book and Pro models ...

Thomson Reuters wants to own fintech with its version of the App Store
... the structure of their businesses today than they were even a few years ago." Lojko runs the Eikon business, Thomson Reuters' software version ...

Would be the Democratic version of Donald Trump be ... Donald Trump?
So Donald Trump is creating real havoc in the GOP. While the choice of a small but real minority (in the 35 percent realm), a majority of the ...

Resources last updated: 1/29/2016 2:16:47 AM