XML WebService to Update remote SQL server

[Harisismail]

Hi,

Pl can any one help me with a sample explanation for a XML Web Service which updates a SQL sever in a remote location??????

Thanx

[Strider]

You can pass dataset over a webservice so i'd recommend doing this.
Let the webservice look after inserting the data in SQL Server

[Harisismail]

Can you please exlain how do do this pl?

[Strider]

Have a look at this link http://samples.gotdotnet.com/quickst...icesintro.aspx
to learn how to create Web Services, it will show you how to do a few simple ones

Then in your smart device application solution, in the solution explorer select the reference option and right click on it. Then select add web reference. Enter the URL of your web service and it will display all the methods of the web service

[Harisismail]

Thanx Strider,

Can you please tell me how to create a .xsd file form a .xml file?

[Strider]

why do you need to create an xsd file?

[Harisismail]

Hey Barry,
Sorry for not replying all this time.
Its simply this.............Im kind of new to mobile deveopment. I want to Access a Remote SQL server and Update cetain tables from a Windows CE handheld (Wireless Networks). I have heard this can be done through XML web services. Can u help me please?............................

[Strider]

This can be done several ways.

1.Remote Data Access (http://www.ondotnet.com/pub/a/dotnet...20.html?page=1)
2.Replication (http://msdn.microsoft.com/msdnmag/is...09/DataPoints/)
3.Connecting Directly to the SQL Server from the device (by using SQLClient on the device, is exactly the same as connecting to SQL Server in normal vb.net)
4.Via a Webservice as you mention

So i'd recommend you have a look at all these options and see what best suits your needs