In my application, user will enter some meeting dates in one page. In the details page, they need to see those dates to make a selection for one file number. I want to show a calendar in the details page whice will show the dates already entered. To do that I need to bind the calendar to a datasource to get the information from the database.
View 8 RepliesI need to bind some data to my ASP.Net 3.5 calendar control. The data will be appointments and the fields are appointment datetime and title. The title field should display in the proper day of the month. Also, when a user clicks on a date in the month calendar, they should be redirected to a form to add a new appointment.
View 1 RepliesWhat I want to do is create a parameterized query in the code behind with the parameters being values from the calendar control
I'm trying to modify the select command already declared in the sqldatasource so I think it should be something like
SqlDataSource2.SelectCommand = "SELECT * FROM Activities WHERE StartDate>@StartDate AND StartDate<@StartDate2"
but the main problem I am having is how to declare the value of @StartDate, I thought it would be simply calendarID.selecteddate but this doesn't seem to be right, I've tried different variations I've found in similar threads but can't get it right
I'm not sure if grouping my results is complicating matters but when I hard code dates in it works Ok so I don't think so
the code I was trying to get working is
Dim theFilter as String = "WHERE StartDate>@StartDate and StartDate<@StartDate2"
SqlDataSource2.SelectCommand= "SELECT DATENAME(month, StartDate) AS Expr1, YEAR(StartDate) AS Expr2, SUM(CGUPreSchool) AS Expr3, SUM(CGUPrimary) AS Expr4, SUM(CGUSecondary) AS Expr5, SUM(CGUYouth) AS Expr6, SUM(CGUAdult) AS Expr7 FROM Activities WHERE " & theFilter &
" GROUP BY YEAR(StartDate), DATENAME(month, StartDate)"
I am trying to build the filter part dynamically you see but can't get this right
It's easy to bind a data source to something like a gridview or repeater, but how would I do it with a label? Heres the sql connection that I want to modify. By the way, I don't need 2 way binding.
public void Sql_Connection(string queryString)
{
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["RBConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand(queryString, conn);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
The query I'm using:
SELECT Description FROM RbSpecials WHERE Active=1
I have a database linked to a calendar. I had a peice of code that retrieved dates from a database and populated the calendar. I wanted to tidy up my code using stored procedures (they seem neater & i assume there's a benefit somewhere). so i came up with this, however it's not working. The calendar displays, but it's not being populated with the database entries. The SqlCommand & SqlParameter I have working elsewhere in my code; as with the SqlDataAdapter (which also worked before i tried to conver to a storedprocedure!) but combining these three (SqlCommand, SqlParameter & SqlDataAdapter) seem to be causing me problems.It's probably something stupid but if someone could take a look and point me in the right direction,
[Code]....
[Code]....
i want to bind my gridview with a dataset with concept of caching (to minimize the database server trips). plz give me a best example to get and bind data to gridview (command line) . grid paging is also enabled so example code should be capable to rebind data at Gridview page change.
View 1 Repliesi my website i am using Repeater control which further contain checkboxlist control. Now my problem is that i have successfully bind "Parameter Type" in repeater control but when i am binding checkbox values, it does't appears in display
<asp:Repeater ID="Repeater1" runat="server">
<ItemTemplate>
<h4>
<%#Container.DataItem%></h4>
<asp:CheckBoxList ID="chkParList" runat="server" RepeatDirection="Horizontal"
DataTextField = >
</asp:CheckBoxList>
<br /><br />
</ItemTemplate>
<SeparatorTemplate>
<hr />
</SeparatorTemplate>
</asp:Repeater>
In *.cs file following are my code
IMonitoringDataInfo objMonitoringDataInfo = new ChannelFactory<IMonitoringDataInfo>("MonitoringDataInfo").CreateChannel();
Collection<ParameterDetailDTO> clParameterDetailDTO = objMonitoringDataInfo.GetAllParameters(idList, out errorCode);
var parameters = (from resx in clParameterDetailDTO
select resx.ParameterType).Distinct();
Repeater1.DataSource = parameters.ToList();
Repeater1.DataBind();
counter = Repeater1.Items.Count;
while (i < counter - 1)
{
foreach (var parType in parameters)
{
var items = from resx in clParameterDetailDTO
where resx.ParameterType.ToLower().Contains(parType.ToLower())
select new { resx.ParameterName, resx.ParameterID };
((CheckBoxList)(Repeater1.Items[i].FindControl("chkParList"))).DataSource = items;
((CheckBoxList)(Repeater1.Items[i].FindControl("chkParList"))).DataTextField = "ParameterName";
((CheckBoxList)(Repeater1.Items[i].FindControl("chkParList"))).DataValueField = "ParameterID";
((CheckBoxList)(Repeater1.Items[i].FindControl("chkParList"))).DataBind();
}
i++;
}
I am using LINQ as datasource.
how to bind database values to a calendar. What i am trying to do is the following. i've got a stored procedure in an sql server database which checks if a backup is done correctly or not with some other information in different collumns. There is one column with the end date and one column with the status of the backup.
what i am trying to do is to bind the calendar so that when the backup finished on lets say 27 th of march and it ended correctly or not i want to see in my calendar on the 27th of march the status information. how is the best way to approach this.
I have connected listview by using datasourceid that means by using "sqldatasource1" now i want to change value of listview at run time according to search so for that i am using datasource at codebehind. but it give an error
"listview have already bind with datasourceid you can not bind it with datasource"
what should i do for solving my requirement.
I am making a Event Calendar . I want to use the Calendar to display the events for each months. I have a table in SQL that have all the event already . But dont know how to binding it with the Calendar using the Dayrender .
View 1 Repliesi have a detailsview control. in that i have 5 textboxes.
i dont have datasource contrl and any sqlqueries.
when ever i open the page detailsview control statitically should display some values in the textboxes.
then i will insert some values threw businesslogic.
when ever i open the page detailsview display some static values in textboxes.
Currently, I am using Calendar control on ASPX page. Instead, I want to use AJAX Calendar Extender control because of the animation effect and the way it moves between years making if much more impressive than Calendar control.Is it possible to display Calendar extender on page permanently, just like Calendar control?
View 2 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.
i am using ajaxtoolkit:combobox and i tried to bind data to this control in code behind file.but it is taking 3 to 4 mints to bind data and display the page. I am providing my aspx code and code behind code here
[Code]....
Code behind code:
[Code]....
GetPrograms() method will return almost 6000 records. to load the control it is taking almost 4 minuts..
I am using jquery fullcalender..
I want to bind Events to each days of the calender dynamically from the json return by the ajax method..
I'm trying to use the Calendar control in a local intranet enviroment, so I need to put all the Javascript files locally, I've downloaded the Ajax Control Toolkit 40412 source code and extracted the Scripts from
"..AjaxControlToolkit_9c860ac12ae9SampleWebSitesAjaxClientWebSiteScripts",so I write the following code
[Code]....
i create new composite control to make a full calendar control.
[Code]....
All is good until i put
[Code]....
I have a Calendar Control that I added text that show scheduled meetings on certain dates and it works okay.
The problem is that when I click on a date I need to http to another web page or sometimes goto a web page in the same web site. The problem is when the code that creates the hyperlink runs it replaces the text displaying "meetings" scheduled for that date instead appending the link to the date and retaining the "meetings" text that was already there.
Below is how I set that up with the code that adds the meetings followed by the url code that replaces the meetings text:
[code]...
or any other kind of link in my Calendar Control without clobbering whatever was in there? If it is not possible is there another way to link to another page after a date in the Calendar Control is clicked?
I have a calendar control in which i am loading data from db using the below method.
[code]...
What i want to achieve is in the selection changed event of the calendar.I would like to access the calendar selected cell value.I tried to look for a event in the selection changed method but unable to come up with any.Let me know if anyone came across this and able to access the value in the selected cell control value.
NET. The calendar control is displayed in a popup window when pressing abutton and the selected date will be displayed inside a Textbox control.
View 1 RepliesI have a calendar control where a user selects a date and then inputs info into a FormView control. Underneath the FormView is a GridView that shows all data from the SelectedDate on the calendar control. However, when the date is selected, all the information from the table ( from all dates ) is displayed.
[Code]....
And the code behind:
[Code]....
I have a Calendar Control which is getting certain dates from SQL database and shows them in gray colour using following SQL statements:
[Code]....
[Code]....
Everything works fine but I want to Show Location and Date also under the calendar control usnig Label control so when user clicks highlighted date it shows Date and Location (only the ones which are coming from SQL database and are highlighted) using Label control.
I'm trying to do something that should be very simple, but getting completely stumped on why it's not working.
I have a page that has a few calendar controls, and when the user clicks a date, I want it to toggle the value (in this case it's the "availability" of the date).
I don't want it to post back with every calendar click, so what I'm doing is:
1. During the dayrender event, a Hidden Field gets added to the day. (As it is created, the Hidden Field is added to an array so that it can be retrieved later.)
2. When the user clicks, the value of the Hidden Field is toggled using JavaScript.
3. Once the user is done marking unavailable days, they click a Save button, which gets the values, and saves them to the database.
The Hidden Fields are getting added, and toggling is working just fine. The problem is that when the user clicks the Save button, all the Hidden Fields and their values get cleared, so at the time of the save, it thinks the length of the Hidden Field array is 0.
I think it has something to do with the order in whcih the page is rendered, and the "Save" code executed, but I'm not sure how to fix it. I'm doing something almost identical on another page that works fine - the only difference is that on that page there are no calendar controls, so instead of being added at dayrender, the dynamic controls are added on page load.
If I wanted to add a Hidden Field for each day in a calendar, whose value I can change with Javascript, how do I go about it in a way that I can access the values when clicking a Save button?
I am using Framework 2.0, ASP.NET AJAX 1.0 and Visual Studio 2005.I am using 2 Ajax Calendar Extender in my page. I am using a text box and html image control and setting the TargetControlID to the test box id and the PopupButtonID to the image control name. When i click the first image the calendar pops up and without choosing a date if i click the second image the second calendar control opens on top of the first calendar control. Is there any way i can make the previous one disappear without choosing a date leaving the calendar control associated with the last image clicked.
View 2 RepliesI'm not having much luck trying to bind data to an <asp.Calendar> using a datatable. I've tried it on a <as.Label> and it works fine.
code:
[Code]....