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. Visual Basic
  4. data set vs data reader

data set vs data reader

Scheduled Pinned Locked Moved Visual Basic
visual-studioquestion
6 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.
  • N Offline
    N Offline
    nilam11
    wrote on last edited by
    #1

    hi i want to know which one is better to use regularly either data set or data reader ?

    Thanks bye

    A 1 Reply Last reply
    0
    • N nilam11

      hi i want to know which one is better to use regularly either data set or data reader ?

      Thanks bye

      A Offline
      A Offline
      AliAmjad
      wrote on last edited by
      #2

      It depends on your requirements if you want to display as well as alter the data you will use Dataset but if you only want to display data then should use Data Reader because its a Forward-Only Read-Only model and increase the performance of the application.

      C N 2 Replies Last reply
      0
      • A AliAmjad

        It depends on your requirements if you want to display as well as alter the data you will use Dataset but if you only want to display data then should use Data Reader because its a Forward-Only Read-Only model and increase the performance of the application.

        C Offline
        C Offline
        Colin Angus Mackay
        wrote on last edited by
        #3

        You can modify data without using a DataSet. In face, I very rarely use DataSets at all. Too large and clunky.


        Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website

        1 Reply Last reply
        0
        • A AliAmjad

          It depends on your requirements if you want to display as well as alter the data you will use Dataset but if you only want to display data then should use Data Reader because its a Forward-Only Read-Only model and increase the performance of the application.

          N Offline
          N Offline
          nilam11
          wrote on last edited by
          #4

          hi thanks for immediate reply. but for only data display we can use datagridview . then what will be the difference betn datagridview & data set

          Thanks bye

          C V 2 Replies Last reply
          0
          • N nilam11

            hi thanks for immediate reply. but for only data display we can use datagridview . then what will be the difference betn datagridview & data set

            Thanks bye

            C Offline
            C Offline
            Colin Angus Mackay
            wrote on last edited by
            #5

            DataGridView is a presentation mechanism. DataSet is an internal storage structure.


            Upcoming FREE developer events: * Glasgow: db4o: An Embeddable Database Engine for Object-Oriented Environments, Mock Objects, SQL Server CLR Integration, Reporting Services ... My website

            1 Reply Last reply
            0
            • N nilam11

              hi thanks for immediate reply. but for only data display we can use datagridview . then what will be the difference betn datagridview & data set

              Thanks bye

              V Offline
              V Offline
              Vimalsoft Pty Ltd
              wrote on last edited by
              #6

              Hi A Dataset cannot be Compared with a datagrid view. they are two different thing in different categories. a Dataset present data to the datagridview,a datareader present data to datagridview. as the Guy said. if you dont want to update the data, if you only want to view the data, and only in the fowardonly mode, you just have to go for datareader. but id you are going to manupilate the data. use dataset. Go here for more info http://www.dotnetspider.com/kb/Article1078.aspx[^] Thank i wish it helps

              Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sudden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com

              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