Showing posts from 2011

Itrarting Bewteen Date Range using Foreach C#.

There are some situation when we want to itrate trough a range of date. Hear is ample how you can itrates through the date range using foreach in C# for itrating you will need to first create a function which will convert the date range in inumaration formate so that you can itrates. For this i have created the follwing function. public IEnumerable < DateTime > EachDay( DateTime from, DateTime thru) { for ( var day = from.Date; day.Date <= thru.Date; day = day.AddDays(1)) yield return day; } Now you can use the code like this. foreach (DateTime day in EachDay(strartDate, EndDate) {  //Do something }  

Placing Update Progress Control dynamically

Contextual Links f you're using AJAX UpdateProgress control, you may find it difficuilt to set the best position where you should put it on the page, because user will not see it if he scrolls down (or up) from it. Here is a simple solution which will make your UpdateProgress more user-friendly, because it will set the position on the screen according to user's movement of the mouse. And you will prevent user to click on any button until the postback finishes execution.  here is the code place the below code in JavaScript SCRIPT LANGUGE=JAVASCRIPT tag, ending with appropriate closing tag     function SetProgressPosition(e)     {       var posx = 0;       var posy = 0;        if (!e) var e = window.event;        if (e.pageX ||  e.pageY)          {           posx = e.pageX;           posy = e.pageY;         }     else if (e.clientX || e.clientY)       {          posx = e.clientX + document.documentElement.scrollLeft;          posy = e.clientY + document.documen

Using CASE to transform a result set from multiple rows into a summary row

 Consider the situation where sales data is stored in a table by month. One row is stored per month with a table structure that looks like the following: CREATE TABLE prodsales   (product char(3),    mnth      smallint,    sales     money) In this table, sales amounts (sales) are stored by month (mnth) and product code (product). The mnth column stores an integer value ranging from 1 (for January) to 12 (for December). You can use the following single SQL statement to product one row per product with 12 totals, one for each month: SQL Statement will go like this SELECT product,    SUM(CASE mnth WHEN 1 THEN sales ELSE NULL END) AS jan,    SUM(CASE mnth WHEN 2 THEN sales ELSE NULL END) AS feb,    SUM(CASE mnth WHEN 3 THEN sales ELSE NULL END) AS mar,    SUM(CASE mnth WHEN 4 THEN sales ELSE NULL END) AS apr,    SUM(CASE mnth WHEN 5 THEN sales ELSE NULL END) AS may,    SUM(CASE mnth WHEN 6 THEN sales ELSE NULL END) AS jun,    SUM(CASE mnth WHEN 7 THEN sales ELSE NULL END) AS j