64 lines
4.2 KiB
Text
64 lines
4.2 KiB
Text
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeBehind="BR2Cycli.aspx.cs" Inherits="safety.BR2Cycli" %>
|
|
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
|
|
<h1>BR2 Cycli</h1>
|
|
<telerik:RadGrid ID="RadGrid1" runat="server" AllowFilteringByColumn="True" AllowSorting="True" AutoGenerateColumns="False" AutoGenerateEditColumn="True" CellSpacing="0" DataSourceID="SqlDSRems5" GridLines="None" AllowAutomaticInserts="True">
|
|
<ExportSettings>
|
|
<Pdf PageWidth="">
|
|
</Pdf>
|
|
</ExportSettings>
|
|
<MasterTableView AllowAutomaticUpdates="True" CommandItemDisplay="Top" DataKeyNames="id" DataSourceID="SqlDSRems5">
|
|
<Columns>
|
|
<telerik:GridBoundColumn DataField="id" DataType="System.Int32" FilterControlAltText="Filter id column" HeaderText="id" ReadOnly="True" SortExpression="id" UniqueName="id">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="tp" FilterControlAltText="Filter tp column" HeaderText="tp" SortExpression="tp" UniqueName="tp">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="year" DataType="System.Int32" FilterControlAltText="Filter year column" HeaderText="year" SortExpression="year" UniqueName="year">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="seq" DataType="System.Int32" FilterControlAltText="Filter seq column" HeaderText="seq" SortExpression="seq" UniqueName="seq">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="van" DataType="System.DateTime" FilterControlAltText="Filter van column" HeaderText="van" SortExpression="van" UniqueName="van">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
<telerik:GridBoundColumn DataField="tot" DataType="System.DateTime" FilterControlAltText="Filter tot column" HeaderText="tot" SortExpression="tot" UniqueName="tot">
|
|
<ColumnValidationSettings>
|
|
<ModelErrorMessage Text="" />
|
|
</ColumnValidationSettings>
|
|
</telerik:GridBoundColumn>
|
|
</Columns>
|
|
</MasterTableView>
|
|
</telerik:RadGrid>
|
|
<asp:SqlDataSource ID="SqlDSRems5" runat="server" ConnectionString="<%$ ConnectionStrings:remsConnectionString2 %>" SelectCommand="SELECT * FROM [br2Cycli]" DeleteCommand="DELETE FROM [br2Cycli] WHERE [id] = @id" InsertCommand="INSERT INTO [br2Cycli] ([tp], [year], [seq], [van], [tot]) VALUES (@tp, @year, @seq, @van, @tot)" UpdateCommand="UPDATE [br2Cycli] SET [tp] = @tp, [year] = @year, [seq] = @seq, [van] = @van, [tot] = @tot WHERE [id] = @id">
|
|
<DeleteParameters>
|
|
<asp:Parameter Name="id" Type="Int32" />
|
|
</DeleteParameters>
|
|
<InsertParameters>
|
|
<asp:Parameter Name="tp" Type="String" />
|
|
<asp:Parameter Name="year" Type="Int32" />
|
|
<asp:Parameter Name="seq" Type="Int32" />
|
|
<asp:Parameter Name="van" Type="DateTime" />
|
|
<asp:Parameter Name="tot" Type="DateTime" />
|
|
</InsertParameters>
|
|
<UpdateParameters>
|
|
<asp:Parameter Name="tp" Type="String" />
|
|
<asp:Parameter Name="year" Type="Int32" />
|
|
<asp:Parameter Name="seq" Type="Int32" />
|
|
<asp:Parameter Name="van" Type="DateTime" />
|
|
<asp:Parameter Name="tot" Type="DateTime" />
|
|
<asp:Parameter Name="id" Type="Int32" />
|
|
</UpdateParameters>
|
|
</asp:SqlDataSource>
|
|
</asp:Content>
|