or
this.grid.DataSource = context.TABLE.OrderBy(x => x.Name).Skip(this.grid.PageIndex * this.grid.PageSize).Take(this.grid.PageSize).ToList();Line 238: If TempDt.SelectedDate.Value > Nothing Then
Protected Sub lnkSaveTemp_Click(sender As Object, e As System.EventArgs) Handles lnkSaveTemp.Click For Each row As GridDataItem In myRadGrid.Items Dim Id As Integer = row.GetDataKeyValue("intIssuedId") Dim TempDt As RadDatePicker = DirectCast(row.FindControl("DatePicker"), RadDatePicker) Dim TNote As TextBox = DirectCast(row.FindControl("txtNotes"), TextBox) If TempDt.SelectedDate.Value > Nothing Then sql = "Update Drat_Issued set dtRecoverTemp = '" & sanitizeString(TempDt.SelectedDate.Value) & "', strNotes = '" & sanitizeString(TNote.Text) & "' where intIssuedId = " & Id Response.Write(sql) insertUpdateDelete(sql) End If Next End Sub| <telerik:RadScheduler ID="rsTasks" runat="server" DayEndTime="23:59:59" EnableRecurrenceSupport="False" |
| Width="1024px" WorkDayEndTime="23:59:59" StartInsertingInAdvancedForm="True"> |
| <Localization AdvancedAllDayEvent="All day" /> |
| <AdvancedForm DateFormat="dd/MM/yyyy" Modal="True" TimeFormat="h:mm tt" /> |
| <TimelineView UserSelectable="False" /> |
| <AdvancedEditTemplate> |
| <div class="row"> |
| <span class="label">Description:</span> |
| <telerik:RadTextBox ID="txtDescription" runat="server" Text='<%#Bind("Subject") %>' |
| MaxLength="100" Width="280px"> |
| </telerik:RadTextBox> |
| </div> |
| <div class="row"> |
| <span class="label">Date/Time:</span> |
| <telerik:RadDateTimePicker ID="dtpDateToPurchase" runat="server" SelectedDate='<%# Bind("Start") %>'> |
| <Calendar ShowOtherMonthsDays="False" ShowRowHeaders="False" UseColumnHeadersAsSelectors="False" |
| UseRowHeadersAsSelectors="False" ViewSelectorText="x"> |
| </Calendar> |
| <TimeView CellSpacing="-1" Culture="English (Canada)" Interval="00:30:00" StartTime="08:00:00" |
| EndTime="23:59:59" Columns="4"> |
| </TimeView> |
| <TimePopupButton HoverImageUrl="" ImageUrl="" /> |
| <DatePopupButton HoverImageUrl="" ImageUrl="" /> |
| </telerik:RadDateTimePicker> |
| </div> |
| <div class="row"> |
| <span class="label">Property:</span> |
| <telerik:RadComboBox ID="ddlProperty" runat="server" Width="280px"> |
| <CollapseAnimation Duration="200" Type="OutQuint" /> |
| </telerik:RadComboBox> |
| </div> |
| <div class="row"> |
| <span class="label">Assigned To:</span> |
| <telerik:RadComboBox ID="ddlBuyer" runat="server" Width="280px" AllowCustomText="true" |
| Filter="Contains" ShowDropDownOnTextboxClick="true" ShowToggleImage="false"> |
| </telerik:RadComboBox> |
| </div> |
| <div class="row"> |
| <span class="label">Staus:</span> |
| <telerik:RadComboBox ID="ddlStatus" runat="server"> |
| <Items> |
| <telerik:RadComboBoxItem Text="Not Completed" Value="0" /> |
| <telerik:RadComboBoxItem Text="Completed" Value="1" /> |
| </Items> |
| </telerik:RadComboBox> |
| </div> |
| <div class="button-row"> |
| <asp:LinkButton ID="btnSave" runat="server" Text="Save" CommandName="Update" /> |
| <asp:LinkButton ID="btnCancel" runat="server" Text="Save" CommandName="Cancel" CausesValidation="false" /> |
| </div> |
| </AdvancedEditTemplate> |
| <AdvancedInsertTemplate> |
| <div class="row"> |
| <span class="label">Description:</span> |
| <telerik:RadTextBox ID="txtDescription" runat="server" MaxLength="100" Width="280px" |
| Text='<%# Bind("Subject") %>'> |
| </telerik:RadTextBox> |
| </div> |
| <div class="row"> |
| <span class="label">Date/Time:</span> |
| <telerik:RadDateTimePicker ID="dtpDateToPurchase" runat="server" SelectedDate='<%# Bind("Start") %>'> |
| <Calendar ShowOtherMonthsDays="False" ShowRowHeaders="False" UseColumnHeadersAsSelectors="False" |
| UseRowHeadersAsSelectors="False" ViewSelectorText="x"> |
| </Calendar> |
| <TimeView CellSpacing="-1" Culture="English (Canada)" Interval="00:30:00" StartTime="08:00:00" |
| EndTime="23:59:59" Columns="4"> |
| </TimeView> |
| <TimePopupButton HoverImageUrl="" ImageUrl="" /> |
| <DatePopupButton HoverImageUrl="" ImageUrl="" /> |
| </telerik:RadDateTimePicker> |
| </div> |
| <div class="row"> |
| <span class="label">Property:</span> |
| <telerik:RadComboBox ID="ddlProperty" runat="server" Width="280px"> |
| <CollapseAnimation Duration="200" Type="OutQuint" /> |
| </telerik:RadComboBox> |
| </div> |
| <div class="row"> |
| <span class="label">Assigned To:</span> |
| <telerik:RadComboBox ID="ddlBuyer" runat="server" Width="280px" AllowCustomText="true" |
| Filter="Contains" ShowDropDownOnTextboxClick="true" ShowToggleImage="false"> |
| </telerik:RadComboBox> |
| </div> |
| <div class="row"> |
| <span class="label">Status:</span> |
| <telerik:RadComboBox ID="ddlStatus" runat="server"> |
| <Items> |
| <telerik:RadComboBoxItem Text="Not Completed" Value="0" /> |
| <telerik:RadComboBoxItem Text="Completed" Value="1" /> |
| </Items> |
| </telerik:RadComboBox> |
| </div> |
| <div class="button-row"> |
| <asp:LinkButton ID="btnSave" runat="server" Text="Save" CommandName="Insert" /> |
| <asp:LinkButton ID="btnCancel" runat="server" Text="Save" CommandName="Cancel" CausesValidation="false" /> |
| </div> |
| </AdvancedInsertTemplate> |
| </telerik:RadScheduler> |