need to sanity check what I think is correct. If I have some LINQ entity relationships that I create in code thus:-
[Code]....
these would lazy load, by default - correct? And if the first link was changed to
[Code]....
this would also lazy load and defer loading until GetObjectLink() was called, yes?
Old hand at ASP.NET, new to the UpdatePanel. I have a reporting page which executes a fairly length SQL query... takes about 10 seconds right now. What I would like to do is have my page fully render, with some placeholder text (Loading...) and then have the UpdatePanel kick off the actual time-consuming reporting process and render the report when it's done.
So... my theory is to use RegisterStartupScript() to kick this off and drop the string from GetPostBackEventReference() to trigger the UpdatePanel update. Some problems crop up:
1) Can I actually use GetPostBackEventReference w/ the UpdatePanel or do I need to trigger it some other way? Use this method on a button inside the Update Panel?
2) What event gets triggered when the postback reference is the UpdatePanel? It's not clear to me. I've got to call my databinding code somewhere! Again, maybe I need to use a button inside?
I have a requirement like need to display 5000+ records in gridview. So, I created scrollable div with gridview init and displaying 200 records per page. The website is running very slow because eveytime when user click on paging, it retrieving all the records from the database. I need to increase the website performance. I heard about a concept Girdview lazy loading but i don't know how to implement. I am looking for a solution like records should display in gridview when ever user scroll the bar down. How to do the gridview lazy loading.
View 1 RepliesAfter loading updatepanel through Timer, i am unable to make any async request from the updatepanel.
sample aspx Code:
<asp:UpdatePanel runat="server" UpdateMode="Conditional">
<ContentTemplate>
<%--The Timer that causes the partial postback--%>
<asp:Timer runat="server" Interval="100" OnTick="Timer_Tick" Id="Timer1"/>
<asp:ImageButton ID="btnSaveEmployeePrevJobs" runat="server" ImageAlign="AbsBottom"
ImageUrl="~/Images/saveOff.gif" onmouseout="this.src='../Images/saveOff.gif'"
[Code]....
Does the entity framework come with some inbuilt mechanism for lazy loading?
View 1 RepliesAt present I am using ajax:TabContainer for the tabs. As you know that does not do Lazy loading. Can sonone give me links to or some code examples to do Tabs with Lazy loading. I know that the Jquery tabs do lazy loading but there are no complete examples on the web which tells you on how to do lazy loading with JQuery tabs.
View 4 RepliesI am developing a website that has more and more LINQ queries. I have been keeping down the download size, optimizing the images, js, css and using HTTP Compression. I notice however, that now that I am using more LINQ queries and more complex queries, join and group joining queries, the 'waiting' time that the browser is doing is going up. The KB size of the page isn't any greater, but the page ultimately takes longer to load.
I have been reading up on LINQ and the behind the scenes of how it works. I have found that I need to use DataLoadOptions for the queries that join/group join to reduce the round trips to the database. I haven't had a chance to work on this yet, so if anyone has any great resources on this or tips, I'd appreciate it.
My main question about LINQ to SQL in this post is, if I have a bunch of queries throughout my site, in the masterpage, and the page itself, if I do not put .ToArray() at the end of the query, does that speed it up? If I leave ToArray() off of all the queries, do they then execute all at once when the page is loading instead of each time the page gets to that specific line to read and execute it?
I may be asking a dumb question, since I don't know a whole lot about the behind the scenes of LINQ yet, or the compiling of the page. I am using VWD 2010, so it does not have the SQL Profiler for me to test what I am asking.
I want to build a business object such as an employee class, but I know that 80% of the properties will barely get used. So I wanted to know how I can create the object with the important properties in the constructor and lazy load the ones that are barley used when they are needed (if at all).
I am using asp.net with c#.
I've got this problem.I launched an ASP.NET website with the Umbraco CMS on an ISP.(Its just a very basic informative site. nothing special.)When I go want to visit the website however, the first pageload takes a lot of time, sometimes even up to 20 seconds. Of course this is ridiculous. Afterwards, I am able to navigate the site relatively quick.. So every first pageload is slow, then everything is OK, more or less.Does anybody have any idea what the problem could be? Would it be IIS? ASP.NET?
View 5 RepliesAt present we are using <ajax:TabContainer> to load tabs. I have 5 user controls inside <ajax:TabPanel>.
The problem is that all the data on these 5 pages gets loaded at once and increases the loading time as well as it is very hard to debug. Can we do lazy loading uisng TabContainer control? so that only the data of the current tab is loaded and when we click on the other tab then that's control data gets loaded.
I'm planning to fetch data to illustrate about the yearly sales achievement for last 3 years by showing seperately in grids in three different ajax tabs. i prefer to lazy loading of the data to the grid in each tab. is there a way to achieve this on the change event of the tabs.
View 1 Repliesload bcp utility from C# code? I need to do that for .NET 1.1.
I need to move data from a flat file to a database, I was suggested to use BCP. Are there any other options in .NET 1.1?
I am using 2 data tables one for comparing the i.item-id=dr[datacolumn] and one for storing the result i.item_guid,i.item_description_title. But getting an error at table2.Rows.Add(itemlist) {"Input array is longer than the number of columns in this table."}
DataTable table2 = new DataTable();
foreach (DataRow dr in ds.Rows)
{
foreach (DataColumn dataColumn in ds.Columns)
{
pfDataContext pf = new pFDataContext();
var itemlist = from i in pf.item_tbls where i.item_id == dr[dataColumn].ToString() select new { i.item_guid, i.item_description_title };
table2.Rows.Add(itemlist);
}
}
If I have a DataTable (in-memory) read by my C# program from a flat file, and I want to create it as a new table in a SQL Server database... what is the simplest way to do that?
It seems like something like SqlBulkCopy with an option to create a new destination SQL server table would be on my line of thinking, but I dont see a way.
I am trying to load data from an existing DataTable into a new DataTable. Not sure how to get it started. Do not want to merely copy data, I need to load it in row by row.
protected DataTable GalleryByCat()
{
// GLinks is the new DataTable I want to construct and bind to a DataList, Repeater, ListView
[code]...
When using the DataTable.Load(SQLDataReader) method, if the datatable is a property of a class, the set method is not called to populate the object. For example...
MySQLDataReader = command.ExecuteReader();
if (MySQLDataReader.HasRows)
myObjDataTable.Load(MySQLDataReader); -- The result of this will be 0 rows returned. The "Set" method of the object is never called.
I have a SqlDataSource setup in the markup on my page. After some new requirements, I am trying to find a way to modify the SelectCommand before the data is filled for the first time. The SelectCommand below will now be used by default since we'll always have the first param. I am faced with a need to modify the SelectCommand though, adding a second session parameter along with it. I tried to override the OnInit method but it didn't seem to help...it still used the default query. Is there a best way to accomplish this? Here is the section of markup I am referring to:
[code]....
cannot find any examples of how to lazy load the Infragistics UltraWebTree v6.3I found that the docs on the Infragistics site tend to be limited to the latest version of their controls, but this is a legacy app which I am unable to upgrade. Has anyone got example code or links which demonstrate how to lazy-load nodes in this control?The current implementation that we have loads 1.35MB of html because it is populating the entire tree!!
View 1 RepliesI have update panel on the page to avoid postback and placed a dropdownlist control within that update panel. DrodownList is filled with Category names and also it's autopostback set to True.
Now whenever dropdownlist index change's on select, untill page loads complete data it should show mesage as "Loading.... in center and middle of the page and background should become bit transparent". And when page load completely with data then that background and message should get disappear.
i have developed my asp.net application along wih crystal report .... i need to show loading image on ever client and server side request .... (i.e) like when ever IE progress bar get loading i want to show my gif loading ... after IE progress bar finish its loading, my gif loading image should disappear .
View 2 RepliesI want to display a loading animation while my page is loading, and when loading is complete then obviously hide it.
I am working in ASP.NET using Masterpages, just wondering there is a a simple way of doing this using JQuery?
i want to lazy initialize ajax toolkit tab
[Code]....
We have installed a web site written by others which is compiled with Visual Studio 2008 and hosted in Windows server 2008 R2.
The IIS connection timeout is set to 120 seconds. But for some pages, the first page loading fails with HTTP 404 error but sequential refresh can bring the page up. The same problem happens for some images which fail to load in web pages. We are not very sure it is network related issue or hosting issue.
First, I would like to apologize, the search on the site wasn't working, so I don't know if I'm missing an existing post or not.
I have a web page that uses a master page file. I am using a third party control from Component One(TabStrip), the tabs are rendered as links on the final page. When a tab(link) is clicked, I need to load the appropriate web user control associated with that tab. Each web user control has its own post backs and methods. I know that I can load the controls on the "SelectionChanged" event of the TabStrip control, but then any postback created by the web user control that is loaded causes the page to refresh and the control was never loaded in viewstate. So, I tried to put my procedure of loading the web user control into the page_init method. This would work, if I could read which link was clicked on from within the page_init method. I tried using a javascript function to run "onclick" of the tabs and within it setting the value of a hidden control. I have verified that the javascript works and that the hidden control's value is getting set correctly. When I get into the page_init method, the value of the hidden control is not readable.
I'm tying to understand the page lifecycle to the fullest, but I don't see what I'm missing here. I know that I need to load the web user controls in the page_init method in order to persist the page as a whole, but how can I get which tab(link) was clicked to know which control should be loaded?
On a dashboard page I'm loading several controls dynamically; the controls always need to be loaded so there is no if (!Page.IsPostBack) code. The problem though is in that in the code-behind, we are using Request.Form.GetValues and a particular dropdown field's value is always null (presumably because the controls are being cleared and reloaded on a postback) and this is triggering an error later on in the page that expectes a value from this dropdown. I have to use Request.Form.GetValues because the page enables dynamically adding rows (each row containing 5+ HTML inputs) via Javascript.
If I check for postback, then the button event of the control does not fire at all but instead the dashboard page is reloaded, and no controls are loaded at all (i.e. the page is blank).
How do I get around this issue? I need to dynamically load the controls at all times, but I also need to retrieve the values via Request.Form.GetValues.
EDIT
Here's what the code looks like, roughly:
(Client-side HTML)
<table>
<tr>
<td align="center">
<select id="Class1" class="txtboxcomm" name="Class1" runat="server" />
<a href="javascript:classFinder('1')"> Look Up</a>
</td>
</tr>
</table>
<div id="action">
<asp:LinkButton ID="ibtnGetQuote" runat="server" OnClick="ibtnGetQuote_Click" CssClass="getQuote" AccessKey="G">Get Quote</asp:LinkButton>
</div>
(Server-side, in ibtnGetQuote_Click - this is actually a loop since user can append multiple rows; "i" is appended to the word "Class" to find the exact row)
IList<string> classes = this.GetFormValues("Class1");
// This will return null all the time...
private IList<string> GetFormValues(string clientID)
{
String[] values;
values = Request.Form.GetValues(clientID);
if (values == null)
{
Control ctl = FindControl(clientID); // uses built-in FindControl method
values = Request.Form.GetValues(ctl.ClientID);......
The original code was hardcoding the "ctl00$xx$xx" stuff, but the control may or may not be loaded so we cannot guarantee the name the control will get. In fact, I'm not even sure if this will work for all scenarios since only the FIRST control is a server control, the rest are just standard HTML controls so wouldn't have a "ClientID".