I want to know that how can i sum All values from same months to a single month. Like all Jan. values should be summed as 'Jan' and all feb. values should be summed as 'Feb'. I am using below query to only get the current year's values
[Code]....
How to get the last day of the month
30/6/2010
i have to Count Data Month wise and Date format would be like this Feb-10 and iam using the below query but no luck .
SELECT REPLACE(CONVERT(CHAR(9), ADate, 6), ' ', '-') As 'MonthYear', COUNT(AID) AS 'Planned' FROM Employee where Status =1 and YEAR(Adate) = '2009' GROUP BY YEAR(Adate), MONTH(Adate) ORDER BY YEAR(Adate),MONTH(Adate)
How would you pull only the current month data from SQL?
View 9 RepliesHow to select the month only from the dateTime datatype in sqlserver Express database to asp.net/c# dropdownlist?
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?
I have a problem described below
Set @StartMonth = Aug
Set @EndMonth = Jan
Set @StartYear = 2009
Set @EndYear = 2010
I need to insert records into one new table based on the above informations
Month name should go from StartMonth to EndMonth and Year also should insert like below
MonthName Year
Aug 2009
Sep 2009
Oct 2009
Nov 2009
Dec 2009
Jan 2010
2) when I pass again
Set @StartMonth = Dec
Set @EndMonth = Feb
Set @StartYear = 2009
Set @EndYear = 2010
It should check for the records already in the database and should not insert the duplicate record. Based on the above case it should insert only one record
MonthName Year
Feb 2010
3) I need to also calculate number of days in the month except sat and sunday ..
Like Jan2010 we have 21 days except Saturday and Sunday
Is there any logic through which we calculate the number of days.?
<form id="form1" runat="server">
<input type="hidden" id="hdnDay" runat="server" />
<asp:DropDownList ID="ddlMonth" runat="server" onchange="populateDatesForMonth(this.value);">
<asp:ListItem Text="Jan" Value="1"></asp:ListItem>
<asp:ListItem Text="Feb" Value="2"></asp:ListItem>
<asp:ListItem Text="Mar" Value="3"></asp:ListItem>
<asp:ListItem Text="Apr" Value="4"></asp:ListItem>
<asp:ListItem Text="May" Value="5"></asp:ListItem>
<asp:ListItem Text="Jun" Value="6"></asp:ListItem>
<asp:ListItem Text="July" Value="7"></asp:ListItem>
<asp:ListItem Text="Aug" Value="8"></asp:ListItem>
<asp:ListItem Text="Sep" Value="9"></asp:ListItem>
<asp:ListItem Text="Oct" Value="10"></asp:ListItem>
<asp:ListItem Text="Nov" Value="11"></asp:ListItem>
<asp:ListItem Text="Dec" Value="12"></asp:ListItem>
</asp:DropDownList>
<asp:DropDownList ID="ddlDay" runat="server" onchange="setDay(this.value);">
</asp:DropDownList>
</form>
when i chnage the month or slecte th emonth i need to get the value in a cariable or a hiiden field
I'm trying to count the number of activities in a month without using the Case When clause
This is what I was able to produce so far
SELECT COUNT(MONTH(irActivity.ActivityDate)) AS 'JAN'
FROM irActivity INNER JOIN pdEmployee ON irActivity.Act = pdEmployee.Act
ORDER BY 'JAN'
I'm trying to place a filter by "MONTH(irActivity.ActivityDate) = 1)"
Which then gives me a syntax error
How 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
Scenario:
I am creating a custom gridview control which has a custom CheckBoxTemplateField column (deriving from TemplateField class). This template field column has custom Checkboxheadertemplate (implementing ITemplate) and CheckboxItemTemplate (also implementing ITemplate). In InstantiateIn method of both templates (header as well as Item template), I am adding a checkbox control which has Autopostback = true.
My requirement is:
I want to mark all the values in the binding column of datasource if checkbox in headertemplate is checked. I dont want to mark only rows visible on grid. I WANT TO MARK ALL ROWS IN DATASOURCE. I want to do this in _CheckedChanged event of checkbox in header template.
Problem I am facing: When I check/uncheck the checkbox in header, it postbacks. so in OnCheckedChanged event, gridview's datasource is null. Secondly, in any event of gridview, I could access only those rows of datasource for which corresponding rows are visible in gridview through Gridviewrow.DataItem property. But I want to set it for all rows in datasource.
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.
I need to write a query to populate a gridview with minimum rates in ascending order for a month from three tables.For example i have three tables A,B,C as follows
TABLE A TABLE B
TABLE C
Id id id
Quote_no Quote_no Quote_ no
Name Rate1 Equip_name
Rate2 E_rate
Date R1_rate
R2_rate
Date
Now if the data is as follows
I need to get the Name from Table A ,minimum Rate1 and Rate2 values for a month in a dropdownlist from date field from Table B and the corresponding minimum rate(E_rate) for Equipment E1 and E2 only from Table C for the month in ascending order group by Name.
TABLE A
id
Quote_no
Name
1
101
XYZ
2
102
ABC
TABLE B
id
Quote_no
Rate1
Rate2
Date
1
101
105
200
12/11/2010
2
102
90
210
15/11/2010
TABLE C
id
Quote_no
Equip_name
E_rate
R1_rate
R2_Rate
Date
1
101
E1
60
0
0
12/11/2010
1
101
R1
0
110
0
12/11/2010
1
101
E2
80
0
0
12/11/2010
2
102
R2
0
0
300
15/11/2010
2
102
E2
100
0
0
15/11/2010
2
102
R1
0
60
0
15/11/2010
2
102
E1
230
0
0
15/11/2010
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
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 + "' ";
Have been trying to update some key fields but cannot get it working. I have the form working fine updating non key fields. I found some old threads on similar topics but none answering my question. I am using a FormView and a sqlDataSource
Question: What steps do I need to take to update key fields using a formview and a sqldatasource?
Additional Information: I have tried the following
Adding OldValuesParameterFormatString="old_{0}" to sqldatasource Adding to update parameters the old_myfield reference Adding DataKeyNames to the formview (note all key fields are in datakeynames and I only want to update the one)also when using the asp parameters do they need to be in same order as query and repeated as many time as used? Or just the same order as first referenced i.e. only defined once? Or any order?
i am using dataset,i retrived the values from the database and i deleted from the data set .is it possible to get values back?
how can i get those values?
MY CODING
string studentno = "select regno from stu_ref where batch='" + dropbatch.SelectedItem.ToString() + "'";
SqlDataAdapter dastudent = new SqlDataAdapter(studentno, cn1);
DataSet dsstudent = new DataSet();[code]....
form the above coding i will get all values form the table stu_ref of regno of student now i need to get the first and the last regno from the table
for eg TextBox1=103301
TextBox2=103378
the total no of student=78
public static DataSet GetSubCategories(int category_id)
View 4 Repliesi dont know why this happens and when happens......i have one employee table that contain date field and that field contain two different values one is -'2008-10-01 00:00:00.000' and second is '2008-10-01 12:00:00.000'.can anyone explain when this type of value insert in database.
View 2 Replies I have a database table with three columns of interest
slottypekey (integer)
taskkey (integer)
permission (string)
Lets's say I have a stored procedure that gets this data and puts it into a dataset.
I would like to write a function that has input parameters of slottypekey and taskkey
and that returns the associated permission. What is the best way to do this?
I have 2 Linq to Entity queries, here they are:
[Code]....
In "query" there are several columns, 2 of them are NIIN and Qty. In "objViewDDRT" there are only 2 columns, they are NIIN and AvailBalance.
What I need to do is for each row in "query" check to see if the NIIN is in "objViewDDRT", and if it is get the AvailBalance for that NIIN from objViewDDRT.