I wanna bind atleast 30,000 records in a gridview from a sqlserver table. I want to bind only 50 records at a time with grid view. The grid has also paging and when I click next page then next 50 records should be shown and another next page's click another 50 records.
How can I optimize this thing. I want that If 30,000 records are binding then grid should be work as binded 50 records.
this is my code
[code]....
basically, the InstellingGegevens table gest filled in by some procedure from another server.
the thing i then need to do is check if there are new records in this table, and fill in the new ones in Instellingens.
this code runs for like 4 minutes on 15k records. how do I optimize it? or is the only way a Stored Procedure?
this code runs in a timer, running every 6h. IF a stored procedure is best, how to I use that in a timer?
[code]....
I am looking for a way to improve user experience on a UI that can display on average 3K records in the Grid. Today's implementation limits grid on the page to 20 records with a "Next" option to continue through the data. Requirement is to load all of the available data in one shot and allow Sorting, Filtering, etc.
Environment: ASP.NET 3.5 SP1, WCSF 2.0, IIS 7.0
I have Mysql database.In that some records status is New.now,I bind database table to Listview(asp) control.
What's my problem is,the New status records(from Mysql database) text in Listview(after binding) is visible in
bold format.
here's what i'm doing:
1. i'm retreiving data through API(atom format),
2. i'm storing all retreived data in a datatable,
3. i'm binding this datatable to a gridview
the porblem is that these APIs are feeding thousands of records, so each time i'm paging a new page_index i have to go through all ofl the above steps (1, 2 and 3)this procedure is taking a lot of time
i believe there is a faster way to do that ,
I have defined the following in my gridview markup (simplified):
<asp:GridView ID="grvReport" runat="server" DataSourceID="odsReport"
AutoGenerateColumns="False" DataKeyNames="EntryDate,EmployeeNumber">
Then I define my datasource's update parameters as such:
<UpdateParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="IsJustified" Type="Boolean" />
[code]...
Gridview Print PAge coming blank
for below code
but if I comment
GRDV.AllowPaging = False
GRDV .DataBind() this code then it page is not blank
I want to print complete Gridview
Code is :
Protected Sub PrintAllPages()
GRDV.AllowPaging = False
GRDV .DataBind()
[Code].....
i have an Grdiview within that two table is there, one is for header another is for body section, now the horizontal line is coming on the gridview but vertical line is not coming, below is my code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
CellSpacing="1" CellPadding="0" AllowPaging="True" PageSize="200"
CssClass="searchResult" OnRowCommand="GridView1_RowCommand"
OnRowDataBound="GridView1_RowDataBound">
<HeaderStyle CssClass="searchResultHeader" HorizontalAlign="Center"/>
<RowStyle BackColor="#ecf5ff" ForeColor="#333" Font-Size="11px" Height="30px"/>
<AlternatingRowStyle BackColor="white" ForeColor="#333" Height="30px"/>
<Columns>
<table cellspacing="0" width="100%" >
<HeaderTemplate>
<tr>
<td>...some asp controls</td>
<td>...some asp controls</td>
<td>...some asp controls</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<table cellspacing="0" cellpadding="0" style="width:100%;" >
<tr style="height:30px;" >
<td width="5%" style="font-
size:11px;height:30px;width:5%;" >
<td width="5%" style="font-size:11px;height:30px;width:5%;" > ...........................
so, horizontal line( _ ) is displaying, now i want to show the vertical line(|)
I have a gridview with a select button. There are 181 records in the gridview all coming from the same database table. When I select the first 5 rows the details view comes up, but after that it doesn't show... The information that it is pulling is the same for the first 5 rows as the other 176 rows. Why won't it show the detailsview?!
View 2 Repliesi designed a gridview with HeaderStyle Freeze like this
<HeaderStyle CssClass="FreezeMe" Wrap="true" />
.FreezeMe
{
background: #ecf5ff;
color: #333;
background-color: #6D91BF;
border-style: solid;
border-width: 1px;
border-color: #9cc9ed #5c9fde #6daddb #b4d2f0;
font-weight: bold;
text-align: center;
color: white;
text-decoration: none;
font-size: 13px;
position: relative;
top: expression(this.offsetParent.scrollTop);
z-index: 10;;
height:40px;
font-size:30px;
}
i have applied my gridview within DIV tag because i need horizontal scrool bar(if no. of record is high) but i didnt see the scrollbar ...
I want to add Footer total at the end of the gridview but I am getting total but its incorrect/i used below code..my Gridview Header look likes
| AMIN | WHTE | BLCK | MULT | ASIA | PACI| Total
Dept no | Dapartment Name | F | M | F | M | F | M |F |M| F | M | F| M |F Total|M Total| Grand Total|
I want to add Footer total at the end of the gridview1
In my database having 50 records,i wnt to display the first 10 record on first page of gridview and next 20 record on second page and so on..
View 1 RepliesI have the following situation: excel-like application, that is accessible from internet.
2 users access it and I want the moment one user clicks on a cell, the other user to see that. (like in google documents).
My questions are:
Can I do this using standard UpdatePanel, while I keep the bandwidth usage to its minimum (in other words, only information for the current cell is passed, not the whole huge table), or should I implement my own ajax scripts on the page in order to get it optimized.How to do the updating : one way is to have a timer on the page and update it periodacally, the other way is to make a request and keep the connection opened till a change is made (using some heavy timeout, let's say 1 minute). Can you give me clues (like ajax libraries I can use, can I do this with the standard ajax controls in asp.net, ways to implement the live connection)?
In my application
[code]....
is called on every page post back ,which fire query in db and bring 270 roles.
That can be optimized?
is it possible it called once at the time of login only.
My colleagues have create a website and there is a webpage which contains a Tab.
He Implement the tab with the following method:
1.Load all content of the page
2.Use javascript to display those group content as block and organize them into tabs.
3.when user click one tab, then acitve it, and hide all other tabs.
And these functions works very well, but the performance is bad:
1.Load all contents cost lots of time
2.It will show all content at first, and then shrink to a tab control. When the user see this, it might think this is a bug of our system.
If I have an object I need to store in viewstate, what kinds of things can I do to optimize the size it takes to store the object? Obviously storing the least amount of data will take less space, but aside from that, are there ways to architect the class, properties, attrbutes etc, that will effect how large the serialized output is?
View 3 RepliesThe web app uses XML from a web service, which is then transformed to HTML using XSLT. The app uses a HttpModule to get the XML using AddOnPreRequestHandlerExecuteAsync.
Classes Used:
XmlDocument - stores the xml.
XslCompiledTransform - stores the transform, is cached in Application.
Asynchronous HttpWebRequest using BeginGetResponse/EndGetResponse
HttpModule with hooked AddOnPreRequestHandlerExecuteAsync events.
I do not want to use the XPathDocument unless there are no other possible optimizations. It would take some complicated code to get all the XML together without the ability to write to the XmlDocument. There is additional XML that does not come from the web service that must also be added to the document.
on the aspx:
[code]....
The problem here is that instead of using Two repeaters, can we use only one?
We actually need the header to be separated from the contents using a different table row...
Edit: changed rptHeader's ItemTemplate's html element from <td> to <th> to be a little clearer.
There's so much hype about ASP.NET MVC these days, but the truth is that ASP.NET webforms is not going anywhere for some time. Is there any way for current developers to optimize ASP.NET webforms to perform as fast as ASP.NET MVC?
I have noticed a significant difference in speed between ASP.NET MVC and ASP.NET webforms. MVC is a lot snappier and loads pages faster than webforms. Can I achieve the same with ASP.NET webforms by optimizing it? If yes, what would you recommend?
I have an asp.net mvc application that spawns a Process as follows:
Process p = new Process();
p.EnableRaisingEvents = true;
p.Exited += new EventHandler(p_Exited);
p.StartInfo.Arguments = "-interaction=nonstopmode " + inputpath;
p.StartInfo.WorkingDirectory = dir;
p.StartInfo.UseShellExecute = false;
p.StartInfo.FileName = "pdflatex.exe";
p.StartInfo.LoadUserProfile = true;
p.Start();
p.WaitForExit();
Before going further, I need to know whether, e.g., pdflatex.exe is a managed code or a native code? Edit 1 I need to consider this because: (Hopely I am not wrong...) Each Asp.net application runs in an separate/isolated AppDomain as opposed to a separate/isolated process. A native executable cannot live in an AppDomain.to be continued.. Shortly speaking, I hope my site does not spawn a new process for each request. Because a process is more expensive than an application domain. Edit 2 My asp.net mvc application allows users to submit LaTeX input commands such as $ax^2+bx+c=0$ to be converted to a pdf file rendering an quadratic equation. Behind the scene, this web app will spawn a process executing pdflatex.exe. The job of pdflatex.exe is converting the LaTeX input commands to pdf document.
we have this problem but can't find a solution. We have an application that references something like 24 dlls. When you invoke the application the very first time (after the application is for any reason reset) it takes 25-40 seconds to start loading contents.
This is what we tried:
1. precompile and publish everything in release mode
2. removing pdbs from bin folder
3. put strong named assemblies into GAC
4. set application to debug = false
consider that the whole bin folder is composed by 24 dlls for a total size of 28MB. Just 4 of these dlls are strong named and they are more and less 25MB. Nothing seems changed. What happens EXACTLY when the application is started is something I couldn't find in any book nor forum/blog/post... What can we monitor more to find where the problem is?
I posted a question about using AutoCompleteExtender. It simply shows users all available email addresses when they type in a letter(prefix).
It works, but the problem is it loads to late :( takes around 5 seconds to pull out the list.
So I would like to optimize this
The part I would like to optimize speed is:
[Code]....
I've been developing a game using Silverlight 4 and silversprite (http://silversprite.codeplex.com/)
This game is HEAVILY content dependent, using a lot of audio and images. My content folder is around 90 mbs worth of stuff. And because of that, my XAP file is around 60 MB, and takes 5 minutes to download from the website before any user can start playing.
I am using Visual Web Developer 2010 to create my site and load the XAP. Is there a way where I can take content out of my XAP and put it in my ASP.net site project? Or perhaps upload my content files to the site's storage?
This would make my XAP file much quicker to download.
Do you know of a library/httpmodule for logging slow loading pages (perhaps for a specific treshold) in an ASP.NET environment?
Google did not yield any results.
It would not be too hard to implement on my own, but why re-invent the weel.
In my website, I am using thread to perform a repetitive process in background. Now the process takes around 30 to 45 seconds to update the database.
Basically the function performs the following:
1) Download the CSV from a website.
2) Parse the CSV and update the database tables.
I want to optimize the performance and decrease the time it takes to 15 seconds.
How can I do this?
EDIT:
Here is the Code:
[code]....