I have 6 drop down menus:
[Code]....
I want the user to only select a date range of 1 year. Any suggestion on how to do this? I was thinking maybe convert the date range into days and if its less than 365 days than input is good, other wise out of range message willl display.
I has developed a crystal report, which display the records from a table and filters them based on a parameter( date range parameter). now I has integrated the report into a asp.net page using c#, but when I am running the asp page it is not promption for the date range values, it used to prompt for date range when I run the report in crystal report.
View 2 Repliesi have the following query.
[code]....
but if there were no "hits" for a particular date range in the last week i only get the dates returned where there were hits. i need to get all the days returned and where there were no results, i need a zero returned.
hitdate hitsperday
2010-10-07 2
2010-10-06 58
2010-10-04 1645
2010-10-03 1192
what i need to return is this:
hitdate hitsperday
2010-10-08 0
2010-10-07 2
2010-10-06 58
2010-10-05 0
2010-10-04 1645
2010-10-03 1192
I am trying two calculate a date range from two textboxes. I currently have:
[Code]....
the date in textbox1 comes from cdrcalendar. I need to include cdrcalendar2 somewhere. Something along the line of "with cdrCalendar.SelectedDates and with cdrCalendar2.SelectedDates".
I am trying to do this form that counts the number of records that are completed in a certain date range. I just want the user to place his date range and have it return the count as a Label. Here's what I have so far, I'm not 100% sure how to correctly place the user inputed variables into the Query.
It keeps returning "System.Data.SqlClient.SqlCommand"
[Code]....
I have a dropdownlist having values 'today','yesterday',lastweek', 'last month', 'lastyear'.
when the user select any value from this dropdown, i want to show the from date and to date in two text boxes.
e.g. if the user selects last week, 'to date' should be today's date and 'from date' should be (today's date - 7). if current date is 12, 'from date' = 6 and 'to date' = 12
How do I do this?
I am using an ASPxPivotGrid to display order data in an aspx website. When I put a column in the "filter area" that has a date value, it displays a checked list of dates to choose from (see below). Is there a setting or workaround to get it to show a date-range or calendar popup to filter by?
View 1 Replieshow to loop through date.i have string like this String startdate = "Nov 5 2010" ; i want to loop through 10 days before and 10 days after of above date. how could we achicve this.
View 5 RepliesI have a range validator to prevent people from putting a date in the future.
For this I have specified the Maximum Value as:
[Code]....
It appears during debug that its specifying a date format as MM/DD/YYYY, how can I get it to be DD/MM/YYYY?
I am trying to restrict the data in the report with the use of a start date and an end date selected from a textbox (w/ ajax calendar extender)
should this be done on the report side or should i create a stored procedure and pass the variables to the stored procedure by microsoft report viewer.
It seems like there is two connection strings to the database, one for the report and one for the report viewer, is this correct?
I am trying to query my datatable for part of 2010 and part of 2011. My datatable returns records if I query 01/01/2010 to 12/31/2010. It fails and returns no records if I query any date in 2011. my 'txt..selecteddate' is a telerik control but that is not the problem. Imagine it as just a textbox or something
[Code]....
I'm trying to get the max amountpaid within a date range, but I get a error: What am I doing wrong here?mplicit conversion from data type datetime to decimal is not allowed. Use the CONVERT function to run this query.Heres my t-sql
[Code]....
I want to bind a field in a View to a property in a ViewModel. The object is "Program" and has the properties "Name" and "Level". So the user should be able to set the name of a program and the level of experience he/she has with this program.Program is a table in an Sql Server database, and is accessed through Entity Framework. So it would be easy enough to bind the Level property in the ViewModel to a textbox:
@Html.TextBoxFor(model => model.Level)
But I want a dropdownlist with a limited number of levels (1-5). So how do I do this and still have the dropdownlist bind to the ViewModel property?
As they have given option to pass typeof() as first parameter and min-max value.Is there any way we can implement range validator attribute for date by using typeof(datetime) ?please let me know if anyone has implemented same ?
View 1 RepliesI need to filter data based on a date range. My table has a field Process date. I need to filter the records and display those in the range FromDate to ToDate.
View 2 RepliesSay I have a table called "Visits", and I want to create a query that counts the visits per day. The way I would accomplish this would be to create a query as such:
SELECT Count(VisitId) as VisitCount, Convert(varchar(32), VisitDateTime, 101) as VisitDate
FROM Visits
WHERE VisitDateTime BETWEEN '10/1/2010' AND '10/5/2010'
GROUP BY VisitDate
The problem I am trying to overcome is that if there were no visits in a given day, that day does not show in my list. For example, if there were 3 visits on the 1st, 2 on the 2nd, none on the 3rd, and 5 on the 4th, my result set would look like:
3, 10/1/2010
2, 10/2/2010
4, 10/4/2010
How can I create my query so that I get all days in the date range listed in the result set regardless of whether the VisitCount is zero?
I need to validate two textboxes for date range in client side. what is the best approach ?
View 3 RepliesI am in need of filtering the datatable only with Month and Year .
I am able to perform this in SQL using
Year(date) =2015 and Month(date)= 5
How to perform this using Row Filter ...
I have a datalist menu that has several menuitems in it(each item load user control).I want to show each menuitems in seperate dynamic Ajax tabs when I click on first item tab is created but when I click on second menuitem to create second dynamicajax tab I faced this error:
[Code]....
Im building on a transaction website that gives the user a few choices for them to choose when they want to view their transactions history
They can choose:
1.Current Month
2. Last 1 month and current month
3. Last 2 month and current month
4. Select date range
How do I include this variable in the stored procedure?
I have a table containing courses, columns are
Name - "Yoga Classes"
DateStart - "2/23/2010"
DateEnd - "2/24/2010"
I am using ListView Control to bind it, is there a way to display them and group them by Month? for eg.
January
Piano Class (10th Jan 2010 - 11th Jan 2010)
Guitar Class (10th Jan 2010 - 11th Jan 2010)
February
Yoga Class (15th Feb 2010 - 16th Feb 2010)
etc...
how to filter BETWEEN two dates or two customer ID's.
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....
I am using a gridview in (Visual Studio 2010) to display records from a SQL 2005 database. I can filter my date range successfully but it does not include the end date. I have tried using the between expression as well as >= <= to return the dates from the beginning and end dates. I have search and found that this is due to the time portion of my datstamp in the SQL column (02/19/11 01:03:36 PM) where I am filtering by short date (02/19/11); therefore leaving the end date out of the records returned.
Now the solution I have read is to add a day onto the endate like this: 02/19/11 + 1 but I get a conversion error returned from the SQL server. I have tried to use convert in this matter to convert the textbox.text in the selectcommand to datetime 101 formats to overcome this but I must still be missing something because it comes back with another SQL error unable to convert nvchar to datetime.
In the end I would like to have my two textboxes StartDate - EndDate filter the dateStamp column in my Transactions table and if both textboxes have the same date return records for that date only and include the EndDate if the range is more than one day.
I have tried many different variations of the below code using $,#,+ and & symbols to encapsulate the EndDate controlparameter to add a day to the EndDate and have failed at all attempts.
This my markup that filters fine excluding the EndDate;
[Code]....
I have tried using this as well and work excluding the EndDate:
[Code]....
selectcommand="Select * from Transactions where DateStamp Between @StartDate and @EndDate">
I have dropdown menu item ("pin this site") that i need to hide it or hide menu item itself ("My Network").
When I saw viewsource on page, I got below code.
<a class="zz1_TopNavigationMenu_1 ms-topnav zz1_TopNavigationMenu_3
ms-topnavselected zz1_TopNavigationMenu_9" href="http://mynetworkqa.spe.org"
style="border-style:none;font-size:1em;">My Network</a>
<a class="zz1_TopNavigationMenu_1 ms-topNavFlyOuts zz1_TopNavigationMenu_6"
href="javascript:__doPostBack(,
'ctl00$PlaceHolderTopNavBar$PlaceHolderHorizontalNav$topSiteMap''Pin')"
style="border-style:none;font-size:1em;">Pin this site</a>
How can I hide menu item?