•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the VB.NET section within the Software Development category of DaniWeb, a massive community of 391,160 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,309 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our VB.NET advertiser:
Views: 512 | Replies: 0
 |
•
•
Join Date: Sep 2007
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I have a data base with multiple Tables, columns and Rows I need to produce an XML file. I'm required to send ALL columns even those that are NILL. In SQL 2005 I can use FOR XML ELEMENTS ISINIL, however I'm using SQL 2000 so I can't get the NILL Columns. Also, I need to change my NODE name to Pular when there is more than one childnode.
What I'm attempting to do is select my database into a data set then write out the data set, using XMLWRITER to a filestream. I need to know can I "insert" or "replace" data in my data set prior to using the XMLWRITER or do I have to re-read (XMLREAD) and then change my data. Or is there a better way?
What I'm attempting to do is select my database into a data set then write out the data set, using XMLWRITER to a filestream. I need to know can I "insert" or "replace" data in my data set prior to using the XMLWRITER or do I have to re-read (XMLREAD) and then change my data. Or is there a better way?
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb VB.NET Marketplace
Linear Mode
•
•
•
•
.net .net framework 3.0 access ajax api asp blogger blogging code combo custom data database developer development dom dropdownlist feed gdata google hacker html linspire linux microsoft module msdn net news office openoffice programming reader reuse rss security skin software sql standards survey theme vista w3c weather web windows workflow xml xoap
- [urgent] HTML form => XML file (JSP)
- How to store and search a XML FIle (ASP.NET)
- Unzip zipped xml file (VB.NET)
- problem reading xml file in c# (C#)
- parsing error (XML file-java-schema) (Java)
- Pass XML file contents to a hash table. (Java)
- Ms Sql 2000 (MS SQL)
- Windows 2000 Debug file (Windows NT / 2000 / XP / 2003)
Other Threads in the VB.NET Forum
- Previous Thread: Displaying # value in date field in a data grid.
- Next Thread: vb.net + sql 2000 + xml file
