once a user select an item from dropdownlist > Dates from DB are shown on calendar in pink color.
The problem now is when i want to select new dates the selected dates(in pink) become deselected .. I want them to stay selected so i can know which dates are already used .
[Code]....
If i have three textboxes in my vb.net webform.
Textbox1.text="Sumit"
Textbox2.text="4-Dec-2010"
Textbox3.text="1-Jan-2011"
I want if dates selected are in between textbox2 dates and textbox3 dates then textbox1.text="sumit" else textbox1.text="No dates"
I need some pointers to start on this.We are building a time off application where three instances of a calendar control will be displayed ( prev - current and next month) now users can click on various dates accross all three instances and then a count of number of days should be diaplyed in the parent textbox.
To begin with this, i started with adding the dates clicked by the user in Calendar2_SelectionChanged method into a list<> so that i can get the all dates user clicked and then add it to calander's selected dates collection. But this throws an e" object reference not set" error.
Is there anyother way to get all the dates that user click onthe calendar( note the dates doesn't get highlighed so seleteddates doesnt work)does anyone has a good example for this.
i have to date say in MM/DD/YYYY format "1/1/2010" and 1/30/2010". now i want to find dates which comes on monday. so out out will be 01/04/2010, 1/11/2010, 01/18/2010, 01/25/2010
View 2 Repliesi 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 dynamic header for datalist control(Dates are dynamic).Also i want header in each row.I want something like this.Words in bold are headers.Header also in each
row.8/1/2010,8/8/2010,8/15/2010,8/22/2010 are dynamic dates whic change every month based on user selecting date from datecontrol.
HeadCount 8/1/2010 8/8/2010 8/15/2010 8/22/2010
Forecaster HC 447 446 441 432
Agents Scheduled 447 446 441 432
I am saving to dates (fromdate) and (todate) into DB .. And then I want to view all the days (from to) and the dates in between , highlited in a calendar control ,, how can i do that ? I know how to highlight dates saved into calendar but how can i do the same to the dates inbetween ?
View 1 RepliesI want a user to select (fromdate) from Calendar1 and (todate) from Calendar2, and then i want all dates in between to be saved in database .
View 12 RepliesI am generating multi-series graphs with the date along the X-Axis. The problem is that not all of the series in the graph have the same dates in the date range. Meaning that if I choose 1 Feb through 30 Apr that one series may have data that starts at 1 Feb but only goes through the end of March but another series may have data for the entire date range. This skews the charts I need to create. Go, given the date range taken at the begining of the query I'd like to generate a list of dates and populate the data to be graphed, padding those series with 0's for those dates that have no data.
View 3 RepliesWhat i want is:: once the user select an item in a (dropdownlist) >> then SELECT dates from database and show them into the Calendar (in a specific color) .. How can i do that ?? Using C#, asp.net 3.5 , sql DB
View 7 RepliesI am selecting multiple dates from a calendar control and inserting them into DB. The question: how can i make calculate number of dates selected and show the number in a textbox , using a button click event?
One other thing, in another case, i am selecting (fromdate) from Calendar1 and (todate) from Calendar2 ,, i want to calculate number of days including both dates and show the number in a textbox?
Multiple dates selected but inserting only the first one
[Code]....
How do I get the previous two weeks days and dates from a selected date.
E.g. The Selected date is 19 February, 2011. I need to figure out Sunday Feb 6th, through Saturday, Feb 19th. This includes the dates and their days of week.
I have a calendar where all the dates from my database are selected/highlighted.I have to use a repeater because else it won't work, but now i want a single calendar where multiple dates are selected, instead of a single calendar for every date in my database.My code:
[Code]....
i have a two fields in table startdate and enddate
2011-01-20 00:00:00.0002011-01-20 16:00:00.000
2011-01-20 00:00:00.0002011-01-20 16:00:00.000
2011-01-20 00:00:00.0002011-01-20 16:00:00.000
2011-01-21 00:00:00.0002011-01-21 23:00:00.000
2011-01-29 00:00:00.0002011-01-29 23:00:00.000
2011-01-29 00:00:00.0002011-01-29 23:00:00.000
2011-01-31 00:00:00.0002011-01-31 23:00:00.000
2011-01-31 00:00:00.0002011-01-31 23:00:00.000
2011-02-01 00:00:00.0002011-02-01 23:00:00.000
2011-02-01 00:00:00.0002011-02-01 23:00:00.000
2011-02-04 00:00:00.0002011-02-04 23:00:00.000
2011-02-04 00:00:00.0002011-02-04 23:00:00.000
2011-02-14 00:00:00.0002011-02-14 23:00:00.000
2011-02-14 00:00:00.0002011-02-14 23:00:00.000
I am selecting multiple dates on a calendar control ,, and then i insert them into DB. The problem happens after i insert, if i want to add new list of dates, once i start selecting on calendar all last selected dates appear (get selected on calendar) Does this mean these dates are saved in Session or what? Here is the code I am using:
[Code]....
a user will choose a period of time (from this date to this date) with a calendar ,, and then i want to get from DB all Invoices that were created within this period ??
each Invoice has a Date saved in Database..
This is the sql select statement i am using:
SelectCommand="SELECT [invoiceid] FROM [invoices] WHERE (([location] = @location) AND ([name] = @name)) AND date BETWEEN '"+ (fromdate.SelectedDate.ToShortDateString()) +"' AND '" + (todate.SelectedDate.ToShortDateString()) + "'">
i am getting this error message:
System.Data.SqlClient.SqlException: Conversion failed when converting date and/or time from character string.
My goal here is to store a list of dates selected in a calandar to a database. The problem with most calendar controls that exist, for asp.net, is I can't get the date that was unselected with multiselect enabled. I can get a list but that is really it. I have decided not to use these because of this.
If I wanted to create my own event using the jQuery calendar below how would I go about doing this? The event would capture the day clicked, if it was unselected or selected, etc. I would use this to add/remove the dates from a collection. It is almost like how the other calendars work except for the remove part. The dates removed would be in it's own list so I know what dates to remove from the database once 'save' is clicked. I hope this is enough information.
[URL]
Using Visual Studio 2005/.NET 2.0. c#
i have DateFrom and DateTo columns in tblLOgs.if they both are same then select only DateFrom else both selects.my procedure is ....do modification in them
[Code]....
I want to create an application where I need to enter date to the ms access database.
I am a bit confused regarding how to make the user to enter date. The options avaliable are:
a. Shall I use a textBox?
b. Shall I go for 3 drop down lists?
or something else.
Some more questions:
1. what date format shall i use? (dd-mm-yyyy, dd-mmm-yyyy, etc, etc or anything else)
2. What datatype shall i use to store the date in the database?
3. What SQL query shall i use to retrieve the data between 2 dates?
let me know if there are multiple options available regarding this application.
I want to make this application as easy as possible for the user.
ma using ajax toolkit calender extender and I wonder how I can make some dates unable to select. Lets say, today is 17.07.10 and I want before 15.07.10 dates to be unselctable. how could I do that?
View 1 RepliesI want to block Year From Calender .I have 2 text box in first text box i select Start Financial Year And in second Text End Financial Year.When i Select 2009 year in first text box then in second texbox all dates privious from 2009 will be block.
View 1 RepliesRetrieve An colom in a database its name is ItemPrice (witch i know how todo) then when i check 3 Checkboxes and click an button it multiplys the value item in the Itemprice colom you can look at my prodject and understand what i mean an this
link (NOTE: you must first select the dates then click search availabilty)then you will see the checkboxes via System.Web.UI.Controls
I was creating another usercontrol with Telerik's RadGrid and Calendar.
[code].....
The problems are, (1) when I click the submit button. the data in the RadGrid is not changed. (2) how can we check if there is nothing selected in the Calendar controls, because there is a date (01/01/0001) set even if we do not select anything from that calendar, thus Calendar1.SelectedDate != null is not enough.
I have two text boxes (from date and to date). Based on your demo i have disabled the future date but my requirement is
1). First i have select the from date. eg: 21-02-2013
2). Now i am selecting TO DATE. eg:21-01-2013
Now my requirement is i need to disable dates until 21-02-2013 to current date. Then user not able to select ToDate as 21-01-2013 i need to provide only option to select from 22-02-2013 to current date.
<asp:Label ID="lbl_sel_date" runat="server" Text="Select Date: "></asp:Label>
<asp:TextBox ID="txtDate_from" runat="server" CssClass="disable_future_dates"></asp:TextBox>
<asp:ImageButton runat="server" ID="imgPopup" ImageUrl="~/Calendar.png" />
<cc1:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtDate_from"
PopupButtonID="imgPopup" />
[code]...