gridview

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="Eye.ascx.cs" Inherits="Controls_Eye" %>
<table cellpadding="1" cellspacing="0">
    
<tr>
        
<td>
            
<asp:ValidationSummary ID="vsCheck" runat="server" Enabled="true" Width="250px" HeaderText="Please correct the following errors:"
                EnableClientScript
="true" ValidationGroup="vgEye" />
            
<asp:ValidationSummary ID="ValidationSummary1" runat="server" Enabled="true" Width="250px"
                HeaderText
="Please correct the following errors:" EnableClientScript="true" ValidationGroup="vgAdd" />
            
<asp:SqlDataSource SelectCommand="SELECT * FROM [Eye] where TrackID=@TrackID" DeleteCommand="DELETE FROM [Eye] WHERE [EyeID] = @EyeID"
                UpdateCommand
="UPDATE [Eye] SET [TrackID] = @TrackID, [EyeNumber] = @EyeNumber, [Position] = @Position, [Function] = @Function, [CumulativeDistance] = @CumulativeDistance, [IntervalDistance] = @IntervalDistance WHERE [EyeID] = @EyeID"
                InsertCommand
="INSERT INTO [Eye](TrackID,EyeNumber,Position,[Function],CumulativeDistance,IntervalDistance) VALUES (@TrackID,@EyeNumber,@Position,@Function,@CumulativeDistance,@IntervalDistance)"
                ID
="sdsEye" ConnectionString="<%$ ConnectionStrings:ConnectionInfo %>" runat="server"
                OnSelecting
="sdsEye_Selecting">
                
<SelectParameters>
                    
<asp:Parameter Name="TrackID" Type="Int32" />
                
</SelectParameters>
                
<DeleteParameters>
                    
<asp:Parameter Name="EyeID" Type="Int32" />
                
</DeleteParameters>
                
<UpdateParameters>
                    
<asp:Parameter Name="TrackID" Type="Int32" />
                    
<asp:Parameter Name="EyeNumber" Type="Int32" />
                    
<asp:Parameter Name="Position" Type="String" />
                    
<asp:Parameter Name="Function" Type="String" />
                    
<asp:Parameter Name="CumulativeDistance" Type="Double" />
                    
<asp:Parameter Name="IntervalDistance" Type="Double" />
                    
<asp:Parameter Name="EyeID" Type="Int32" />
                
</UpdateParameters>
                
<InsertParameters>
                    
<asp:Parameter Name="TrackID" Type="Int32" />
                    
<asp:Parameter Name="EyeNumber" Type="Int32" />
                    
<asp:Parameter Name="Position" Type="String" />
                    
<asp:Parameter Name="Function" Type="String" />
                    
<asp:Parameter Name="CumulativeDistance" Type="Double" />
                    
<asp:Parameter Name="IntervalDistance" Type="Double" />
                
</InsertParameters>
            
</asp:SqlDataSource>
            
<asp:GridView ID="gvEye" AutoGenerateColumns="False" DataSourceID="sdsEye" DataKeyNames="EyeID"
                AllowPaging
="True" AllowSorting="True" runat="server" OnRowUpdating="gvEye_RowUpdating">
                
<Columns>
                    
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" CausesValidation="true"
                        ValidationGroup
="vgEye" />
                    
<asp:TemplateField HeaderText="EyeNumber" SortExpression="EyeNumber" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                        
<ItemTemplate>
                            
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblEyeNumber" Text='<%#Bind("EyeNumber")%>'></asp:Label>
                        
</ItemTemplate>
                        
<EditItemTemplate>
                            
<asp:TextBox runat="Server" CssClass="EyeControlShortTextBox" ID="txtEyeNumber" Text='<%#Bind("EyeNumber")%>'></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvEyeNumber" runat="server" ControlToValidate="txtEyeNumber"
                                ErrorMessage
="Eye number Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                            
<asp:RegularExpressionValidator runat="server" ID="rxvEyeNumber" ErrorMessage="Eye number needs to be number"
                                Text
="*" ValidationGroup="vgEye" ValidationExpression="^[0-9]+$" ControlToValidate="txtEyeNumber">
                            
</asp:RegularExpressionValidator>
                        
</EditItemTemplate>
                        
<FooterTemplate>
                            
<asp:TextBox ID="txtFooterEyeNumber" CssClass="EyeControlShortTextBox" runat="server"></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvEyeNumber" runat="server" ControlToValidate="txtFooterEyeNumber"
                                ErrorMessage
="Eye number Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                            
<asp:RegularExpressionValidator runat="server" ID="rxvEyeNumber" ErrorMessage="Eye number needs to be number"
                                Text
="*" ValidationGroup="vgEye" ValidationExpression="^[0-9]+$" ControlToValidate="txtFooterEyeNumber">
                            
</asp:RegularExpressionValidator>
                        
</FooterTemplate>
                    
</asp:TemplateField>
                    
<asp:TemplateField HeaderText="Position" SortExpression="Position" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                        
<ItemTemplate>
                            
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblPosition" Text='<%#Bind("Position")%>'></asp:Label>
                        
</ItemTemplate>
                        
