Forms Data Controls :: GridView Slows Down Going From VS 2005 To 2008?
Mar 5, 2010
I just upgraded one of my solutions from VS 2005 to 2008, and it completed successfully. The only thing that changed in the solution was that I went from .NET 2 to 3.5 framework.
Now when I debug and select a page where a GridView displays a table of 4580 rows the time to display it goes from 5 seconds to 5 minutes. Everything else in the project behaves as normal. Why would performance degrade on one GridView when going to VS 2008?
It's also noteworthy that changing the GridView parameters to AllowPaging="True" PageSize="25" will return performance to under a second response, as one might expect.
View 3 Replies
Similar Messages:
Nov 17, 2010
I have a gridview to display data. I want to add a button to export the content of the gridview to Excel, It is possible in this case, Could you show me the step if yes. I am using VS 2005
View 3 Replies
Apr 16, 2010
I have the gridview inside another gridview, i want to sort that both gridviews, I don't know how to achieve using asp.net 3.5 visual studio 2008 c# code behind. Following are my aspx page,
<div
id="divclm"
runat="server">
<asp:GridView
ID="claimgrid"
runat="server"
AutoGenerateColumns="False" AllowSorting="True"
Width="100%"
AllowPaging="True"
CssClass="gareahead"
EmptyDataText="No Records To Display"
OnRowDataBound="claimgrid_RowDataBound"
OnRowCreated="claimgrid_RowCreated"
GridLines="Both"
OnPageIndexChanging="claimgrid_PageIndexChanging"
OnSorting="claimgrid_Sorting"
CaptionAlign="Right">
<Columns>
<asp:HyperLinkField
Text="<img id='upimg' src='Styles/Images/appschg.gif'/>"
ItemStyle-Width="10px">
<ItemStyle
Width="10px"
/>
</asp:HyperLinkField>
<asp:BoundField
DataField="name"
HeaderText="Name"
SortExpression="name">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
</asp:BoundField>
<asp:BoundField
DataField="code"
HeaderText="Code"
SortExpression="code">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
</asp:BoundField>
<asp:TemplateField>
<ItemTemplate>
</td></tr>
<tr>
<td
colspan="6"><div
id="<%#Eval("code") %>"
style="display:none;position:relative">
<asp:GridView
ID="Gdclmline1"
runat="server"
AllowPaging="True"
AllowSorting="True"
AutoGenerateColumns="False"
OnSorting="Gdclmline1_Sorting" BorderColor="Green"
BorderStyle="Solid"
BorderWidth="1px"
OnRowDataBound="Gdclmline1_RowDataBound"
OnRowEditing="Gdclmline1_RowEditing" Font-Names="Verdana"
Font-Size="8pt"
Font-Strikeout="False"
OnSelectedIndexChanging="Gdclmline1_SelectedIndexChanging"
OnRowUpdating="Gdclmline1_RowUpdating" PageSize="1000"
RowStyle-Wrap="false"
Width="100%"
CssClass="gareahead"
EmptyDataText="No Records To Display"
GridLines="Both">
<PagerSettings
Mode="NextPreviousFirstLast"
NextPageText="Next"
Position="Top"
PreviousPageText="Prev"
/>
<Columns>
<asp:TemplateField
HeaderText="phone"
SortExpression="phone">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
<ItemTemplate>
<asp:Label
ID="lblphone"
runat="server"
Text='<%#Bind("phone") %>'> </asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField
HeaderText="address1"
SortExpression="address2">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
<ItemTemplate>
<asp:Label
ID="lbladdress1
runat="server"
Text='<%#Bind("address1") %>'> </asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle
CssClass="gr"
Height="100px"
HorizontalAlign="Left"
Wrap="true"/>
<SelectedRowStyle
CssClass="gr"
/> <PagerStyle
CssClass="gareahead"
HorizontalAlign="Left"
Wrap="False"
/> <HeaderStyle
CssClass="ghead"
ForeColor="White"
Wrap="true"
/> </asp:GridView>
</div>
</td>
</tr>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerSettings
Mode="NextPreviousFirstLast"
NextPageText="Next"
Position="Top"
PreviousPageText="Prev"
/>
<HeaderStyle
HorizontalAlign="Center"
VerticalAlign="Middle"
CssClass="ghead"
ForeColor="White"
/>
<RowStyle
CssClass="gr"
/>
<SelectedRowStyle
CssClass="gs"
/>
</asp:GridView>
</div>
that aspx page contains gridview that contain one more gridview inside in it.Now i want to sort out both the grid i.e)claimgrid and Gdclmline1 i want code in c#.
View 3 Replies
Jul 6, 2010
We currently have a DB in SQL 2005 and would like to convert it to SQL 2008 taking advantage of all the new features (if there are any) in SQL 2008. Would like to know the best approach or if there are any tools which can convert all the tables/views/storeprocs etc to 2008 specifications...
View 6 Replies
Feb 20, 2011
I have a web page with some textboxes and some buttons on it. There is also a dropdown list. By experimenting I have discovered that the dropdown list, which has several thousand items in it, slows the page down considerably just by being there. I tried the following code in the datasource for the dropdown:
[Code]....
which didn't work. I also tried removing the datasource and populating the dropdown in code in the page load where not ispostback and that didn't work.
View 8 Replies
May 7, 2015
When I am featching binary images from database and displaying in datalist on asp .net image cotrol. The image display getting too much time. When I click on next button also I take too much time for display next image.
View 1 Replies
May 18, 2010
Currently I am working in Sql server 2005. I do not know the Sql Server 2000 and Sql Server 2008. what is the difference between Sql server 2005 and 2008?
What is the Difference between Sql Server 2000 and Sql Server 2005
View 3 Replies
May 24, 2010
How could one set a password on a database in Sql server 2005 & 2008
View 3 Replies
Feb 3, 2010
we can open an SQL Server 2005 DB in SQL Server Management Studio 2008 EXPRESS, woith out it converting to 2008?We want to connect to a remote sql 2005 server in sql server management studio 2008 EXPRESS.
View 1 Replies
Apr 4, 2010
I have in my laptop VS 2003, VS 2005 and VS 2008. I am making some SMS application in which I am using some DLL which need asp.net 3.5 so I am making application VS 2008. Now in my application I am using DAL and BLL method where in I am making .xsd file with TableAdapted from that I am making BLL files.
I added Formview in my aspx page configure it with Objectdatasource . IDE was not invoking the wizard for objectdatasource after lot finding. I got from some forum that after removing bin folder from application. It will start working. This was the first problem now I add gridview in my aspx page now and configure with Object data source. But when I go property builder of gridview I cannot see Edit Template, I can see only Empty template and Pager Template. Here my question this is new in VS 2008 as when i was working with VS 2005 I could see all Template. Next thing when change anything through property builder, I can see changes in the design view mode but I cannot see any changes in HTML source view. Again when I switch back to HTML source view to design mode all changes will go away. Why is it so !! For more info I will put my aspx, aspx.vb page code here.
[Code]....
View 1 Replies
Apr 27, 2010
I have a project that I developed in VS2005 and that has been put into VSS. I am trying to "get" it on a new machine and convert it to VS2008 because that is what is installed on the new machine. I am having problems with it that I think originate in its working folder. So my basic question is, when you try to work with a solution that's in VSS should you maintain the same folder structure that it had when it was originally checked in? I'm not particularly happy with its original structure because it goes on and on seven levels deep, and I wanted to just cut it down to C:ProjectsResNew, but if that's what it takes to get it to work, I'll do it.
View 10 Replies
Mar 25, 2010
how to install microsoft sqlserver 2005 or 2008 on window 7 with x64 bit.It works perfectly on vista but on getting a new system which comes with window 7 and x64bit i was unable to load the software onit except my visual studio 2008.
View 1 Replies
Jun 16, 2010
C:Program FilesMicrosoft SQL Server100COM>tablediff -sourceserver "warehousebox"
-sourcedatabase "table1" -sourcetable "siqvirtual" -destinationserver "mainbox" -de
stinationdatabase "table1" -destinationtable "siqvirtual" -destinationuser "sarah"
-destinationpassword "hello" -strict -f "c:fooDiff.sql"
Since these table are on two different boxes and 2 different versions, I am getting error message that tables cant be compared because they have different schema's.Schema's are the same but they are on different machines and different servers. What is a work around it?
View 2 Replies
Jul 19, 2010
i m having sub-grid/Nested Grid concept using grid view control ., i.e., inside grid in sixth cell i m having another grid.,
i n Sub-Grid i m having The Follwing Events
OnRowDataBound="Gdclmline1_RowDataBound" OnRowEditing="Gdclmline1_RowEditing"
OnSelectedIndexChanging="Gdclmline1_SelectedIndexChanging" OnRowUpdating="Gdclmline1_RowUpdating" ., all the events are working Fine Except OnRowUpdating="Gdclmline1_RowUpdating" this event.,
we are developing the software in Visual Studio 2008 ., our Server is Visual Studio 2010 .,
in my development machine its working fine., but in Server machine its row updating event not working .,
note:- we have used proper conversion method from vs 2008 to vs 2010
View 11 Replies
Apr 20, 2010
is it possible to use databases orignally made in sql express 2005, in SQL server 2008? and is there any method on how to do this?
View 2 Replies
Mar 1, 2010
Can Visual Studio 2008 Gridview control do grouping? And how?
View 1 Replies
Feb 8, 2010
I am using C# and VS 2008 with access database. I have a nested gridview (2) with two access database tables. Date1 (takes System date) is the primary key in table1 and also present in table2 as foreign key. User data is stored in gridview 2 w.r.t to the date in gridview1. What i am tryin to do is to mail todays date (System date) data of Gridview 1 and data corresponding to it in Gridview 2 to a specific mail id.
View 8 Replies
Mar 10, 2011
I used SQL SERVER 2008 R2 express as my web development database and I set its compatibility level to 2005. Unfortunately this database cannot be be attached to SQL server 2005. Are there any other options?
View 3 Replies
Oct 6, 2010
I have generated insert unicode script in sql 2005 the run insert script sql 2008 database has problems show
What should I do ?
View 12 Replies
Mar 11, 2010
My company is running into a problem with a web service that is written in C#/ASP.Net. The service receives an identity key for data in SQL Server and a path to generate and save a PDF report for this data.
In most cases, this web service returns results to the calling web pages very quickly, usually within a few seconds max.
However, it seems to occasionally hit a significant slowdown. The web application calling the web service will generate a timeout error when this slowdown occurs. We have checked and the PDF does get created and saved to the server, so it looks like the web service eventually finishes executing. It seems to take about 1 to 2 minutes for processing to have completed. The PDF is generated using ActiveReports from Data Dynamics.
Wwhen this problem occurs, making a small change to the web service's config file (ie, adding a blank space to a connection string line) seems to restart the web service and everything is perfectly ok for a period of time afterwards.
Other web applications that are running on the same web server do not seem to experience this type of behavior, only this particular web service.
I have added the code for the web service below. It is basic calls to 3rd party libraries. We are not able to recreate this problem in test.
[WebMethod]
public string Publish(int identity, string transactionType, string directory, string filename)
{
try
{
[Code]....
View 2 Replies
Jul 8, 2013
My asp.net site has very good performance on local ips on all the systems. But it 5 time slow down on live ip.
1. What could be the issue:
Server is not capable? I have checked the ping and it response time is 153 ms for each require on live ip but on local ip it gives < 1 ms response time.
2. I have not compile the solution just copy and paste on the iis and create virtual directory?
View 1 Replies
Jun 17, 2010
Migrating SSIS package from SQL Server 2005 to SQL Server 2008
View 1 Replies
Feb 25, 2010
Previous developers have developed a .SSISDeploymentManifest file (SQL Server 2005) to install SSIS packages which prompts a Package Installation wizard. I tried to install it on SQL Sever 2008 (it works on SQL Server 2005), but it failed with the error: "Storing or modifying packages in SQL Server requires the SSIS runtime and database to be the same version. Storing packages in earlier versions is not supported".
How do I install 2005 SSIS packages on SQL Server 2008? I have all the .dtsx files, not sure how to install them?
View 2 Replies
Mar 24, 2010
Does anyone know, what is difference between SQL Server 2000, 2005 and 2008?
View 3 Replies
Jul 28, 2010
I have been asked to replace DATAGRID with GRIDVIEW on WEBFORM1.ASPX. For Pagination, I am having problem due to lack of knowledge to replace page 1,2,3,4,5,6,7 8, 0 with NEXT , PREV like I did it for DATAGRID. Have to use NEXT and PREV because the GRIDVIEW Pagesize = 20 while the rows from the TBLSALESTRANSACTION exceeded 350rows
View 6 Replies