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. Update data base

Update data base

Scheduled Pinned Locked Moved C#
csharpdatabasequestionannouncement
4 Posts 3 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.
  • T Offline
    T Offline
    Tamimi Code
    wrote on last edited by
    #1

    do you prefer to use Dataset or direct SqlCommand to update your DB ?? for .net 2003

    When you get mad...THINK twice that the only advice Tamimi - Code

    E M 2 Replies Last reply
    0
    • T Tamimi Code

      do you prefer to use Dataset or direct SqlCommand to update your DB ?? for .net 2003

      When you get mad...THINK twice that the only advice Tamimi - Code

      E Offline
      E Offline
      ESTAN
      wrote on last edited by
      #2

      I am using a direct SQL query to update my database.

      T 1 Reply Last reply
      0
      • E ESTAN

        I am using a direct SQL query to update my database.

        T Offline
        T Offline
        Tamimi Code
        wrote on last edited by
        #3

        do you suffer from marinating string ?? and what are the advantages of direct SQL queries

        When you get mad...THINK twice that the only advice Tamimi - Code

        1 Reply Last reply
        0
        • T Tamimi Code

          do you prefer to use Dataset or direct SqlCommand to update your DB ?? for .net 2003

          When you get mad...THINK twice that the only advice Tamimi - Code

          M Offline
          M Offline
          Mandaar Kulkarni
          wrote on last edited by
          #4

          The update methods of dataset are quite useful when you are dealing with bulk of data. For single or a few records it doesno't matter whether you use sql or bulk update. Stored procedure are better than sql statements with respect to faster execution as they are compiled and the sql gets compiled runtime.

          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