Passing data to a web page

[rocky20]

I am new to .NET and I'm trying to move data from a local database to a
remote database. The only way to access the remote database is through a
web server. What I want to do is pull the records I need from my local
database and pass them to a web page which will loop through the records and
call a stored procedure on the remote database to insert them into a table .
I am using VB 2005 and SQL Server 2000. I have worked out the first part
where I pull the records I need from the local database in the code below.

Dim testConn As SqlConnection = New SqlConnection("Data
Source=DBLocalTest;integrated security=sspi;initial Catalog=pubs;")

Dim testCMD As SqlCommand = New SqlCommand("SPTest", testConn)

testCMD.CommandType = CommandType.StoredProcedure

Dim adapter As New SqlDataAdapter(testCMD)

Dim newDataset As New DataSet()

adapter.Fill(newDataset)

testConn.Close()

Dim xmldocument2 As New XmlDataDocument(newDataset)

I have the records in an XLMDataDocument now and what I want to do is pass
them over the web to a web page. This is where I'm stuck. How would I go
about passing the XLMDataDocument to a web page? Is putting the data in a
XLMDataDocument the right way to ready it for trasport to the web page?
Would this web page be considered a Web Service?

Any help would be appreciated.

[Martin Kulov]

"rocky20" <go********@hotmail.com> wrote in message
news:e5**************@TK2MSFTNGP09.phx.gbl...

I have the records in an XLMDataDocument now and what I want to do is pass
them over the web to a web page. This is where I'm stuck. How would I go
about passing the XLMDataDocument to a web page? Is putting the data in a
XLMDataDocument the right way to ready it for trasport to the web page?
Would this web page be considered a Web Service?

Hi rocky20,

you do not have to convert the Dataset to XMLDocument. Just serialize the
Dataset to XML and pass it as a string. On the other side you can
deserialize the string to Dataset object backforwards.

Regards,

--
Martin Kulov
http://www.codeattest.com/blogs/martin

MCT
MCSD.NET Early Achiever