Re: From a WebService Dataset to an Internal SQL Server database

Carlos wrote:
I have a web service that pass me a DataSet, I get all data
correctly, I can even load it on a DataGridView, buyt I want to pass
tha dataset to a Internal SQL Server, exact data structure , with no
modification. What is the best wat you pass the Dataset to a table on
the Internal SQL Server?
Any online Examples ? I did not dinf a good one in google. in C#

There was no way for you to know it (except maybe by browsing through some
of the previous questions in this newsgroup before posting yours - always a
recommended practice) , but this is a classic ADO newsgroup. ADO.Net bears
very little resemblance to classic ADO so, while you may be lucky enough to
find a dotnet-knowledgeable person here who can answer your question, you
can eliminate the luck factor by posting your question to a group where
those dotnet-knowledgeable people hang out. I suggest
microsoft.public.dotnet.framework.adonet.

The answer is: you need to create a parameterized sql statement to be
executed by a sqlcommand object using data obtained from looping through the
rows of the datatable. There is no magic bullet here. The dataset retrieved
from the web service was likely never connected to the database, so how do
you think it would be possible to do this task automatically?

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.