I'm new to ASP.NET and am not sure where to put this. In my SQL server database I have a view that includes "transaction date"(TransDate) as a column. I want to create a Report (rdlc) that shows data grouped by Transaction Month. Where is the best place to add the month column - in the view, in the app's dataset, or somewhere else? I tried adding it as a column in the dataset but that does not seem to work correctly.
View 3 RepliesI am developing membership for website. SQL Server 2005 is at backend. I want Column <Package> to "Free" from "Premium" automatically when month ends. The website is membership per month basis. Two type of members "Free" and "Premium".
Is there any way to automatically column update as month ends. Can I do it with triggers? If yes then how?
For the below query (sdate is column name and table name is storedata)
View 2 RepliesHow to calculate current date(month) minus one month in crystal report?
View 1 RepliesHow to display the number of days in textbox when the month is selected in the dropdown list,,,for example if i select the month december ,after selection i want to display 31days in the textbox how ?
View 1 Replieslblperiod.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 add a simple calendar control in my asp.net page, but i can't change month. Links prev/next month don't work ...
<form runat="server">
<asp:Calendar ID="Calendar1" runat="server" BorderStyle="Double" BorderWidth="3px"
DayNameFormat="FirstTwoLetters" FirstDayOfWeek="Monday" ShowGridLines="True"
NextPrevFormat="ShortMonth"
CellPadding="0"
OnDayRender="Calendar1_DayRender" >
<OtherMonthDayStyle ForeColor="LightGray"></OtherMonthDayStyle>
</asp:Calendar>
</form>
i’m using ASP.NET.
i created a calendar, using the below code.
[Code]...
As normal when page load, it display a calendar with current month.
Is it possible, on page load to display Next Month calendar, instead of current month? After page load as usual, I need to navigate to previous months, next month and all, like normal calender. Only thing is to display Next month instead of current month on page load.
I tried this code
Code:
Calendar1.TodaysDate = DateTime.Now.AddMonths(1)
But it’s not displaying the Next Month calendar instead of current month.
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
Suppose the current month is "Oct". I want that it will add one month in current month i.e it will show "Nov". For this my code is written below but it gives exception that Input string was not in a correct format.
So correct the code?
if (Convert.ToInt32(ddlMonth.SelectedIndex ) <= Convert.ToInt32(DateTime.Now.AddMonths(1).ToString()))
{
TotalBalanceUptoSelectedPreviousMonth();
}
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 am looking to sort a column on my gridview by simply clicking on the column rather than clicking on the column header. In the design I have been given, the column header will not be shown, and I need to be able to give the user to sort this column, by simply just clicking any where on the column.
View 2 RepliesI want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
[code].....
I have an .aspx page.
I am trying to get last day of last month (say today is 02/11/2011 and I need 01/31/2011).
How can I do that in C#
The following code will get last day of any month that user types into TextBoxPeriod.Text. Based on the system date, I need to get last day of last month.
Code:
[code]....
How to get month name and am/pm in lowercase
DateTime.Now.ToString("MMMM h:m tt");
this giving me capital letters, but I want small letters.
I am having FromDate and Todate boxes. By default by loading i need to set the fromDate as first date of current month even though the date may be 10 or 15, i should need to get the 1st date of the month. Then the toDate as current date of current month.
View 3 RepliesI have this database in visual studio and one of the tables contain the sales data, all in different days, months and years. I would like to query for the data for last month based on the current date (e.g. if today is 10/1/2011, I would like to get the data for 10/12/2010) How do I write this query to retrieve the data only for the previous month?
View 6 Replieshow i can get current month and year and show it in a lable in asp.net
View 4 RepliesI have requirement that I want to set due date for payment collection for each month. e describe my requirement in brief.In my current application my client wants that He wants set starting and closing date for each month for payment collection . Now I have decide to have two text box for starting data and closing date.
View 4 RepliesI need to return a string in the format YYYYMM but I am not able to figure out how to get the month in the format MM (02 for Feb). This is what I did
Create FUNCTION [dbo].[GetMonth](@Today DateTime)
RETURNS
nvarchar AS
BEGIN
Declare @mth nvarchar;
Set @mth = cast(month(@Today) As nvarchar);
IF month(@Today) < 10
Begin
Set @mth = '0' + cast(month(@Today) As nvarchar)
End
Return @mth;
END
This is returning a 0. I don't know what is wrong in the IF block.
I am using a drop down list for selecting the month in .aspx page. I have to get last date of the selected month in .aspx.cs page. (some months have 30 days and some have 31 days)
View 1 RepliesHow can i find a week of a month from the given date?
For example: date "23/04/2010" should return 04
I have the following statement:
[Code]....
The value Now.Month will return 1 for Jan, 2 for Feb, how can I convert to 01 and 02?
How to get the last day of the month
30/6/2010