RE: Webservice to establish connection with SQL Server

SSC Guru

Points: 323504

July 26, 2013 at 6:04 am

ok, after modifying the SoapAction to the correct name, i get the xml back of the data table, but the xml doesn't contain the schema,just the data i think, so i get an error trying to get the data table to read the xml.

ok i modified the posted code above; i create a dataset on the fly, have it read the xml, and then grab the first table in it as the datatable i need to fiddle with.

the above is now working 100%.

enjoy!

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!