Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. Write Dataset to SQL

Write Dataset to SQL

Scheduled Pinned Locked Moved C#
databasequestionhelp
4 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • G Offline
    G Offline
    GermanDM
    wrote on last edited by
    #1

    Hi, Can anybody please assist me with the following.I have googled but no luck. I receive a dataset from a webservice which contains all data i requested. How can I simply insert all the rows which are in the dataset into SQL database? The dataset contains three tables and the sql database destination has the exact same tables and columns. any help, suggestions or articles will be greatly appreciated.

    C V G 3 Replies Last reply
    0
    • G GermanDM

      Hi, Can anybody please assist me with the following.I have googled but no luck. I receive a dataset from a webservice which contains all data i requested. How can I simply insert all the rows which are in the dataset into SQL database? The dataset contains three tables and the sql database destination has the exact same tables and columns. any help, suggestions or articles will be greatly appreciated.

      V Offline
      V Offline
      Vasudevan Deepak Kumar
      wrote on last edited by
      #2

      http://www.codeproject.com/useritems/GenerateSQL.asp[^]

      Vasudevan Deepak Kumar Personal Homepage Tech Gossips

      1 Reply Last reply
      0
      • G GermanDM

        Hi, Can anybody please assist me with the following.I have googled but no luck. I receive a dataset from a webservice which contains all data i requested. How can I simply insert all the rows which are in the dataset into SQL database? The dataset contains three tables and the sql database destination has the exact same tables and columns. any help, suggestions or articles will be greatly appreciated.

        C Offline
        C Offline
        costavo
        wrote on last edited by
        #3

        did u try doing a stored procedure and an insert sql command?

        1 Reply Last reply
        0
        • G GermanDM

          Hi, Can anybody please assist me with the following.I have googled but no luck. I receive a dataset from a webservice which contains all data i requested. How can I simply insert all the rows which are in the dataset into SQL database? The dataset contains three tables and the sql database destination has the exact same tables and columns. any help, suggestions or articles will be greatly appreciated.

          G Offline
          G Offline
          Giorgi Dalakishvili
          wrote on last edited by
          #4

          Did you search here on codeproject? I'm sure you will find necessary articles.

          #region signature my articles #endregion

          1 Reply Last reply
          0
          Reply
          • Reply as topic
          Log in to reply
          • Oldest to Newest
          • Newest to Oldest
          • Most Votes


          • Login

          • Don't have an account? Register

          • Login or register to search.
          • First post
            Last post
          0
          • Categories
          • Recent
          • Tags
          • Popular
          • World
          • Users
          • Groups