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. Doubt in using several Datasets in same project?

Doubt in using several Datasets in same project?

Scheduled Pinned Locked Moved C#
databasequestion
3 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.
  • K Offline
    K Offline
    kssknov
    wrote on last edited by
    #1

    hi all i have a doubt, that when i have several "select" queries for different tables, different criterias in same table, SHOULD I USE seperate DATASETS for each query? pls reply me. since i did like that, so that the no of datasetsi increased in my proj? pls suggest? thanks in adv

    kssk

    C P 2 Replies Last reply
    0
    • K kssknov

      hi all i have a doubt, that when i have several "select" queries for different tables, different criterias in same table, SHOULD I USE seperate DATASETS for each query? pls reply me. since i did like that, so that the no of datasetsi increased in my proj? pls suggest? thanks in adv

      kssk

      C Offline
      C Offline
      CKnig
      wrote on last edited by
      #2

      if you have several queries with the same result you should recycle your DataTable - so no in this case don't use multiple Datasets. If you query different Tables the answer depends on your taste - I tend to use one DataSet for Tables in the same "category" on the same Database so I never get more then 2-3 datasets in my projects - but sometimes people use one dataset for each table ....

      1 Reply Last reply
      0
      • K kssknov

        hi all i have a doubt, that when i have several "select" queries for different tables, different criterias in same table, SHOULD I USE seperate DATASETS for each query? pls reply me. since i did like that, so that the no of datasetsi increased in my proj? pls suggest? thanks in adv

        kssk

        P Offline
        P Offline
        Paul Conrad
        wrote on last edited by
        #3

        You shouldn't have to have separate datasets for each query. If you are using the same tables and fields, you can have different Fill, Get methods for each query.

        "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

        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