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. Database & SysAdmin
  3. Database
  4. getting Row Count of DataTable in c#.net

getting Row Count of DataTable in c#.net

Scheduled Pinned Locked Moved Database
csharpdatabase
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.
  • P Offline
    P Offline
    piyusgupta
    wrote on last edited by
    #1

    plz I am trying to fetch 1,50,000 records from the DataTable and dataTable.Rows.Count returns an integer so it gets index out of bound. tell me the way to find the no records in the DataTable which can return a long value. Piyus Gupta

    G P 2 Replies Last reply
    0
    • P piyusgupta

      plz I am trying to fetch 1,50,000 records from the DataTable and dataTable.Rows.Count returns an integer so it gets index out of bound. tell me the way to find the no records in the DataTable which can return a long value. Piyus Gupta

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

      Why do you need to fetch so much records at once? DataTable.Rows.Count returns integer and its maximum value is 2,147,483,647 so it should be enough for your case

      #region signature my articles #endregion

      1 Reply Last reply
      0
      • P piyusgupta

        plz I am trying to fetch 1,50,000 records from the DataTable and dataTable.Rows.Count returns an integer so it gets index out of bound. tell me the way to find the no records in the DataTable which can return a long value. Piyus Gupta

        P Offline
        P Offline
        PIEBALDconsult
        wrote on last edited by
        #3

        Consider using a DataReader instead.

        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