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. Can you tell me How many rows datagrid contain ! Pls

Can you tell me How many rows datagrid contain ! Pls

Scheduled Pinned Locked Moved Visual Basic
8 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.
  • L Offline
    L Offline
    lucdt
    wrote on last edited by
    #1

    Can you tell me how many rows datagrid can contain ! Pls Can you tell me how many tables dataset can contain ! Pls can you tell me how many rows DataTable can contain ! Pls

    K 1 Reply Last reply
    0
    • L lucdt

      Can you tell me how many rows datagrid can contain ! Pls Can you tell me how many tables dataset can contain ! Pls can you tell me how many rows DataTable can contain ! Pls

      K Offline
      K Offline
      kutz9
      wrote on last edited by
      #2

      Theoretically it's an infinite number, I believe. Theoretically it's an infinite number, I believe. Theoretically it's an infinite number, I believe. Of course this will all depend on the resources available to your computer. If you run out of memory, your variable obviously isn't going to get any bigger... Why do you ask? _____________________ Don't take out the Magic Pen, Don't draw on the Infinity Board - Neil Young

      L 1 Reply Last reply
      0
      • K kutz9

        Theoretically it's an infinite number, I believe. Theoretically it's an infinite number, I believe. Theoretically it's an infinite number, I believe. Of course this will all depend on the resources available to your computer. If you run out of memory, your variable obviously isn't going to get any bigger... Why do you ask? _____________________ Don't take out the Magic Pen, Don't draw on the Infinity Board - Neil Young

        L Offline
        L Offline
        lucdt
        wrote on last edited by
        #3

        I have built a program by Vb.net. It collect all information in a table of Oracle Database into dataset and datatable and datagrid. So I can write this information into foxpro file. If dataset, datagrid and datatable can not contain all information. The foxpro file will be missed data. This tables in my database contains a lots of rows. Now, It contains about some milions rows. But in the future, I thinks it will become bigger. This records are call data records of CDMA.

        K 1 Reply Last reply
        0
        • L lucdt

          I have built a program by Vb.net. It collect all information in a table of Oracle Database into dataset and datatable and datagrid. So I can write this information into foxpro file. If dataset, datagrid and datatable can not contain all information. The foxpro file will be missed data. This tables in my database contains a lots of rows. Now, It contains about some milions rows. But in the future, I thinks it will become bigger. This records are call data records of CDMA.

          K Offline
          K Offline
          kutz9
          wrote on last edited by
          #4

          Well I'm pretty sure that there's no theoretical limit to the sizes of any of these structures, it just depends on how the rest of your application can handle the sheer processing requirements. Anyone else know more? Regards, Kutz _____________________ Don't take out the Magic Pen, Don't draw on the Infinity Board - Neil Young

          L 1 Reply Last reply
          0
          • K kutz9

            Well I'm pretty sure that there's no theoretical limit to the sizes of any of these structures, it just depends on how the rest of your application can handle the sheer processing requirements. Anyone else know more? Regards, Kutz _____________________ Don't take out the Magic Pen, Don't draw on the Infinity Board - Neil Young

            L Offline
            L Offline
            lucdt
            wrote on last edited by
            #5

            Anyway, thanks you alots. If you know more, pls, tell me. I am looking forward to receiving nice information from you !

            K D 2 Replies Last reply
            0
            • L lucdt

              Anyway, thanks you alots. If you know more, pls, tell me. I am looking forward to receiving nice information from you !

              K Offline
              K Offline
              kutz9
              wrote on last edited by
              #6

              Well, a datagrid is simply a container to show the contents of a dataset, so the limit will be the dataset. And I don't think datasets have a theoretical size limit. _____________________ Don't take out the Magic Pen, Don't draw on the Infinity Board - Neil Young

              1 Reply Last reply
              0
              • L lucdt

                Anyway, thanks you alots. If you know more, pls, tell me. I am looking forward to receiving nice information from you !

                D Offline
                D Offline
                Dave Kreskowiak
                wrote on last edited by
                #7

                In theory, there is no limit, other than available memory and the size of an index pointer. But, you don't have to read in the entire datatable all at once. If you use DataReader's, you can read each record, one at time and don't have to care about the size of the database. Retrieving Data Using the DataReader[^] RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

                L 1 Reply Last reply
                0
                • D Dave Kreskowiak

                  In theory, there is no limit, other than available memory and the size of an index pointer. But, you don't have to read in the entire datatable all at once. If you use DataReader's, you can read each record, one at time and don't have to care about the size of the database. Retrieving Data Using the DataReader[^] RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

                  L Offline
                  L Offline
                  lucdt
                  wrote on last edited by
                  #8

                  Thanks you. I thinks that a good idea.

                  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