gridview slow
-
I have a gridview that loads about 2-50 records. While the query in SQL Query analyzer takes less than a couple seconds to run it takes forever for the gridview to load the data from an sqldatasource in sqldatareader mode. Has anybody has experienced somtehing like this?
-
I have a gridview that loads about 2-50 records. While the query in SQL Query analyzer takes less than a couple seconds to run it takes forever for the gridview to load the data from an sqldatasource in sqldatareader mode. Has anybody has experienced somtehing like this?
Well, a grid view is not loading data, you should have code that does this, which won't be much slower, but then it needs to also generate HTML to display it, along with all the doohickeys you have turned on. A repeater would be faster, but it does nothing, you have to totally style it yourself.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
Well, a grid view is not loading data, you should have code that does this, which won't be much slower, but then it needs to also generate HTML to display it, along with all the doohickeys you have turned on. A repeater would be faster, but it does nothing, you have to totally style it yourself.
Christian Graus - Microsoft MVP - C++ "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )