Re: From a WebService Dataset to a local SQL Server

Tech-Archive recommends: Speed Up your PC by fixing your registry

If you are simply trying to update SQL Server, you can create a Data Adapter
with a DataSet and feed it the data. If you want to send it directly to SQL
Server, you can consume it as XML in SQL Server and update/insert from
there. If you are using SQL Server 2005, you can set up a managed routine
and feed it the DataSet and work with it there.

I would look up disconnected and DataSet and see examples on how others are
doing this. For XML, there are plenty of pages out there on using XML in SQL
Server and there are enough examples of managed code in SQL Server 2005.

--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA

Subscribe to my blog
http://gregorybeamer.spaces.live.com/lists/feed.rss

or just read it:
http://gregorybeamer.spaces.live.com/

*************************************************
| Think outside the box!
|
*************************************************
"Carlos" <palcar@xxxxxxxxx> wrote in message
news:eMt3wJUiIHA.5160@xxxxxxxxxxxxxxxxxxxxxxx
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#

thanks



.

Relevant Pages

  • Re: Forms with record source of SQL Server table
    ... In order to be able to update SQL Server tables, ... > I have upsized a backend database into SQL Server. ... > its record source, and it works fine. ... with relatively simple queries as their record source do ...
    (microsoft.public.access.forms)
  • Time zones dates in vb.net 2005
    ... Program I have which determines which way to update SQl server 2005 tables ... based on the lastupdate (datetime field) datetime ...
    (microsoft.public.dotnet.languages.vb)
  • Upgrading SQL Server version in replica environment
    ... I want to update SQL Server version from 7.0 to 2000 but my installation is ... replicated in another 7.0 SQL Server instance. ...
    (microsoft.public.sqlserver.replication)
  • Re: What kind of Program?
    ... but still overkill to me. ... User opens your program, does stuff, then prints a fax to the fax ... tied to each other -- print a fax, update SQL Server. ...
    (microsoft.public.vb.general.discussion)
  • Re: Download the JAVA , .NET and SQL Server interview PDF
    ... 2000 Interview questions of .NET, JAVA and SQL Server Interview ... XML Integration ...
    (comp.lang.java.programmer)