View Complete Post
I have a page in my website where there is very little code-behind. I only have two lines of code in Page_Load() and the rest of the code is declarative ASP.NET code. I have a FormView control which uses a SqlDataSource to get some order information. The SqlDataSource calls a stored procedure called usp_GetOrderDetails, here's the code for the SqlDataSource:
<asp:SqlDataSource ID="sdsFormOrderDetails" runat="server" ConnectionString="<%$ ConnectionStrings:ForexDB %>" ProviderName="<%$ ConnectionStrings:ForexDB.ProviderName %>" SelectCommand="usp_GetOrderDetails" SelectCommandType="StoredProcedure" UpdateCommand="usp_UpdateOrder" UpdateCommandType="StoredProcedure" > <SelectParameters> <asp:ControlParameter Name="orderId" ControlID="grdOrders" PropertyName="SelectedDataKey.Value" /> </SelectParameters> <UpdateParameters> <asp:ControlParameter Name="orderId" ControlID="frmOrderDetails" PropertyName="SelectedValue" /> </UpdateParameters> </asp:SqlDataSource>
Database setup can be a tough and time-consuming process and sometimes fall victim to human error. Microsoft Installer or InstallShield can help, as can your own custom installer. In this article, the author tackles one approach to writing database installers and demonstrates the process with a working code sample.
MSDN Magazine September 2004
In my app, I am displaying an Rss Feed, I have a button that takes the user to another form where they can select a them. Upon selecting the theme, they are taken back to the original form.
If the user has selected which theme they want to view then they click on the button to change theme, I need to pass the information about what rss feed they were viewing through session so that once they select the theme they want they are redirected back to the main page and the rss feed they were viewing should still be displayed.
Since I've already bound the data to the xmlDataSource and DataList I am trying the following:
I'm not sure I am passing the data over correctly and I'm not sure how to specify it in the page_preinit.
I have some logging that has to be done, which are some database update or inserts.
However this logging is of no importance to the user, so I only want to process the data/logs after the page is completed for the user.As of now, if I process the data while the page is loading, I go from 1.4 to 2.0 speed (server side time processing of code), which is quite a bit comparing it is of no use to the user.
So I want this code only executed after that the page is complete.
I've been checking out Ajax, async pages etc, but the problem is it still gets executed before the page is rendered to the client, which means the client will have to wait longer then it is not being processed.
I've been checking out Threadpool.queueBackgroundWorker, however if I get it correct, this will still be executed before the page is shown to the user, as it has to complete before the prerender.
Then I thought about creating a new thread, and do the processing there, which would not have my page waiting to complete the data/logging.However when I have 100 or 200 users loading pages at the same time, then that would mean I would be creating 200 threads on those loads, which I doubt will be good for performance. So if I want to solve this, I would have to create my own threadpool and only assign for example a max of 40 threads to it which can pr