If you want to learn something, read about it. If you want to understand something, write about it. If you want to master something, teach it.
- Yogi Bhajan
Unboxing Asus ZenFone 4 A450CG
Get link
Facebook
Twitter
Pinterest
Email
Other Apps
-
Un Boxing and First user experience pf Asus ZenFone 4 A450CG
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 }
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
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
Comments
Post a Comment