50 lines
3.5 KiB
Text
50 lines
3.5 KiB
Text
|
<%@ Page Title="" Language="C#" MasterPageFile="~/Siten.master" AutoEventWireup="true" CodeBehind="phoneNPContacts.aspx.cs" Inherits="safety.phoneNPContacts" %>
|
||
|
|
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
|
||
|
|
<telerik:RadGrid runat="server" ID="gridRooms" AutoGenerateDeleteColumn="True" AutoGenerateEditColumn="True" DataSourceID="SqlDataSource1" GroupPanelPosition="Top" CellSpacing="-1" GridLines="Both" AutoGenerateColumns="False">
|
||
|
|
|
||
|
|
<GroupingSettings CollapseAllTooltip="Collapse all groups" CaseSensitive="false"></GroupingSettings>
|
||
|
|
|
||
|
|
<ExportSettings OpenInNewWindow="true">
|
||
|
|
<Excel FileExtension="xlsx" Format="Xlsx" />
|
||
|
|
</ExportSettings>
|
||
|
|
|
||
|
|
<MasterTableView AllowAutomaticDeletes="True" AllowAutomaticInserts="True" AllowAutomaticUpdates="True" AllowSorting="True" CommandItemDisplay="Top" DataSourceID="SqlDataSource1">
|
||
|
|
<CommandItemSettings ShowExportToExcelButton="True" />
|
||
|
|
<Columns>
|
||
|
|
<telerik:GridBoundColumn DataField="idNPContact" DataType="System.Int32" FilterControlAltText="Filter idNPContact column" HeaderText="idNPContact" ReadOnly="True" SortExpression="idNPContact" UniqueName="idNPContact">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="name" FilterControlAltText="Filter name column" HeaderText="name" SortExpression="name" UniqueName="name">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="company" FilterControlAltText="Filter company column" HeaderText="company" SortExpression="company" UniqueName="company">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="phone" FilterControlAltText="Filter phone column" HeaderText="phone" SortExpression="phone" UniqueName="phone">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="phone2" FilterControlAltText="Filter phone2 column" HeaderText="phone2" SortExpression="phone2" UniqueName="phone2">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
<telerik:GridBoundColumn DataField="remark" FilterControlAltText="Filter remark column" HeaderText="remark" SortExpression="remark" UniqueName="remark">
|
||
|
|
</telerik:GridBoundColumn>
|
||
|
|
</Columns>
|
||
|
|
</MasterTableView>
|
||
|
|
|
||
|
|
</telerik:RadGrid>
|
||
|
|
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:idpbwConnectionString %>" InsertCommand="phoneNoodplanContactInsert" InsertCommandType="StoredProcedure" SelectCommand="phoneNoodplanContactSelect" SelectCommandType="StoredProcedure" UpdateCommand="phoneNoodplanContactUpdate" UpdateCommandType="StoredProcedure" CancelSelectOnNullParameter="False">
|
||
|
|
<InsertParameters>
|
||
|
|
|
||
|
|
<asp:Parameter Name="name" Type="String" />
|
||
|
|
<asp:Parameter Name="company" Type="String" />
|
||
|
|
<asp:Parameter Name="phone" Type="String" />
|
||
|
|
<asp:Parameter Name="phone2" Type="String" />
|
||
|
|
<asp:Parameter Name="remark" Type="String" />
|
||
|
|
|
||
|
|
</InsertParameters>
|
||
|
|
<UpdateParameters>
|
||
|
|
<asp:Parameter Name="idNPContact" Type="Int32" />
|
||
|
|
<asp:Parameter Name="name" Type="String" />
|
||
|
|
<asp:Parameter Name="company" Type="String" />
|
||
|
|
<asp:Parameter Name="phone" Type="String" />
|
||
|
|
<asp:Parameter Name="phone2" Type="String" />
|
||
|
|
<asp:Parameter Name="remark" Type="String" />
|
||
|
|
</UpdateParameters>
|
||
|
|
</asp:SqlDataSource>
|
||
|
|
</asp:Content>
|