<%
@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false"
CodeFile="Default2.aspx.vb" Inherits="Default2" %>
<%
@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<
asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<telerik:RadGrid ID="RadGrid1" runat="server" AllowSorting="True" AutoGenerateDeleteColumn="True"
AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1" GridLines="None"
Skin="Inox">
<MasterTableView AutoGenerateColumns="False" DataKeyNames="UserID" DataSourceID="SqlDataSource1">
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>
<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
<Columns>
<telerik:GridBoundColumn DataField="UserID" DataType="System.Int32" HeaderText="UserID"
ReadOnly="True" SortExpression="UserID" UniqueName="UserID">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="LastName" HeaderText="LastName" SortExpression="LastName"
UniqueName="LastName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName"
UniqueName="FirstName">
</telerik:GridBoundColumn>
<telerik:GridBoundColumn DataField="UserName" HeaderText="UserName" SortExpression="UserName"
UniqueName="UserName">
</telerik:GridBoundColumn>
<telerik:GridDropDownColumn DataField="SecurityLevelID" DataSourceID="SqlDataSource2"
HeaderText="SecurityLevel" ListTextField="Description" ListValueField="SecurityLevelID"
UniqueName="SecurityLevelID">
</telerik:GridDropDownColumn>
</Columns>
</MasterTableView>
<FilterMenu EnableTheming="True">
<CollapseAnimation Type="OutQuint" Duration="200"></CollapseAnimation>
</FilterMenu>
</telerik:RadGrid>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:NewDoesConnectionString %>"
DeleteCommand="DELETE FROM [User] WHERE [UserID] = @UserID" InsertCommand="INSERT INTO [User] ([LastName], [FirstName], [UserName], [SecurityLevelID]) VALUES (@LastName, @FirstName, @UserName, @SecurityLevelID)"
ProviderName="<%$ ConnectionStrings:NewDoesConnectionString.ProviderName %>"
SelectCommand="SELECT [UserID], [LastName], [FirstName], [UserName], [SecurityLevelID] FROM [User]"
UpdateCommand="UPDATE [User] SET [LastName] = @LastName, [FirstName] = @FirstName, [UserName] = @UserName, [SecurityLevelID] = @SecurityLevelID WHERE [UserID] = @UserID">
<DeleteParameters>
<asp:Parameter Name="UserID" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="UserName" Type="String" />
<asp:Parameter Name="SecurityLevelID" Type="Int32" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="LastName" Type="String" />
<asp:Parameter Name="FirstName" Type="String" />
<asp:Parameter Name="UserName" Type="String" />
<asp:Parameter Name="SecurityLevelID" Type="Int32" />
<asp:Parameter Name="UserID" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:NewDoesConnectionString %>"
SelectCommand="SELECT [SecurityLevelID], [Description] FROM [SecurityLevel]">
</asp:SqlDataSource>
</
asp:Content>