<EditItemTemplate>
                            
<asp:TextBox runat="server" CssClass="EyeControlLongTextBox" ID="txtPosition" Text='<%#Bind("Position")%>'></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvPosition" runat="server" ControlToValidate="txtPosition"
                                ErrorMessage
="Position Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                        
</EditItemTemplate>
                        
<FooterTemplate>
                            
<asp:TextBox CssClass="EyeControlLongTextBox" ID="txtFooterPosition" runat="server"></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvPosition" runat="server" ControlToValidate="txtFooterPosition"
                                ErrorMessage
="Position Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                        
</FooterTemplate>
                    
</asp:TemplateField>
                    
<asp:TemplateField HeaderText="Function" SortExpression="Function" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                        
<ItemTemplate>
                            
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblFunction" Text='<%#Bind("Function")%>'></asp:Label>
                        
</ItemTemplate>
                        
<EditItemTemplate>
                            
<asp:TextBox runat="Server" CssClass="EyeControlLongTextBox" ID="txtFunction" Text='<%#Bind("Function")%>'></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvFunction" runat="server" ControlToValidate="txtFunction"
                                ErrorMessage
="Function Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                        
</EditItemTemplate>
                        
<FooterTemplate>
                            
<asp:TextBox CssClass="EyeControlLongTextBox" ID="txtFooterFunction" runat="server"></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvFunction" runat="server" ControlToValidate="txtFooterFunction"
                                ErrorMessage
="Function Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                        
</FooterTemplate>
                    
</asp:TemplateField>
                    
<asp:TemplateField HeaderText="CumulativeDistance" SortExpression="CumulativeDistance" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                        
<ItemTemplate>
                            
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblCumulativeDistance" Text='<%#Bind("CumulativeDistance")%>'></asp:Label>
                        
</ItemTemplate>
                        
<EditItemTemplate>
                            
<asp:TextBox runat="Server" CssClass="EyeControlShortTextBox" ID="txtCumulativeDistance" Text='<%#Bind("CumulativeDistance")%>'></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvCumulativeDistance" runat="server" ControlToValidate="txtCumulativeDistance"
                                ErrorMessage
="Cumulative Distance Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                            
<asp:RegularExpressionValidator runat="server" ID="rxvCumulativeDistance" ErrorMessage="Cumulative Distance needs to be number"
                                Text
="*" ValidationGroup="vgEye" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtCumulativeDistance">
                            
</asp:RegularExpressionValidator>
                        
</EditItemTemplate>
                        
<FooterTemplate>
                            
<asp:TextBox CssClass="EyeControlShortTextBox" ID="txtFooterCumulativeDistance" runat="server"></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvCumulativeDistance" runat="server" ControlToValidate="txtFooterCumulativeDistance"
                                ErrorMessage
="Cumulative Distance Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                            
<asp:RegularExpressionValidator runat="server" ID="rxvCumulativeDistance" ErrorMessage="Cumulative Distance needs to be number"
                                Text
="*" ValidationGroup="vgEye" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtFooterCumulativeDistance">
                            
</asp:RegularExpressionValidator>
                        
</FooterTemplate>
                    
</asp:TemplateField>
                    
<asp:TemplateField HeaderText="IntervalDistance" SortExpression="IntervalDistance" FooterStyle-HorizontalAlign="Center" ItemStyle-HorizontalAlign="Center">
                        
<ItemTemplate>
                            
<asp:Label CssClass="EyeControlLabel" runat="Server" ID="lblIntervalDistance" Text='<%#Bind("IntervalDistance")%>'></asp:Label>
                        
</ItemTemplate>
                        
<EditItemTemplate>
                            
<asp:TextBox runat="Server" CssClass="EyeControlShortTextBox" ID="txtIntervalDistance" Text='<%#Bind("IntervalDistance")%>'></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvIntervalDistance" runat="server" ControlToValidate="txtIntervalDistance"
                                ErrorMessage
="Interval Distance Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                            
<asp:RegularExpressionValidator runat="server" ID="rxvIntervalDistance" ErrorMessage="Interval Distance needs to be number"
                                Text
="*" ValidationGroup="vgEye" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtIntervalDistance">
                            
</asp:RegularExpressionValidator>
                        
</EditItemTemplate>
                        
<FooterTemplate>
                            
<asp:TextBox CssClass="EyeControlShortTextBox" ID="txtFooterIntervalDistance" runat="server"></asp:TextBox>
                            
<asp:RequiredFieldValidator ID="rfvIntervalDistance" runat="server" ControlToValidate="txtFooterIntervalDistance"
                                ErrorMessage
="Interval Distance Required" Text="*" ValidationGroup="vgEye">
                            
</asp:RequiredFieldValidator>
                            
<asp:RegularExpressionValidator runat="server" ID="rxvIntervalDistance" ErrorMessage="Interval Distance needs to be number"
                                Text
="*" ValidationGroup="vgEye" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtFooterIntervalDistance">
                            
</asp:RegularExpressionValidator>
                        
</FooterTemplate>
                    
</asp:TemplateField>
                
</Columns>
            
</asp:GridView>
            
