Is that possible to get missing years from the table column.
for example in table column i have something like this 2003,2004, 2005, 2006, 2008, 2010, 2011
so the result should have 2007,2009 (missing years)
Making a sales,cost table equal for one year
select all sales from dbo where year = 2008
select all costs from dbo where year = 2008
but now i want to put beside this table
select all sales from dbo where year = 2009
select all costs from dbo where year = 2009
How can i achieve this in one table?
For the below query (sdate is column name and table name is storedata)
View 2 Replies<asp:CalendarExtender ID="ceBirthday" runat="server" TargetControlID="txtBirthday" CssClass="MyCalendar" Format="dd.MM.yyyy">
</asp:CalendarExtender>
how can i add years up in the header of calendar. Now i can see months and years but if i want to get to year 1977 i must click back about 1 minute or more. Can i add years to click and then click month.
I need to calculate the Age and give a reading in this format: X Years, X Months.
My ASPX page is parsing
<%#GetMachineAge(Eval("Age"))%>
What calculation do i need in my code behind?
How can i bind the an interval of 100 years with a dropdownlist.
To be more precise, I want to bind 1990 to 2010 to a dropdownlist .
I have to validate that the year entered must be less than or equals to the current year. I am using server side validators in ASP.Net and C#, and all validators are inside a validator group.
View 2 RepliesHow would I setup a dropdownlist to check the dates in the database and populate it based on the years of the dates currently in the database? So if some dates were from 2010 and some where from 2011, it would display a dropdownlist with two options in it...2010, 2011.
I have dates listed in my database for a schedule system and would like to add a dropdownlist so I can only list the dates for the current year by default, then a user has to select a date from the dropdownlist to see any dates from a different year. Otherwise, it just shows all dates, regardless of year...
Is it possible remove the last years of CalendarExtender ?
View 5 RepliesI want to add years to Datetime object, But I m not getting Expected Output.
SOURCE CODE -
Code:
[code]....
By default, it seems that the standard Asp.NET calendar control can only scroll on a month-by-month basis (using the back and forward link buttons on the control).Is there a way to customise this control to add paging links which will skip by a year in either direction?
View 4 RepliesI wanna use calender extender, but with 2 modifications.
1.) The calender itself must contain the 2 dropdown lists (one for year and other for month) and below these 2 lists there are dates (1 through 31) on selecting that the calender disappeares.
2.) Is it possible to have calender show only few years for example if I use calender for Age purpose then I want users to select only 1920 through 2000 so calender shows only those no of years.
In VB how do you return the difference between two dates expressed in years as a decimal.
(DateDiff(DateInterval.Year, DateOne, DateTwo))
So that the result returns a decimal for example 15.76 years and not an integer
how to calculate years in asp.net..that is , if a value in textbox is 10-oct-2010... i wanna get 10-oct-2011 in another textbox if i specify to calculate 1 year and 10-oct-2012 if it is 2 years....
so how can i implement this...using vb............is there any function for that..
I am trying to query my datatable for part of 2010 and part of 2011. My datatable returns records if I query 01/01/2010 to 12/31/2010. It fails and returns no records if I query any date in 2011. my 'txt..selecteddate' is a telerik control but that is not the problem. Imagine it as just a textbox or something
[Code]....
The CalendarExtender used with TextBox has a problem when you select previous years, months and a day in that the day reverts to "1" no matter what day of the month that you choose. Microsoft usually has a free patch for something like this when that happens.
If I am correct and there is a patch for this bug can anyone tell me where to find the patch and if there is no patch can anyone tell me how to solve this problem?
I am using calendar extender. clicking on text box opens up calendar. But when i m trying to browse previous years like 1980s then its not displaying the years. Its only displaying years from 2009.
View 8 RepliesI need to retrieve data based on 3 different selections(current year, 5 years, 10 years). If the user select current year, then I need to pull data with the most up to date year, if the user selects 5 years, then I need to pull data for 5 years from the most up to date year in database. I am trying to accomplish this in sql due to using object DataTables in asp.net 3.5. I am able to do this with separate queries but I need to accomplish this with one query. I was going to use CASE statements but not really sure if I am approaching this correctly.
View 9 Repliesgroup my chart which is being bind to a datasource, to be group according to years.
View 1 RepliesI'm trying to calculate the yrs, months, days, hours, mins, seconds between two dates with sql server or c# (ive just used sql more).
I have some code below that I started, but I get some negative values for months, values over 31 for months, and there very well could be more issues. Honestly my math is not the greatest and Im just not sure how to fix it. I want the user to be able to enter their birthday and for it to calculate the yrs, months, days, hours, mins, and seconds they have been alive.
[Code]....
The AJAX CalendarExtender does not seem to work properly when using it to try and find the "past "Years/Month" (the TextBox default value is set to the current date).
When using the CalendarExtender with the Calenar icon you can click the icon and the Calendar pops up. By clicking on the Month/Year the month disappears and when you click on the "year" again it will take you back to the years from the past. After you find the year from the past being sought you can click on a "Month". Next you can click on the day sought.
However after you click on the day sought the date appears in the TextBox.
The problem is that the month is always displays "1". For example if I choose:
July 31, 2010 on the Calendar it should display "7/31/2010 in the TextBox, but instead it will display:
"1/31/2010" in the TextBox ( As you can see the "7" is replace with a "1").
How can I get the CalendarExtender to retain the "month" value that was selected to be displayed in the TextBox?
The language I am using is C#.
I have the folowing dillema.
DateTime A, DateTime B. If A < B then I have to calculate the number of days per year in that timespan and multiply it by a coeficient that corresponds to that year.
My problem is the fact that it can span multiple years.
For example:
Nr of Days in TimeSpan for 2009 * coef for 2009 + Nr of Days in TimeSpan for 2010 * coef for 2010 + etc
I have an ASP.net control that contains a grid (protected member variable). Grid is populated from a function in the control. I have derived a new user control from this control without any control in it. I added additional functionality to populate grid and called base class function to do further operation on the grid. When I run my code, I get the null reference exception on grid object in the base control. I missing something in control inheritance? at what point do inner controls get created?
View 1 RepliesOn a home PC I have SQL Server 2005 installed. If I go to SQL server management studio and select my database, I can then right click on the "Database Diagrams" folder and then select "New Database Diagram" from the popup menu. I can then generate a database diagram. However on my PC at work if I follow the same steps as above, the popup menu does not show an option for "New Database Diagram". Instead my choices are "Working with SQL Server 2000 diagrams" and "Refresh". So why is the "New Database Diagram" menu option missing? Also what is odd is that the popup selection reads "Working with SQL Server 2000 diagrams" when in fact I am using SQL Server 2005 not 2000? Does anyone know why my option to create a database diagram is missing?
View 1 Repliesfigure out the missing codes to get data from database and plot the latest 10 entries to database on the map.
this is the coding i came up with so far
[Code]....