Forms Data Controls :: Improve Performance: To Display Data In DataGrid?
Mar 26, 2010
I have an SP in backend that retreives multiple recordset/DataTable where each recordset/Datatable contains 10 records and 8 columns.
The Count of recordset/Datatable differs based on parameters.
The SP retreives Data in nearly 0.01 seconds.
I have been displaying the records by looping each Datatable and each record in DataGrid Template Control, this way the page loads very slowly.
Can some one please suggest me on how to display/Load the data more efficiently and faster in front end ASP.NET 2.0?
Can I perform some Multithreading to display records from different datatables?
View 2 Replies
Similar Messages:
Feb 17, 2011
I am trying to speed up a Gridview on my page that reads 8,000 records using an AccessDataSource. So I am trying to implement caching. I have used the information given here: [URL] but it has made no difference in the response time. Can anyone direct me on this? Is there something you have to specify in the gridview (besides the datasource). Would it work if I went to SQL Server?
This is my AccessDataSource code. You can see the 3 relevant lines starting 6 lines from the top.
[Code]....
View 1 Replies
Oct 4, 2010
i am using data gridview asp.net control and i bind it dynamically, gird displayed 80,000 thousands records so i am using paging techniques,on each page gird display 10 record so when i am change page each time gird should filled 80.000 thousands records so how could i bind gird from pageIndex,pageSize rather than bind it whole records
Code]....
it works properly but when i change page or grdTender_PageIndexChanging event fire each time gird fill with 80.000 records now i want to bind it from current pageIndex to current page size to improve the performance of datagird
View 5 Replies
Mar 8, 2010
I have selected around hundred data and then bind to the repeater each times it take a long time to save data after clicking the save button. How can i improve the performance?
View 6 Replies
May 5, 2010
I have one online school management application developed on asp.net 3.5 using Linq,
Now in my database i have main three talbes which uses in many store procedures,functions,linq join query
CourseMst - Master Table Have CourseID P.K.
StudentMst - Master Table Have StudentID P.K.
Student_Course - Child Table Have StudentCourseID P.K
StudentID F.K. Reference To StudentMSt
CourseID F.K. Reference To CourseMSt
Now i want to increse speed of my application for those page which have query or sp related to above tables,
I want to know about indexing procedure that how to apply indexing and on which field i have to apply indexing
View 5 Replies
Jun 5, 2010
I had created a web site with asp.net and sqlserver. How can i improve the my website's performance in with regard sqlserver connection?What's your mind about use pool connection? In this regard what the defualt values is set for 'Max Pool Size' and 'Min Pool Size'?What's your mind about use Asynchronous access to data? What's your mind about other ways that you think?
View 3 Replies
Mar 21, 2010
I have a select query where iam fetching the data from minimum of 7 different tables by using innerjoin. I have 3 lakhs of records in that table.BY using cache Iam fetching all 3lakhs of records at a time and put in cache. by using the rowfilter i use the records.firsttime when iam fetching these 3lakhs records it takes 3min. want to improve the performance of time.How to improve the performance of time?
View 1 Replies
Feb 3, 2010
I am using Sql server 2005. I have a stored procedure, which has a select statement to retrieve thousands of data from the table.
The time taken to execute is longer and hence affecting the performance.
[Code]....
Here, id is the primary key. Clustered Index is also set.
How to improve the performance of the stored procedure?
View 13 Replies
Feb 2, 2010
I have web application in ASP.NET 2.0 and C#.I have a gridview and i have a checkbox in the gridview. I am trying to save the checked record from the gridview to the database. The time taken to save the data is becoming huge and causing performance issues.
[Code]...
View 8 Replies
Aug 7, 2010
I see bugs? give me your opinion really improve my site es [URL] this is metasearch fly meta search flights
View 2 Replies
Jul 14, 2010
I am working on finance domain, we are using many sessions and viewstates for store values and data. Our clients want fast speed of our website. We are using grid/repeater/datalist and chart controls for show data.
View 3 Replies
Jun 3, 2010
I am working on AJAX-ASP.NET site. This site is taking 25-30 sec to load the contents. I want to improve this site performance. Is there any settings required in IIS? How to check IIS log files?
View 2 Replies
Feb 16, 2011
how to improve the performance of dynamically load user control
View 1 Replies
May 1, 2010
I designed a web page in that i'm getting the query and executing the query, if a single user enters some query then the time won't be a matter, but if more than one person is accessing the webpage, then it will make delays to execute the queries,
how can i improve the performance of this page like making the results to be displayed more faster?
View 6 Replies
Mar 9, 2011
the initial data load for the Silverlight app, can take 6 -20 seconds. We are using web service, data is coming from one database and loads 2 years worth of transactions. We don't use summary tables. we are not doing insert/update/delete, just display.
View 4 Replies
Jan 13, 2010
Does anyone know of a data control that displays the columns vertically?
Example
First Name Bill Bob
Last Name Smith Jones
Middle Initial A C
View 2 Replies
Feb 20, 2010
i want to display a multiline text in a datagrid i insert the text in a textbox outside the datagrid.
the textbox wraps the text if it doesnt fit to the textbox length.then i push a button and insert that text in a database. then i want to display this text in a datagrid.i use two options in a label or in a textbox in a templatecolumn but with the textbox <asp:textbox ID="textbox1" runat="server" style="overflow:hidden" Font-Size="15px" BackColor="#FFFFC0" TextMode="multiline" Width="750px" Wrap="true" borderstyle="None" BorderWidth="0" Text='<%# Databinder.Eval(Container.Dataitem,"text_caption") %>'></asp:textbox>
i receive only the first two lines
and with the label
<asp:Label ID="Label112" runat="server" BorderStyle="None" Width="750px" BorderWidth="0" Text=' <%# Databinder.Eval(Container.Dataitem,"text_caption") .ToString.Replace(chr(13),"<br />") & "<br/>" & "<br/>" %>' ></asp:Label>
if the text is too big without an enter(that text wraps in the outside inserting textbox) then the datagrid width becomes too big although the text is diplayed normal with new lines so in the datagrid i have much space without characters the textbox that i use to insert new text is here <asp:TextBox D="tbox_text_caption" runat="server" Height="232px"
Style="left: 400px; position: absolute; top: 8px" MaxLength="750" TextMode="MultiLine" Width="752px"
Wrap="true" TabIndex="5" BackColor="#FFE0C0"></asp:TextBox>
View 5 Replies
Jan 18, 2010
I have datagrid, View details button on the datagrid. If I click on the button, It will redirect to another page with all the details.I have update button and return button on that page. If I click on update, It will update data in the database. If I click on the return button, It will return to previous page which has datagrid but I want the update details in the datagrid. I have a big doubt, how to store that datagrid so that we can retrieve data on return button
View 2 Replies
Feb 22, 2010
I have left menu navigation which is a datagrid. They are linkbuttons. When clicking it, it will display related data based on the value passed from the link. But if the passed value is a specific value, it is not displayed data in the right pane; instead, it will displayed a submenu of the link.
View 1 Replies
Feb 16, 2011
I have developed a gridview which has displays 8,000 records. However, the user is compaining that it is too slow. A major function of this gridview is to filter on two of the columns. It seems to me that if the records were stored in memory it would be much faster. This is caching, I think. Is that the case? Since filtering is being done I don't think custom paging will help much. When they submit a filter, with custom paging wouldn't the entire table be read again? So I was thinking of trying caching which is available on SQL Server. Am I on the right track? Can you cache with an Access database? Can you think of any other ways to improve performance of a gridview?
View 1 Replies
Mar 30, 2011
My scenario is : WebApp -> WCF Service -> EDMX -> Oracle DB
When I want to bind grid I fetch records from Oracle DB using EDMX i.e LINQ Query. But, this degrades performance as multiple layers take place between WebApp & Oracle DB. Can I use caching mechanism to improve the performance? But as far as I know cache is shared across the whole application. So, if I update cache other user might receive wrong information. Can we use caching per user? Or is there any other way to improve performance of the application?
View 2 Replies
Mar 25, 2011
successfully querying an excel file the problem is when im about to display the data im worried that even the rows from excel that do not have actual data is being pulled is there any way that i can query only the rows that contain data
View 2 Replies
Feb 22, 2011
can i display columns inside the datagrid footer? if can.. i can i have the syntax?
for example: i have a columns in the datagrid which is binded to database. at the column footer.. i want to display another column.
View 45 Replies
Mar 19, 2010
I need to read data in DataGridView from one page to display using label in Other Page.I think here using QueryString concept. i cant remember the coding for QueryString and How to get Query string in another web page.Please give the sample coding using C# for me.
View 4 Replies
Oct 11, 2010
I am having a bit of frustration trying to display an image save in a folder after upload in a datagrid. The image path is being return but the image does not displays. When I check the image properties is empty. THis is what I've been trying.
[Code]....
Here is where the image is being save: imagePath = "C:\inetpub\wwwroot\soweb\page_images\image1.png" If I change the path in the database to: page_imagesimage1.png, the image is display in the datagrid.
View 1 Replies
