The date functions in sql is pretty complex to me. I want to get the sum of Grand Total for the current month. OrderDate is a DateTme Column.
SELECT SUM(GrandTotal) FROM CompletedOrdersHistory WHERE OrderStatus='COMPLETED' AND OrderDate=@CurrentMonth;
I have 5 fields i want when i enter rupess n 4 fields it will someup n give me total in fifth field how can i do this?
View 1 RepliesCalculate Row Total and Grand Total in ASP.Net GridView using jQuery
what if the price column is a template field i.e. it takes input from the user before multiplying with quantity..
I want to get (total) column from DB into Dataset,, and the calculate the grand total , and show result into Textbox !!
This what i am doing to get total into Dataset: what should i do next to calculate the Grand total ? and show it in TextBox ?
[Code]....
I have a gridview with three columns. The last column is a cost column. I would like to add a summation record which shows a grand total of the last column like such:
[Code]....
[Code]....
[Code]....
I am developing a web application,in that application i want to do a calculations like total salary, basic salary, pf, hra etc..... In that I provide a button for calculate. If I click that button the value will be calculated and displayed in the textbox.. but I don't want to do that I want to do like ... When I press the tab key it will be calculated and show in textbox. How this is possible?
View 1 RepliesOn behalf of this article : [URL] .....
Lets assume i have four columns
Sr Company Date Billing amount
1 Imtiaz Super Market 11/12/1991 2000
2 Naheed mart 11/12/1991 4000
3 Imtiaz Super Market 11/12/1991 3000
Now it must group by the company name and show running total and net total like :
Sr Company Date Billing amount
1 Imtiaz Super Market 11/12/1991 2000
2 Imtiaz Super Market 11/12/1991 3000 5000
3 Naheed mart 11/12/1991 4000
4 Naheed mart 11/12/1991 5000 9000 14000
NOTE : it must support paging and must be binded with data table
How to calculate current date(month) minus one month in crystal report?
View 1 RepliesSuppose i have a table
[Code]....
[Code]....
Results 1 - 50 of 7036
IN Gridview Need to show how many row are in the gridview and how much are currently show in the GridView Page.Â
Just like in this portel With the Pager Style also ........
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.
I am using a drop down lists for selecting the month and year in .aspx page. I have to get last date of the selected month of particular selected year in .aspx.cs page. (some months have 30 days and some have 31 days)
View 2 RepliesSuppose 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();
}
how i can get current month and year and show it in a lable in asp.net
View 4 RepliesI 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 an MSSQL 2005 database that has all of the employees from my company. There is a column in the table called tblusers called DOB for their birthdate. I need a to be able to return the user names for the user's who's birthday falls on the current date. This means that I would need on the month and date part of their DOB. I have no idea how to write that into the where clause.
View 10 RepliesSuppose i have a dropdownlist in which whole months are there in that dropdown.I want that on page load dropdownlist select current month automatically(means with the help of back end code using C#).
View 3 RepliesHow would you pull only the current month data from SQL?
View 9 RepliesI have used ajax calender in my project.I need the following requirement1. If the current month is february, then i need to disable current month all date. like this and so on ....2. If the current month is feb, then i need to show january month first and last date alone, other date should be diasbled !
View 14 RepliesI have a datepicker control, it defaults the date to three days to current date. I want it to default it to current date to end of month.
View 5 RepliesI would like to get first date of current month to bind the FromDate text box regardless the date may be 3,4,5.
View 1 RepliesReportViewer1.LocalReport.ReportPath = Server.MapPath("reports/DETAILS.rdlc");Â
ReportDataSource rdS = new ReportDataSource("PERSONAL",
GetData());Â ReportViewer1.LocalReport.DataSources.Clear();Â
ReportViewer1.LocalReport.DataSources.Add(rdS);Â
ReportParameter rp = new ReportParameter("Year", ListYear.SelectedValue);Â
ReportViewer1.LocalReport.SetParameters(new ReportParameter[] { rp });
I have a listbox with year and another with month
I need that the report when generated by default shld be of current month & year
when the users selects the month or and year from the listbox i shld get the reposrt accordingly
I get error when passing parameters
I tried using even server report instead of local
When using local i get report path not set ....
i want to use a ajax calender extender in which when user clixcks on button caleder show only dates of current month not previous dates.i dont want to disable dates. i should not apper on current month calender. means it should start from 1 and end to 30 or 31
View 3 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 RepliesI've got two websites. One is a copy of the other, I even went ahead and remade a copy of the original a second time hoping it would alleviate the issue I'm having but it didn't.
On both pages I have a calendar so the route is
Csharp Code:
[code]....
The issue is on the original site /Calendar works. It shows the Calendar page with the current month. On the copy site /Calendar gives a 404 but /Calendar/Index shows the Calendar page with the current month.