I have a column in report that should display month and year together i.e single column will have both month and year(this is the first column of the table).
Ex: JAN/11
FEB/11
.
.
DEC/11
How can I do this?
lblperiod.Text = " period " + "01/" + drpsmon.SelectedValue + "/" + drpsyr.SelectedItem.Text + "---" + System.DateTime.DaysInMonth(DateTime.Now.Year, DateTime.Now.Month) + "/" + drpsmon.SelectedValue + "/" + drpsyr.SelectedValue;
i want the daate ie the 1st to the end of month when page is loaded i get the current months 01/06/2012 - 30/06/2012 but i want it on dropdown changed
i mean whever the user selcts in dropdown for month & year i want the period for the same
I want to display the current month name,date and time like this "August 5, 2013 06:30:58 pm" using ajax.
View 1 RepliesI am developing a project in asp.net using c# coding. I m new to this field.
I need to add day/month/year to a text box in asp.net.
I hv 3 drop-down list. when i m selecting 3 dropdown list, its value must de shown in a text box.
I want to date format like this 1-Apr-2010 in asp.net (1st date followed by month in string and followed by current year....).
View 4 RepliesI 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:
[code]....
But I don't want the year NOW, I want the year from the textbox.
I have the following template defined within DetailsView ( DetailsView is bound to object data source ):
<EditItemTemplate>
<asp:TextBox ID="txtReleaseDate" runat="server"
Text='<%# Bind("ReleaseDate", "{0:d}") %>'>
</asp:TextBox>
<asp:CompareValidator ID="valReleaseDateType" runat="server"
ControlToValidate="txtReleaseDate" Type="Date" Operator="DataTypeCheck"
Display="Dynamic" > *
</asp:CompareValidator>
</EditItemTemplate>
Assuming I enter into TextBox txtReleaseDate a date in format month/day/year, then upon clicking an Update or Insert button, a CompareValidator control complains that date format is not valid. But if I enter date in format day/month/year, then object data source throws an exception Cannot convert value of parameter 'releaseDate' from 'System.String' to 'System.DateTime', while CompareValidator doesn't complain. I need the two controls to accept the same date format, so:
a) Since my DB stores date in format day/month/year, the best option would be for ODS to also accept this as valid date format. Can ODS be configured that way?
b)Can CompareValidator be configured to also accept month/day/year format?
I have 3 drop down lists for days,months and years,also i have a textbox to show the selected values from the 3 drop down lists when i select a month it shows in textbox and if i select another month it shows in textbox beside the first selected month.i want not to repeat the values in textbox.
the code:
protected void ddl_day_from_SelectedIndexChanged(object sender, EventArgs e)
{
txt_exhib_dateFrom_add.Text ="";
day_from = ddl_day_from.SelectedItem.Value;
txt_exhib_dateFrom_add.Text = day_from +"/";
}
[Code] ......
I have 3 TextBox in my page
1-TxtYear
2-TxtMonth
3-TxtDay
I want when Run page in TxtYear show current Year in TxtMonth Show Current Month and in txtDay show current Day
How I can do it?
i have complete date in a textbox i want to make the selected value in drop down list_days equal the day part of textbox,the selected value in drop down list_months equal the month part of textbox & the selected value in drop down list_years equal the year part of textbox to make the user update it if he want i tried to find the answer but i coudn't.
View 1 RepliesI have two drops downs one for dislaying month & other for year till the current year
Here all months & year from 1900 till current year is displayed
I need to display the month or make user select the month & year only till one year back , not beyond that current month is june 2012
The user should be able to select months from may 2011 to june 2012 only
Same thing I need to accomplish with calendar control....
How can we add a drop down calendar to one of the cell of details view.
Actually i want to add three drop down list one for month , other for year and third one for days.
I am having one table in whic there is monthyear column and amount column..i want the data in gridview of monthyear less than current monthyear ...
my table entry is like this
Monthyear Amount
December 2013 10000
January 2014 20000
February 2014 60000
March 2013 40000
I have never created a user control before. I want to make a simple "date selector" with 3 DDL's for day, month, year, and be able to re-use it numerous times on a page. I don't need to set any values of the control from the page itself, but I do need to read the DDL.selectedValues. I created the DDLs in the ascx file, but am not sure what properties to create. Does it make sense, or is it recommended, to create a public readonly property for each DDL _as_ a DDL? Or do I want to create a public property of type "string" and return the DDL.selectedValue as a string?
View 7 RepliesI 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>
The above query is retrieve data like below.
SUM YEAR MONTH
51013 2000
1
30970 2007
1
NULL 2007
3
900 2007
6
807 2007
8
NULL 2007
9
1756 2007
10
7535 2007
11
NULL 2008
1
1193 2008
2
4230 2008
3
350 2008
4
2200 2008
5
4660 2008
6
6685 2008
8
But I need to display including all the months of the year along with year irrespective of SUM . My query only displays only some months in a year.
I have,hours(in varchar),Id in table tbl_x ,i need the sum of hours, monthyear(eg. mar 2010)for the last three months.But with two separate queries i am getting these results.but actually i need in the following format
Month/Year TotalHours
----------------- ----------------
Mar 2010 0400
Apr 2010 0450
to get month/Year i am using this query
[Code]....
in visual web developer 2008 in "Query" Can I format the date to display only Month and year ?example: I have Complete date in my table like 05/04/2010. In Query in need to display only Month and year Like 04/2010 Or April/2010
View 5 RepliesFor the below query (sdate is column name and table name is storedata)
View 2 RepliesThis is House_info table in database
Id
Name
Expiredate
date
in admin.aspx page I have register button
I want when users click on button In Table in Expiredate column insert current date+1year
I mean if today is 2013-1-3 in Expiredate column insert 2014-1-3
for this what should I wrote in SP?
How to extract Month from Date and then displaying the date using that extracted month??
I want to display dates according to Month. I have only "Date" column in database table.
I used below queries but it is not working:
string query= "SELECT EXTRACT(MONTH FROM date) AS Month FROM HolidayTable";
DataSet ds = new DataSet(query)
int month = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
and
string query2 = "select date from HolidayTable where date= '" + month + "' ";
comparing two dates Compare 2 days, last date of the month with first date of the next month!
example! 30-04-2010 with 01-05-2010 (or with datetime 30-04-2010 01:00:00 with 01-05-2010 01:00:00) If txt_remdate.Text < Now.Date Then
I am getting a date parameter value as '4-1-2009' from front end. Now I want to make it as
'4-1-2010' in my stored procedure. I am trying like below.
[code]....
I want '4-1-2010' for @E. How can I do this?
I would like to get number of Year, Month and Days by Given days.
Eg:- My input is 400 out put like as 1 year 1 Month and 4 Days.
How to do it?
How to calculate current date(month) minus one month in crystal report?
View 1 Replieshow i can get current month and year and show it in a lable in asp.net
View 4 Replies