or
If e.CommandName = "Assign" Then Dim item As GridDataItem = CType(e.Item, GridDataItem) Dim strJobNumber As String = e.Item.OwnerTableView.DataKeyValues(e.Item.ItemIndex)("Job_Number") Dim strButtonText As String = CType(item("button").Controls(0), Button).Text Dim NTLoginID As String = GetCurrentUser() If String.IsNullOrEmpty(strButtonText) Then Dim _db As New MyAssembly.DataContext(ConfigurationManager.ConnectionStrings("MyCNString").ConnectionString) Dim rslt = _db.TMSearchAssignments.Where(Function(x) x.JobNumber.Equals(strJobNumber)).FirstOrDefault If Not rslt Is Nothing Then CType(item("button").Controls(0), Button).Text = rslt.NTLoginID Exit Sub Else db.StoredProcedureRepo.sp_Insert_TMSearchAssignment(strJobNumber, NTLoginID, False) CType(item("button").Controls(0), Button).Text = NTLoginID End If End If End IfAdvancedForm.aspx <asp:Panel runat="server" ID="ResourceControls"> <asp:Label ID="Label1" runat="server" AssociatedControlID="ContinentsRadComboBox">Continent:</asp:Label> <telerik:RadComboBox ID="ContinentsRadComboBox" runat="server" Width="186px" OnClientSelectedIndexChanged="LoadCountries" /> <asp:Label ID="Label2" runat="server" AssociatedControlID="CountriesRadComboBox">Country:</asp:Label> <telerik:RadComboBox ID="CountriesRadComboBox" runat="server" Width="186px" OnClientItemsRequested="CountriesLoaded" OnClientSelectedIndexChanged="LoadCities" EnableViewState="false" /> <asp:Label ID="Label3" runat="server" AssociatedControlID="CitiesRadComboBox">Cities:</asp:Label> <telerik:RadComboBox ID="CitiesRadComboBox" runat="server" Width="186px" OnClientItemsRequested="CitiesLoaded" EnableViewState="false" /> </asp:Panel> DefaultVB.apsx <AppointmentTemplate> <div class="rsAptSubject"> <%# Eval("Subject")%> </div> <div> <%# Eval("Description")%></div> <div> <%# Eval("Continent")%></div> <div> <%# Eval("Country")%></div> <div> <%# Eval("City")%></div> </AppointmentTemplate><%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default3.aspx.vb" Inherits="Default3" %><%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title>Event Log</title> <style type="text/css"> .RadLoadingPanel { top: 0px; right: 0px; position: fixed; background-color: #EBEBEB; } .RadLoadingPanel img { vertical-align: middle; margin: 2px; } </style> <script type="text/javascript" src="JS/jquery-1.6.4.min.js"></script> <script type="text/javascript" src="JS/json2.js"></script> <telerik:RadCodeBlock runat="server" ID="rc"> <script type="text/javascript"> var commandName = ""; var tableView = null; function pageLoad() { setTimeout('LoadGrid();', 1); } function LoadGrid() { tableView = $find("<%= rg.ClientID %>").get_masterTableView(); commandName = "Load" executeMethod("Default3.aspx", "GetDataAndCount", getRequestData(tableView), updateGrid); } function gridOnCommand(sender, args) { if (args.get_commandName() != "PageSize") { args.set_cancel(true); LoadGrid(); } } function FailMessage() { alert('fail'); } function updateGrid(result) { tableView.set_dataSource(result.d.Data); tableView.set_virtualItemCount(result.d.Count); tableView.dataBind(); } function getRequestData(tableView) { return JSON.stringify({ "startIndex": tableView.get_currentPageIndex(), "maximumRows": tableView.get_pageSize(), "eID": $('#<%=txtEventID.ClientID %>').val(), "fDate": $find("<%= rdFrom.ClientID %>").get_selectedDate(), "tDate": $find("<%= rdTo.ClientID %>").get_selectedDate(), "sortExpression": tableView.get_sortExpressions().toString(), "filterExpression": tableView.get_filterExpressions().toDynamicLinq() }); } function executeMethod(location, methodName, methodArguments, onSuccess, onFail) { $.ajax({ type: "POST", url: location + "/" + methodName, data: methodArguments, contentType: "application/json; charset=utf-8", dataType: "json", success: onSuccess, fail: onFail, beforeSend: function() { // Handle the beforeSend event $("#<%=RadAjaxLoadingPanel1.ClientID %>").show() }, complete: function() { // Handle the complete event $("#<%=RadAjaxLoadingPanel1.ClientID %>").hide() } }); } </script> </telerik:RadCodeBlock></head><body> <form id="form1" runat="server"> <div> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> <Scripts> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js"> </asp:ScriptReference> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js"> </asp:ScriptReference> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js"> </asp:ScriptReference> </Scripts> </telerik:RadScriptManager> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" CssClass="RadLoadingPanel" IsSticky="True" EnableEmbeddedSkins="false" EnableAjaxSkinRendering="false"> <asp:Image runat="server" ID="imgLoading" ImageUrl="ajax-loader.gif" AlternateText="Loading..." /> <span>Loading...</span> </telerik:RadAjaxLoadingPanel> <table> <tr> <th> From Date </th> <td> <telerik:RadDatePicker ID="rdFrom" runat="server"> </telerik:RadDatePicker> </td> </tr> <tr> <th> To Date </th> <td> <telerik:RadDatePicker ID="rdTo" runat="server"> </telerik:RadDatePicker> </td> </tr> <tr> <th> Event ID </th> <td> <asp:TextBox ID="txtEventID" runat="server"></asp:TextBox> </td> </tr> <tr> <th> </th> <td> <a href="javascript://" onclick="LoadGrid();return false;">Search</a> </td> </tr> </table> <br /> <br /> <telerik:RadAjaxPanel ID="rp" runat="server" LoadingPanelID="RadAjaxLoadingPanel1"> <telerik:RadGrid ID="rg" runat="server" AutoGenerateColumns="False" AllowPaging="True" CellSpacing="0" GridLines="None" AllowSorting="true" > <ClientSettings EnableRowHoverStyle="True" > <ClientEvents OnCommand="gridOnCommand" /> </ClientSettings> <MasterTableView AllowNaturalSort="False" AllowMultiColumnSorting="false"> <Columns> <telerik:GridBoundColumn DataField="EventID" HeaderText="Event ID"> <ItemStyle Width="10%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EventDate" HeaderText="Event Date" DataFormatString="{0:M/dd/yy h:mm tt}" DataType="System.DateTime"> <ItemStyle Width="15%" /> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EventDesc" HeaderText="Description" AllowSorting="false"> </telerik:GridBoundColumn> </Columns> <PagerStyle AlwaysVisible="True"></PagerStyle> </MasterTableView> </telerik:RadGrid> </telerik:RadAjaxPanel> </div> </form></body></html>Imports System.Web.ServicesImports System.DataPartial Class Default3 Inherits System.Web.UI.Page <WebMethod(True)> _ Public Shared Function GetDataAndCount(ByVal startIndex As Integer, ByVal maximumRows As Integer, ByVal eID As String, ByVal fDate As Nullable(Of Date), ByVal tDate As Nullable(Of Date)) As Dictionary(Of String, Object) Dim data As New Dictionary(Of String, Object)() Using dc As New DataClassesDataContext 'dc.Log = Console.Out Dim EL = From e In dc.EventLogs _ Select e.EventID, e.EventDate, e.EventDesc _ Order By EventDate Descending If IsNumeric(eID) Then EL = EL.Where(Function(e) e.EventID = CLng(eID)) End If If fDate.HasValue Then EL = EL.Where(Function(e) e.EventDate >= fDate.Value) End If If tDate.HasValue Then EL = From e In EL _ Where e.EventDate < tDate.Value.AddDays(1) End If data.Add("Data", EL.Skip(startIndex * maximumRows).Take(maximumRows).ToList()) data.Add("Count", EL.Count) Return data End Using End FunctionEnd Classprotected void DateChange(object sender, Telerik.Web.UI.Calendar.SelectedDateChangedEventArgs e) { //Session.Add("StartDate", RadDatePicker1.SelectedDate); Session.Add("selectedMonth", RadMonthYearPicker1.DbSelectedDate); }