Martin,

I have to utilize XML because that is what this project uses.  Here's a 
better explanation of my problem.

Note: I am using the following:
•	VB6.0, SP6
•	MSXML, v4.0 - Newbie
•	SQL Server 2000
•	C# - Newbie  (set up as a server)

The project:
I have a vb form with a series of text boxes.  The form/text boxes are 
linked to a sql server db (this is an existing project that I was brought in 
on) that uses xml and I’m assuming ADO.NET.  This is in turn linked to a C# 
server which handles the xml requests.  I am able to retrieve data from the 
database (via xml) and populate both the text boxes and 2 listview controls 
that I have on my form.  Now I need to have the user enter new data into 
these boxes and send the updated information back to the db.  My guess is 
that I will have to create a several stored procedures on the database side 
(Insert, Delete, Update, etc.)   Assuming this will be done with xml, how do 
convert the data in the vb text box to xml so that I can send it to the C# 
server?  
Note: I am using the following:
•	VB6.0, SP6
•	MSXML, v4.0 - Newbie
•	SQL Server 2000
•	C# - Newbie  (set up as a server)

The project:
I have a vb form with a series of text boxes.  The form/text boxes are 
linked to a sql server db (this is an existing project that I was brought in 
on) that uses xml and I’m assuming ADO.NET.  This is in turn linked to a C# 
server which handles the xml requests.  I am able to retrieve data from the 
database (via xml) and populate both the text boxes and 2 listview controls 
that I have on my form.  Now I need to have the user enter new data into 
these boxes and send the updated information back to the db.  My guess is 
that I will have to create a several stored procedures on the database side 
(Insert, Delete, Update, etc.)   Assuming this will be done with xml, how do 
convert the data in the vb text box to xml so that I can send it to the C# 
server?  



-- 
Anthony D. Law


"Martin Honnen" wrote:

> 
> 
> Anthony D. Law wrote:
> 
> > I'm a newbie when it comes to XML so here's my question.  How can I add new 
> > data to a SQL server 2000 database using VB6/XML?  The user would enter new 
> > data in a series of text boxes and click an 'update' button.  My quess is 
> > this is where I would place the code.  
> 
> Why do you think you need XML to use VB 6 and SQL Server 2000?
> 
> -- 
> 
> 	Martin Honnen --- MVP XML
> 	http://JavaScript.FAQTs.com/
>