473,473 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

XML Data Access

Hello,

I must confess I am now very confused. I am simply trying to write a program
that uses data from various XML files to populate a sea of controls, and
uses them in turn to make changes to the XML files. Sounds easy, right? I'm
used to programming in VB, but this is my first foray into data programming
for Windows. I am used to doing that kind of thing in MySQL via PHP. I
therefore have lots of questions, and I don't know what they are.

I have gotten as far as creating an XML schema for one particular flavor of
XML file I'll be using. I'm not clear on why I had to do that, but the
documentation convinced me that I'd be happier and better-looking if I did,
so I spent an evening and managed to do it. Now what good is it, exactly?

I also don't know what would be more appropriate... using a dataset to load
the XML data and display it, or simply using some version of XML reader? And
I don't have any idea where the XML schema I just made fits into the
process. Can I use the schema to reference elements by name instead of using
methods like NextSibling and so forth?

What is data binding? Is it relevant to this? Do I need to do it? Can I get
away without doing it? Would I be cheating if I did? Would my breath be
better? The words "data binding" seem so pretty...

By the way, why can't I use my shiny new XML schema file to instantiate a
typed dataset? If I go to "Add New Item" and select "Dataset," it creates a
blank XSD file I can simply copy and paste the schema info into. But the XML
schema doesn't show up in the Referenced Datasets menu in the form designer.

I guess the main problem is that the documentation gives examples 40 zillion
options of how to do... something. Many things, actually. But I don't know
what those somethings are, how they fit together, and which bit of
information I need to know first in order to implement any of them. And all
the examples present their methods as doing something particularly useful or
helpful, things I didn't know I needed to do (and still am not convinced),
like creating the XML schema.

Help!

Mar 30 '07 #1
5 1205
I suppose part of this problem is just not knowing what questions to ask,
and so riding the whimsical currents of the documentation. It's somewhat
like wanting to wash a sink full of dishes, but only having at one's
disposal a garbled heap of documents with titles like, "pH balancing your
detergent," "Current china patterns in use," "List of hydroxylated anionic
surfactants," and "Basics of attractive food presentation."

Where on earth is the one that says, "Apply dishsoap and water, lather,
scrub and rinse"?

Mar 30 '07 #2
bz
>By the way, why can't I use my shiny new XML schema file to instantiate a
>typed dataset? If I go to "Add New Item" and select "Dataset," it creates a
blank XSD file I can simply copy and paste the schema info into. But the
XML schema doesn't show up in the Referenced Datasets menu in the form
designer.

I have been researching the same issue.
I nailed it down to a EXE in the VB folder call XSD.EXE
It is a command line program. So, you need to go to the dos prompt and type
the arguments.

