I have a gridview. However, though I would like to hardcode in a particular column the months of a year. so that I have the following below. How do I go about doing it
Month
JAN
FEB
MAR
I have an "effectivedate" field that is displayed using a label inside a detailsview control... In the code behind I need to add 12 months to this to check if a policy is up for renewal or not...
To find the control I use this code... Dim EffectiveDate As Label = DetailsView1.FindControl("EffectiveDatelbl").ToString
But when I try and convert the label to datetime type using this... Dim ExpireDate As DateTime = EffectiveDate.AddMonths(12)
I get the error - Cannot convert string to date, addmonths is not a member of label etc...
I'm building a pretty simple application where a user can enter/modify/delete data from a table. Right now, the only field is month, which I'm storing as an integer (1-12). The actual table has more fields but I'm simplifying for the purposes of this question.I have the entry part. For modifying, I've set up a gridview with an 'Edit' button:
[Code]....
The code is putting the gridview row into edit mode. Now, I want to show a dropdownlist of months so the user can select the new month. Also, I would like the dropdownlist to default to the value in the database. I can't figure out how to bind months to the dropdown list ddlMonth.
I wish to select my data in sql server where it could be data that were added this month and/or this week.
For example my table - TestTable has the following fields:
AddDate - nchar(10)
RandomData - nvarchar(50)
When the user input the date, the format is in "dd/MM/yyyy". How do I go about doing this?
Banging my head with this one...
I have a SQL query that pulls data for charting based on a per month basis. The month range is dynamic and selected from the front end. My issue is when no data for a month within the month range is present, that month is skipped. Is there a way/method to have the query give a 0 value for the columns when no data for that month exists? Below is my current query
[Code]....
I am trying to add a condition where a section of my stored procedure will run if it is 12 months or less. Right now I have it set as
if @dtDate <= '5/21/2010' but I know that won't work because I want it to dynamically get today's date each day. Does any know how I would do this.
For the below query (sdate is column name and table name is storedata)
View 2 RepliesI have two textboxs consists of date.
Textbox1 = 11/09/2010
Textbox2 = 12/11/2010
I would like to compare those 2 dates actually months. If months are different i would like to do something else.
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?
I need to create asp.net web application in which i have to show Calendar that displays all months of year with Navigation buttons like Next, Previous to move on next years months. Is there ficibility to modify asp.net calendar control to show all months of a year?
View 3 RepliesI have requirement to show two calander months in same JavaScript pop up. when user click start date, then open popup window then it should display the current month and next month. then user has to chanse select either this month or next month date in the same window.
View 4 RepliesI have a dropdown list where i wanted to display months in reversed quarterly format based on the current month.
for eg. if this is the month of January 2011.. so the list has to display from the previous quarter onwards....
the dropdown list has to display:-
Oct 2010 - Dec 2010
Jul 2010 - Sep 2010
Apr 2010 - Jun 2010
Jan 2010 - Mar 2010
and so on...
I have a AJAX calendar control it shows selection for specific date.
However I have an input control to key in just month. Can we modify the behavior of Calendar control to show only month/year selection but not the dates ?
In my asp.net application there is a requirement where there is a textbox and right next to the textbox there is a calender image. When i click the calender image a calender should come up and i should be able to select a date in a month.Normally i could use AjaxcontrolToolkit calender control, but the problem here is that here i have to show two consecutive months together side by side. And there is an arrow at the left side of one month and an arrow at the right side of the other month so that i can navigate to other months.
View 1 Replieshere is my sample is this correct?
number of months=nms
days=30 days only
sample: nms=30 days count from the date hired
is this correct?
I have two TextBox controls for start date & end date input. I have to validate that end date is not greater than start date & the difference between start date & end date is not more than 12 months.
View 2 Repliesi want to create calender control with multiple months.i search so many website. i got a solution using jquery. i didn't get clear solution.
View 5 RepliesI am trying to create a report which is composed of all of the months in a year. My biggest problem is that we do counts for each month. These counts shouldn't change for previous months. They should remain static. But when I run the current month, I want to display the values in the previous months plus my current value. Do I need to create a formula for each month of the year or is there an easier way to capture this information?
For example:
The end of the fiscal year is July 11. I want to check my values for February to see what accounts are open and counted for this month as well as the accounts that are still open from January. These would all display in February. But I want the January account to report the same number (all accounts open in January) it held when I ran it in January. I want to do this for the entire year.
I am asked to popup the calendar with two months. When a user selects a date, it popups in a textbox. The botton I have now may trigger only one calendar, not two. I saw someone asked the same question, but it didn't get solved. I know that I may code myself with two asp:calendar controls and divs, and play show/hide, but that's more work.
View 3 Repliesi need below output do i need to use cursors for this can i do this with case statement.
CREATE TABLE [dbo].[tablesales2](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Name] [nchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cost] [numeric](18, 0) NULL,
[saledate] [datetime] NULL,
)
[code]....
I am using Ajax calendar control, my client requesting me to show 2 months at a time when calendar control gets populated. Please tell me how to show multiple months using Calendar control
View 2 RepliesOn my X Axis, I have months. The chart shows up to 11 points, i.e. Jan - Nov of the same year, but when I add 12 points (Jan - Dec), it will do an auto label thing and change the interval for every 4 months.
How can I change the graph so that it shows 12 months before it does the auto labels?
Here is the server control code I am currently using.
[code]....
Is it possible to customize Ajax Calender Extender control ?. I want it to disable some dates and show only four month (Jan,Feb,Nov,Dec) while it load.
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]....
I have two gridviews, say 'A' and 'B'...I want to add all the rows of 'A' to 'B' while avoiding the duplicates....For eg:
View 10 Replies