or
<%@ Page Language="Oxygene" AutoEventWireup="true" CodeBehind="Default.aspx.pas" Inherits="RadGridGroupSortTest._Default" %><%@ Register Assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="System.Web.UI" TagPrefix="asp" %><%@ Register Assembly="Devart.Data.MySql.Web, Version=5.50.79.0, Culture=neutral, PublicKeyToken=09af7300eec23701" Namespace="Devart.Data.MySql.Web" TagPrefix="cc1" %><%@ Register Assembly="Telerik.Web.UI, Version=2010.1.519.35, Culture=neutral, PublicKeyToken=121fae78165ba3d4" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title>Untitled Page</title></head><body> <form id="form1" runat="server"> <telerik:RadScriptManager ID="ScriptManager1" runat="server" EnableTheming="True"> </telerik:RadScriptManager> <div> <cc1:MySqlDataSource ID="MySqlDataSource1" runat="server" ConnectionString="User Id=livewire3server;Password=lw3server;Host=192.168.1.5;Database=livewire3;Persist Security Info=True;" OldValuesParameterFormatString="Original_{0}" SelectCommand="select id,sender,receiver,authorized from dummydata_testbank" DeleteCommand="DELETE FROM livewire3.dummydata_testbank WHERE ((id = :Original_id))" InsertCommand="INSERT INTO livewire3.dummydata_testbank (sender, receiver, authorized) VALUES (:sender, :receiver, :authorized)" UpdateCommand="UPDATE livewire3.dummydata_testbank SET sender = :sender, receiver = :receiver, authorized = :authorized WHERE ((id = :Original_id))"> <DeleteParameters> <asp:Parameter Name="Original_id" Type="String" /> </DeleteParameters> <UpdateParameters> <asp:Parameter Name="sender" Type="String" /> <asp:Parameter Name="receiver" Type="String" /> <asp:Parameter Name="authorized" Type="Byte" /> <asp:Parameter Name="Original_id" Type="String" /> </UpdateParameters> <InsertParameters> <asp:Parameter Name="sender" Type="String" /> <asp:Parameter Name="receiver" Type="String" /> <asp:Parameter Name="authorized" Type="Byte" /> </InsertParameters> </cc1:MySqlDataSource> <telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" AutoGenerateColumns="False" DataSourceID="MySqlDataSource1" GridLines="None" ShowGroupPanel="True"> <MasterTableView DataKeyNames="id" DataSourceID="MySqlDataSource1"> <RowIndicatorColumn> <HeaderStyle Width="20px"></HeaderStyle> </RowIndicatorColumn> <ExpandCollapseColumn> <HeaderStyle Width="20px"></HeaderStyle> </ExpandCollapseColumn> <Columns> <telerik:GridBoundColumn DataField="id" HeaderText="id" ReadOnly="True" SortExpression="id" UniqueName="id"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="sender" HeaderText="sender" SortExpression="sender" UniqueName="sender"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="receiver" HeaderText="receiver" SortExpression="receiver" UniqueName="receiver"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="authorized" DataType="System.Int16" HeaderText="authorized" SortExpression="authorized" UniqueName="authorized"> </telerik:GridBoundColumn> <telerik:GridImageColumn GroupByExpression="Group By authorized" HeaderText="myauth" SortExpression="authorized" UniqueName="myauth"> </telerik:GridImageColumn> </Columns> </MasterTableView> <ClientSettings AllowDragToGroup="True"> </ClientSettings> </telerik:RadGrid> </div> </form></body></html>
messageListCurrent.DataSource = LoadData(
True) 'this is the dataset
messageListCurrent.DataBind()
| <telerik:RadScheduler ID="RadScheduler1" runat="server" Height="388px" TimeZoneOffset="03:00:00" |
| SelectedDate="2007-03-30" DayStartTime="08:00:00" DayEndTime="18:00:00" |
| OnDataBound="RadScheduler1_DataBound" |
| Skin="Vista" Width="1006px" DataEndField="ENDDATE" DataKeyField="ID" |
| DataSourceID="XmlDataSource1" DataStartField="STARTDATE" |
| DataSubjectField="SUBJECTS"> |
| </telerik:RadScheduler> |
| <asp:XmlDataSource ID="XmlDataSource1" runat="server" |
| DataFile="~/App_Data/TimeTable.xml"></asp:XmlDataSource> |
| <Root> |
| <Datarow> |
| <ID>1</ID> |
| <DY>25</DY> |
| <SESS>2</SESS> |
| <CODE>CMH10431</CODE> |
| <DESCRIPTION>CMH10431</DESCRIPTION> |
| <ABREV>P</ABREV> |
| <TYPE>P</TYPE> |
| <NUMBER>1</NUMBER> |
| <GRPNAME>V0022012</GRPNAME> |
| <GRPNUMBER>1</GRPNUMBER> |
| <DURATION>1</DURATION> |
| <STUDENTS>1</STUDENTS> |
| <VENUE>V0022012</VENUE> |
| <CAPACITY>50</CAPACITY> |
| <MODLID>641</MODLID> |
| <TERM>Oct2008</TERM> |
| <STAFFTERM>Oct2008</STAFFTERM> |
| <STARTDATE>2008-10-30T17:00:00</STARTDATE> |
| <ENDDATE>2008-10-30T17:00:00</ENDDATE> |
| <LENGTH>180</LENGTH> |
| </Datarow> |
| <Datarow> |
| <ID>2</ID> |
| <DY>1</DY> |
| <SESS>1</SESS> |
| <CODE>PVL101Q1</CODE> |
| <DESCRIPTION>PVL101Q1</DESCRIPTION> |
| <ABREV>P</ABREV> |
| <TYPE>P</TYPE> |
| <NUMBER>1</NUMBER> |
| <GRPNAME>V0022012</GRPNAME> |
| <GRPNUMBER>1</GRPNUMBER> |
| <DURATION>1</DURATION> |
| <STUDENTS>4</STUDENTS> |
| <VENUE>V0022012</VENUE> |
| <CAPACITY>50</CAPACITY> |
| <MODLID>2634</MODLID> |
| <TERM>Oct2008</TERM> |
| <STAFFTERM>Oct2008</STAFFTERM> |
| <STARTDATE>2008-10-06T08:00:00</STARTDATE> |
| <ENDDATE>2008-10-06T08:00:00</ENDDATE> |
| <LENGTH>180</LENGTH> |
| </Datarow> |
| </Root> |
foreach (DateTime dt in Session["DBBookedDays"] as ArrayList) { if ((e.Day.Date >= Convert.ToDateTime(jStartDate.Text) && e.Day.Date <= Convert.ToDateTime(jEndDate.Text)) && e.Day.Date.ToShortDateString() == dt.ToShortDateString()) { e.Cell.CssClass = "rcSelected"; e.Cell.ToolTip = "Already booked in for this job"; renderedDay.IsSelected = true; break; } }