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. Web Development
  3. ASP.NET
  4. Problem in Displaying Huge data

Problem in Displaying Huge data

Scheduled Pinned Locked Moved ASP.NET
helpcsharpdatabaseoraclesysadmin
9 Posts 5 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.
  • B Offline
    B Offline
    ballameharmurali
    wrote on last edited by
    #1

    Hi all, I am trying to display 77000 records from Oracle Database to .NET DataGrid. So it is not displaying and getting Application Server Error. Using OLEDB i did. Is there any way for solving this problem Thanks Murali

    C N 2 Replies Last reply
    0
    • B ballameharmurali

      Hi all, I am trying to display 77000 records from Oracle Database to .NET DataGrid. So it is not displaying and getting Application Server Error. Using OLEDB i did. Is there any way for solving this problem Thanks Murali

      C Offline
      C Offline
      Christian Graus
      wrote on last edited by
      #2

      Why would you want to show 77000 records ?

      Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

      _ 1 Reply Last reply
      0
      • C Christian Graus

        Why would you want to show 77000 records ?

        Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

        _ Offline
        _ Offline
        _Damian S_
        wrote on last edited by
        #3

        So the user can find the one they want!! ;-)

        I don't have ADHD, I have ADOS... Attention Deficit oooh SHINY!! Booger Mobile (n) - A bright green 1964 Ford Falcon - our entry into the Camp Quality esCarpade!! Do something wonderful - make a donation to Camp Quality today!!

        1 Reply Last reply
        0
        • B ballameharmurali

          Hi all, I am trying to display 77000 records from Oracle Database to .NET DataGrid. So it is not displaying and getting Application Server Error. Using OLEDB i did. Is there any way for solving this problem Thanks Murali

          N Offline
          N Offline
          Nishant Singh
          wrote on last edited by
          #4

          Better approach is put a search option , when the user puts a Search Criteria the appropriate results would be displayed , Because you could not expect a user to move through all 77000 records

          P B 2 Replies Last reply
          0
          • N Nishant Singh

            Better approach is put a search option , when the user puts a Search Criteria the appropriate results would be displayed , Because you could not expect a user to move through all 77000 records

            P Offline
            P Offline
            padmanabhan N
            wrote on last edited by
            #5

            Nishant Singh wrote:

            Because you could not expect a user to move through all 77000 records

            yes, but if he still wants all the records he can have paging enabled.

            Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]

            B 1 Reply Last reply
            0
            • P padmanabhan N

              Nishant Singh wrote:

              Because you could not expect a user to move through all 77000 records

              yes, but if he still wants all the records he can have paging enabled.

              Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]

              B Offline
              B Offline
              ballameharmurali
              wrote on last edited by
              #6

              Hi, Yes but the problem the problem is if the paging is enabled also the page is not not displaying due to huge data i think .Is there a way to Display all the records(77000) Thanks Murali

              P 1 Reply Last reply
              0
              • N Nishant Singh

                Better approach is put a search option , when the user puts a Search Criteria the appropriate results would be displayed , Because you could not expect a user to move through all 77000 records

                B Offline
                B Offline
                ballameharmurali
                wrote on last edited by
                #7

                Hi , Search option is not accepted here. So is there any other way to display data. Thanks Murali Murali

                C 1 Reply Last reply
                0
                • B ballameharmurali

                  Hi, Yes but the problem the problem is if the paging is enabled also the page is not not displaying due to huge data i think .Is there a way to Display all the records(77000) Thanks Murali

                  P Offline
                  P Offline
                  padmanabhan N
                  wrote on last edited by
                  #8

                  have you calculated the time taken to fetch the data in which back end you are using... because if it takes long time in database then you have to follow indexing... and in the database if the query returns the value soon then there is prolem in your code... Any how can you send your code for further clearance....

                  Padmanabhan My Articles: Articles[^] My latest Article: Word Automation[^]

                  1 Reply Last reply
                  0
                  • B ballameharmurali

                    Hi , Search option is not accepted here. So is there any other way to display data. Thanks Murali Murali

                    C Offline
                    C Offline
                    Christian Graus
                    wrote on last edited by
                    #9

                    What do you mean by 'not accepted' ? Do you mean you have a client who wants to show 77000 records on one page of a website ? Can you think of a single website that shows this much information ? If not, how do you know it's possible, assuming it was at all advisable ?

                    Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

                    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