I have a application where in on selection of Month and year, the datagrid should be display, username and the dates, the username and number of leaves from the database. UserName 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19..
Sam P P Susi U P - Planned Leave U - Unplanned Leave
In database i have only Username, leave start and end date.
1.How to display the dates in column in datagrid based on month and year selection.
2.How to map the dates in the datagrid with the start and end date from sql server database
Is there a way to show year and month drop down on the calendar extender like the jquery ui calendar, If so could you kindly post it for me. If not would you be willing to show me how to do the jquery ui calender with Start Theme.
I have asp.net calender control on my form and I have dropdown for month and year. and one button When I select month and year from dropdown and then when i click Button then I want to be able to go the specified month and year on my calender?
I am trying to display results based on both dropdown list selection.If a user selects Jan from 1st ddl and 2013 from 2ns ddl then results of Jan 2013 will be displayed to the user,everything works fine,I wanted to confirm the query that I have used is correct or not.
Create proc usp_monthwisedata @month int, @year int
My concerns are:
1.Is the way of writing the Sp is correct to achieve the result.
2.Is it correct to set the onselectedindexchanged of both the ddls to 1 method i.e onselectedindexchanged="DropDownList1_SelectedIndexChanged"
I am having an application which should contains a datepicker with drop down list for year and month. So how can I insert Drop down list into an ajax calendar extender control. I can't use 3rd party .dll like Calendar extender plus or 3rd party tools like jquery.
DateTime ExpMonth = Convert.ToInt32(ddExpMonth); ---- DropDown(user selects a month) DateTime ExpYear = Convert.ToInt32(ddExpYear); ---- Dropdown(user selects year) Datetime ExpDate = ///// I want this part to be saved as Datetime 02/2012
I am using HoverMenuExtender on a label LinkButton .The Popup control is a Panel, that contains a DropDownList with some listitems inserted in it. Everything is going well, when i hover over linkButton that Panel and along with that that DropDownList appears.
Now problem is that when i hover over list items of DropDown , suddenly that Panel disappears before selecting any value.Panel disappears means that DropDownList also disappears. One rubbish solution is to increase the popup delay time to 3-4 seconds.
I have a textbox that gets the date from an AJAX Calendar extender. What I need to do is extract the "month," "day," and "year," and put them into seperate string variables to use in my code to do various things based on the month, day or year respectively.
Here is what I have so far:
But I don't want the year NOW, I want the year from the textbox.
I have a date and I need to populate a drop-down with the months/years between that date and today. For instance, if that date is 10/14/2010 then the drop-down should contain October 2010, November 2010, December 2010, January 2010.
The way I'm thinking of doing this is to pass that date to a function, loop from today backwards step 1 month while adding each month to a collection until we reach that date and finally return a collection of strings. Then, populate the drop-down control on page load. Finally, use some ajax with a page method to parse back the string and trigger a partial page reload.
I have a requirement that I have to retrieve data base on month and year.I am using the below query
<pre lang="sql">SELECT SUM(areasft),DATEPART(year, sdate),DATEPART(month, sdate) FROM storedata GROUP BY DATEPART(year, sdate) ,DATEPART(month, sdate) ORDER BY DATEPART(year, sDate) ,DATEPART(month, sDate)</pre>