<div runat="Server" id="inputDiv">
                
<asp:Label ID="lblAddEyeNumber" runat="server" Text="Eye Number:" CssClass="EyeUserControlLabel"></asp:Label>
                
<asp:TextBox ID="txtAddEyeNumber" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
                
<asp:RequiredFieldValidator ID="rfvAddEyeNumber" runat="server" ControlToValidate="txtAddEyeNumber"
                    ErrorMessage
="Eye number Required" Text="*" ValidationGroup="vgAdd">
                
</asp:RequiredFieldValidator>
                
<asp:RegularExpressionValidator runat="server" ID="rxvAddEyeNumber" ErrorMessage="Eye number needs to be number"
                    Text
="*" ValidationGroup="vgAdd" ValidationExpression="^[0-9]+$" ControlToValidate="txtAddEyeNumber">
                
</asp:RegularExpressionValidator>
                
<br />
                
<asp:Label ID="lblAddPosition" runat="server" Text="Position:" CssClass="EyeUserControlLabel"></asp:Label>
                
<asp:TextBox ID="txtAddPosition" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
                
<asp:RequiredFieldValidator ID="rfvAddPosition" runat="server" ControlToValidate="txtAddPosition"
                    ErrorMessage
="Position Required" Text="*" ValidationGroup="vgAdd">
                
</asp:RequiredFieldValidator>
                
<br />
                
<asp:Label ID="lblAddFunction" runat="server" Text="Function:" CssClass="EyeUserControlLabel"></asp:Label>
                
<asp:TextBox ID="txtAddFunction" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
                
<asp:RequiredFieldValidator ID="rfvAddFunction" runat="server" ControlToValidate="txtAddFunction"
                    ErrorMessage
="Function Required" Text="*" ValidationGroup="vgAdd">
                
</asp:RequiredFieldValidator>
                
<br />
                
<asp:Label ID="lblAddCumulativeDistance" runat="server" Text="Cumulative Distance:"
                    CssClass
="EyeUserControlLabel"></asp:Label>
                
<asp:TextBox ID="txtAddCumulativeDistance" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
                
<asp:RequiredFieldValidator ID="rfvAddCumulativeDistance" runat="server" ControlToValidate="txtAddCumulativeDistance"
                    ErrorMessage
="Cumulative Distance Required" Text="*" ValidationGroup="vgAdd">
                
</asp:RequiredFieldValidator>
                
<asp:RegularExpressionValidator runat="server" ID="rxvAddCumulativeDistance" ErrorMessage="Cumulative Distance needs to be number"
                    Text
="*" ValidationGroup="vgAdd" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtAddCumulativeDistance">
                
</asp:RegularExpressionValidator>
                
<br />
                
<asp:Label ID="lblAddIntervalDistance" runat="server" Text="Interval Distance:" CssClass="EyeUserControlLabel"></asp:Label>
                
<asp:TextBox ID="txtAddIntervalDistance" runat="server" CssClass="EyeUserControlTextBox"></asp:TextBox>
                
<asp:RequiredFieldValidator ID="rfvAddIntervalDistance" runat="server" ControlToValidate="txtAddIntervalDistance"
                    ErrorMessage
="Interval Distance Required" Text="*" ValidationGroup="vgAdd">
                
</asp:RequiredFieldValidator>
                
<asp:RegularExpressionValidator runat="server" ID="rxvAddIntervalDistance" ErrorMessage="Interval Distance needs to be number"
                    Text
="*" ValidationGroup="vgAdd" ValidationExpression="^((\d)+)(\.\d+)?$" ControlToValidate="txtAddIntervalDistance">
                
</asp:RegularExpressionValidator>
                
<br />
            
</div>
            
<br />
            
<asp:Button ID="btnAdd" runat="server" Text="Add new" OnClick="btnAdd_Click" />
            
<asp:Button runat="server" ID="btnSave" Text="Save" CausesValidation="true" ValidationGroup="vgAdd"
                OnClick
="btnSave_Click" Visible="false" />
            
<asp:Button runat="Server" ID="btnFooterSave" Text="Save" CausesValidation="true"
                ValidationGroup
="vgEye" Visible="false" OnClick="btnFooterSave_Click" />
            
<asp:Button runat="Server" ID="btnCancel" Text="Cancel" OnClick="btnCancel_Click"
                Visible
="false" />
        
</td>
    
</tr>
</table>
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Entities;
using DomainObjects;

public partial class Controls_Eye : System.Web.UI.UserControl
{
    
public int TrackID
    
{
        
get
        
{
            
return Convert.ToInt32(this.ViewState["TrackID"]);
        }

        
set
        
{
            
this.ViewState["TrackID"= value;
            
this.gvEye.DataBind();
        }

    }

    
"Page_Load"

    
"btnAdd_Click"

    
"ShowAddingLayout"

    
"btnSave_Click"

    
"btnCancel_Click"

    
"btnFooterSave_Click"

    
"sdsEye_Selecting"

    
"gvEye_RowUpdating"
}

posted @ 2008-03-27 22:24  N/A2011  阅读(256)  评论(0编辑  收藏  举报