It is supposed to create a Dataset source code (VB or C#) from the XSD file
for you to access the XML file in your program.
I tried it once but I had no idea what it did. And I am tired of reading
the documents. So, I opened the source code to see and it was a mess to
read.

I searched more and found something called XSD2DB in the Open Source site.
It worked with simple XSD but not something with nested elements after
elements.


Mar 30 '07 #3
bz

"Peter" <st*****@hotmail.comwrote in message
news:P8****************@newsread4.news.pas.earthli nk.net...
>I suppose part of this problem is just not knowing what questions to ask,
and so riding the whimsical currents of the documentation. It's somewhat
like wanting to wash a sink full of dishes, but only having at one's
disposal a garbled heap of documents with titles like, "pH balancing your
detergent," "Current china patterns in use," "List of hydroxylated anionic
surfactants," and "Basics of attractive food presentation."

Where on earth is the one that says, "Apply dishsoap and water, lather,
scrub and rinse"?
Totally!!! You said it all!!!
the documents from MSDN used to be very good. Now it is too (to infinity)
technical. It is not practical to read.
Mar 30 '07 #4
>>I suppose part of this problem is just not knowing what questions to ask,
>>and so riding the whimsical currents of the documentation. It's somewhat
like wanting to wash a sink full of dishes, but only having at one's
disposal a garbled heap of documents with titles like, "pH balancing your
detergent," "Current china patterns in use," "List of hydroxylated anionic
surfactants," and "Basics of attractive food presentation."

Where on earth is the one that says, "Apply dishsoap and water, lather,
scrub and rinse"?

Totally!!! You said it all!!!
the documents from MSDN used to be very good. Now it is too (to infinity)
technical. It is not practical to read.
Well, I'm not going to say the documentation hasn't been immensely helpful
to me... on some things. It did teach me how to use the XSD designer, and
how to do almost all I currently know how to do in VB. There's just a
certain element of why and wherefore missing; a grounding influence that
brings real-world perspective to the abstract concepts it treats.

Maybe that's where a good VB book would come in handy...

Mar 31 '07 #5

5/24/2006
Custom Objects/Collections and Tiered Development
http://sholliday.spaces.live.com/blog/
There is a "how to populate a strongly typed dataset" example there.

I'd take a look at that.


"Peter" <st*****@hotmail.comwrote in message
news:ZV********************@newsread2.news.pas.ear thlink.net...
Hello,

I must confess I am now very confused. I am simply trying to write a
program
that uses data from various XML files to populate a sea of controls, and
uses them in turn to make changes to the XML files. Sounds easy, right?
I'm
used to programming in VB, but this is my first foray into data
programming
for Windows. I am used to doing that kind of thing in MySQL via PHP. I
therefore have lots of questions, and I don't know what they are.

I have gotten as far as creating an XML schema for one particular flavor
of
XML file I'll be using. I'm not clear on why I had to do that, but the
documentation convinced me that I'd be happier and better-looking if I
did,
so I spent an evening and managed to do it. Now what good is it, exactly?

I also don't know what would be more appropriate... using a dataset to
load
the XML data and display it, or simply using some version of XML reader?
And
I don't have any idea where the XML schema I just made fits into the
process. Can I use the schema to reference elements by name instead of
using
methods like NextSibling and so forth?

What is data binding? Is it relevant to this? Do I need to do it? Can I
get
away without doing it? Would I be cheating if I did? Would my breath be
better? The words "data binding" seem so pretty...

By the way, why can't I use my shiny new XML schema file to instantiate a
typed dataset? If I go to "Add New Item" and select "Dataset," it creates
a
blank XSD file I can simply copy and paste the schema info into. But the
XML
schema doesn't show up in the Referenced Datasets menu in the form
designer.
>
I guess the main problem is that the documentation gives examples 40
zillion
options of how to do... something. Many things, actually. But I don't know
what those somethings are, how they fit together, and which bit of
information I need to know first in order to implement any of them. And
all
the examples present their methods as doing something particularly useful
or
helpful, things I didn't know I needed to do (and still am not convinced),
like creating the XML schema.

Help!

Apr 2 '07 #6

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

Similar topics

10
by: sffan | last post by:
I am new to database programming and was curious how others solve the problem of storing encrypted in data in db table columns and then subsequently searching for these records. The particular...
6
by: Hamed | last post by:
Hello I have employed as a developer in a software company that its team uses FoxPro / VB 6.0 / VC++ 6.0 as the developing tools and newly is going to migrate to VS.NET. There is a project...
0
by: sedefo | last post by:
I ran into this Microsoft Patterns & Practices Enterprise Library while i was researching how i can write a database independent data access layer. In my company we already use Data Access...
32
by: Neil Ginsberg | last post by:
We're using SQL Server 7 with an Access 2000 MDB as a front end with ODBC linked tables. I recently created a new set of tables for the app, and users are complaining that unsaved data is being...
1
by: Andrew Arace | last post by:
I scoured the groups for some hands on code to perform the menial task of exporting table data from an Access 2000 database to Oracle database (in this case, it was oracle 8i but i'm assuming this...
9
by: Tony Lee | last post by:
Some time a ago, on this newsgroup the following comments were made in recommending good references for Access (2003) >I used to recommend Dr. Rick Dobson's, "Programming Access <version>" for...
3
by: Lyle Fairfield | last post by:
In a recent thread there has been discussion about Data Access Pages. It has been suggested that they are not permitted on many or most secure sites. Perhaps, that it is so, although I know of no...
1
by: Johann Blake | last post by:
I am looking for a good solution on how to implement data access in an application so that there is a clean separation between the data access layer, the business layer and the GUI layer. I am...
0
by: Grip | last post by:
Hi, I have gone throught the group and Microsoft's online help and have seen many suggestions but I am still seeking clarity: 1. I have an excel spreadsheet. Column A contains text that may...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
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...
1
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...
0
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...
0
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...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
muto222
php
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.