or
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="reg.aspx.vb" Inherits="TelerikWebForm" MasterPageFile="~/masterpage.master" maintainScrollPositionOnPostback = "true" %><asp:Content id="content1" ContentPlaceHolderID="cph_content" runat="server"> <telerik:RadScriptManager ID="RadScriptManager1" runat="server"> <Scripts> <%--Needed for JavaScript IntelliSense in VS2010--%> <%--For VS2008 replace RadScriptManager with ScriptManager--%> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" /> <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" /> </Scripts> </telerik:RadScriptManager> <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server"> </telerik:RadAjaxManager> <telerik:RadSkinManager ID="RadSkinManager1" Runat="server" Skin="Web20"> </telerik:RadSkinManager> <div id="main"> <div id="content"> <telerik:RadAjaxPanel ID="RadAjaxPanel1" runat="server" Width="680px" LoadingPanelID="RadAjaxLoadingPanel1"> <!--COMPANY / ISSUE--> <telerik:RadComboBox ID="RadComboBox1" Label="Name of Stock: " runat="server" Width="300px" LabelWidth="133px" Height="150px" EmptyMessage="Enter Name of Company whose stock you own" DataSourceID="sqldatasource1" DataTextField="coname" DataValueField="issuenum" EnableAutomaticLoadOnDemand="True" ShowMoreResultsBox="true" EnableVirtualScrolling="True" OnSelectedIndexChanged="RadComboBox1_SelectedIndexChanged" AllowCustomText="false" LoadingMessage="Searching..." MinFilterLength="0" AutoPostBack="true"> </telerik:RadComboBox> <asp:Label ID="lblConameLookup" runat="server" Text=" " Width="275" CssClass="label1" Visible="true"></asp:Label> <asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ErrorMessage="Name of Stock is required." ControlToValidate="RadComboBox1" CssClass="label1error"></asp:RequiredFieldValidator> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="..."></asp:SqlDataSource> <br /> <!--USERNAME--> <telerik:RadTextBox ID="txtUsername" runat="server" Label="Username:" EmptyMessage="30 character max" MaxLength="30" LabelWidth="130" Width="300" OnTextChanged="txtUsername_TextChanged" AutoPostBack="true"> </telerik:RadTextBox> <img alt="Info" src="/images/icon_info.png" title="Username Rules: 8 - 30 characters in length; can only contain the following: A-Z, a-z, 0-9, ! @ . _ - " class="infoicon" /> <asp:Label ID="lblUsernameValidatorMsg" runat="server" Text=" " CssClass="label1error" Visible="false"></asp:Label> <asp:TextBox ID="txtUsernameValidatorStatus" visible="false" Text="Invalid" runat="server"></asp:TextBox> </telerik:RadAjaxPanel> <!--BUTTONS--> <telerik:RadButton ID="RadButton1" runat="server" Text="Submit" CausesValidation="true" > </telerik:RadButton> <telerik:RadAjaxLoadingPanel ID="RadAjaxLoadingPanel1" runat="server" > </telerik:RadAjaxLoadingPanel> </div></div> <telerik:RadToolTipManager ID="RadToolTipManager1" runat="server" RelativeTo="Element" Position="MiddleRight" AutoTooltipify="true" ContentScrolling="Default" Width="225" Height="10" AutoCloseDelay="10000"> </telerik:RadToolTipManager></asp:Content>Protected Sub RadComboBox1_SelectedIndexChanged(sender As Object, e As Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs) Handles RadComboBox1.SelectedIndexChanged Dim strConn As String = System.Configuration.ConfigurationManager.ConnectionStrings("CONN").ConnectionString Dim MySQL As String = "SELECT ticker FROM [table] WHERE [issuenum] = @issuenum" Dim MyConn As New Data.SqlClient.SqlConnection(strConn) Dim Cmd As New Data.SqlClient.SqlCommand(MySQL, MyConn) Dim DR As SqlDataReader With Cmd.Parameters .Add(New SqlClient.SqlParameter("@issuenum", UCase(Trim(RadComboBox1.SelectedValue)))) End With lblConameLookup.Visible = True Try MyConn.Open() DR = Cmd.ExecuteReader() DR.Read() lblConameLookup.CssClass = "label1" lblConameLookup.Text = DR("ticker") Catch ex As Exception lblConameLookup.CssClass = "label1error" lblConameLookup.Text = "Please select a company from the dropdown menu." End Try MyConn.Close() End Sub 'VALIDATION FOR USERNAME FIELD Protected Sub txtUsername_TextChanged(sender As Object, e As System.EventArgs) Handles txtUsername.TextChanged 'CHECK DATABASE Dim strConn As String = System.Configuration.ConfigurationManager.ConnectionStrings("CONN").ConnectionString Dim MySQL As String = "SELECT X1,X2 FROM Ytable WHERE [field] = @param" Dim MyConn As New Data.SqlClient.SqlConnection(strConn) Dim Cmd As New Data.SqlClient.SqlCommand(MySQL, MyConn) Dim DR As SqlDataReader With Cmd.Parameters .Add(New SqlClient.SqlParameter("@param", Trim(txtUsername.Text))) End With Try MyConn.Open() DR = Cmd.ExecuteReader() DR.Read() lblUsernameValidatorMsg.Visible = True If DR.HasRows = True Then lblUsernameValidatorMsg.Text = "This username is unavailable." txtUsername.Focus() End If Catch ex As Exception 'lblUserNameStatus.Text = ex.Message End Try MyConn.Close() End Sub
function keyPress(sender, eventArgs) { // Del button pressed if (eventArgs.get_keyCode() == 127) { var masterTable = sender.get_masterTableView(); for (i = 0; i < masterTable.get_selectedItems().length; i++) { var it = masterTable.get_selectedItems()[i]; var element = it.get_element(); element.deleteRow(element.rowIndex); } }
<telerik:GridTableView Name="Sales" AutoGenerateColumns="false" Width="100%" DataKeyNames="DetailCode,DetailSubCode" ShowHeadersWhenNoRecords="false" HierarchyDefaultExpanded="true" HierarchyLoadMode="ServerOnDemand"> <DetailTables> <telerik:GridTableView Name="Planning"> <ItemTemplate> <asp:GridView ID="GridView1" runat="server"> </asp:GridView> </ItemTemplate> </telerik:GridTableView> <telerik:GridTableView AutoGenerateColumns="false" DataKeyNames="ProdHeaderDossierCode" HierarchyDefaultExpanded="false" Name="ProdDossier"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="DetailCode" MasterKeyField="DetailCode" /> <telerik:GridRelationFields DetailKeyField="DetailSubCode" MasterKeyField="DetailSubCode" /> </ParentTableRelation> <Columns> <telerik:GridBoundColumn DataField="ProdHeaderDossierCode" HeaderText="ProdDossier"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ProdStatusCode" HeaderText="St."> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="StartDate" HeaderText="Start"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EndDate" HeaderText="Eind"> </telerik:GridBoundColumn> </Columns> <NoRecordsTemplate> <div style="text-align: center;"> Geen gegevens</div> </NoRecordsTemplate> <DetailTables> <telerik:GridTableView Name="Oper" AutoGenerateColumns="false" Width="100%" DataKeyNames="ProdHeaderDossierCode" ShowHeadersWhenNoRecords="false" HierarchyDefaultExpanded="false" HierarchyLoadMode="ServerOnDemand"> <ParentTableRelation> <telerik:GridRelationFields DetailKeyField="ProdHeaderDossierCode" MasterKeyField="ProdHeaderDossierCode" /> </ParentTableRelation> <Columns> <telerik:GridBoundColumn DataField="MachGrpCode" HeaderText="Bew."> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="ProdBooStatusCode" HeaderText="St."> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="MachPlanTime" HeaderText="Bew.PT"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="StartDate" HeaderText="Start"> </telerik:GridBoundColumn> <telerik:GridBoundColumn DataField="EndDate" HeaderText="Eind"> </telerik:GridBoundColumn> <telerik:GridCheckBoxColumn DataField="OperStartedInd" HeaderText="Gestart" ItemStyle-HorizontalAlign="Center"> </telerik:GridCheckBoxColumn> <telerik:GridCheckBoxColumn DataField="OperFinishedInd" HeaderText="Gereed" ItemStyle-HorizontalAlign="Center"> </telerik:GridCheckBoxColumn> </Columns> <NoRecordsTemplate> <div style="text-align: center;"> Geen gegevens</div> </NoRecordsTemplate> </telerik:GridTableView> </DetailTables> </telerik:GridTableView> </DetailTables>