webform1.aspx
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="dynamicweb8_11.WebForm1" %>
<!DOCTYPE html>
<html xmlns="https://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<center><h3>添加学生信息</h3></center>
<asp:SqlDataSource ID="sdsStudent" runat="server" ConnectionString="<%$ ConnectionStrings:studentMISConnectionString %>" DeleteCommand="DELETE FROM [student] WHERE [stu_id] = @stu_id" InsertCommand="INSERT INTO [student] ([stu_id], [stu_name], [sex], [birth_date], [major], [isCPC], [email]) VALUES (@stu_id, @stu_name, @sex, @birth_date, @major, @isCPC, @email)" SelectCommand="SELECT * FROM [student]" UpdateCommand="UPDATE [student] SET [stu_name] = @stu_name, [sex] = @sex, [birth_date] = @birth_date, [major] = @major, [isCPC] = @isCPC, [email] = @email WHERE [stu_id] = @stu_id">
<DeleteParameters>
<asp:Parameter Name="stu_id" Type="String" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="stu_id" Type="String" />
<asp:Parameter Name="stu_name" Type="String" />
<asp:Parameter Name="sex" Type="String" />
<asp:Parameter Name="birth_date" Type="DateTime" />
<asp:Parameter Name="major" Type="String" />
<asp:Parameter Name="isCPC" Type="Boolean" />
<asp:Parameter Name="email" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="stu_name" Type="String" />
<asp:Parameter Name="sex" Type="String" />
<asp:Parameter Name="birth_date" Type="DateTime" />
<asp:Parameter Name="major" Type="String" />
<asp:Parameter Name="isCPC" Type="Boolean" />
<asp:Parameter Name="email" Type="String" />
<asp:Parameter Name="stu_id" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:DetailsView ID="dvStudent" runat="server" Width="300px" HorizontalAlign="Center" Font-Size="Small" AutoGenerateRows="False" CellPadding="4" DataKeyNames="stu_id" DataSourceID="sdsStudent" DefaultMode="Insert" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" />
<CommandRowStyle BackColor="#D1DDF1" Font-Bold="True" />
<EditRowStyle BackColor="#2461BF" />
<FieldHeaderStyle BackColor="#DEE8F5" Font-Bold="True" />
<Fields>
<asp:TemplateField HeaderText="学号" SortExpression="stu_id">
<EditItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("stu_id") %>'></asp:Label>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("stu_id") %>' Width="60px"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage="学号必填" ForeColor="#CC3300" SetFocusOnError="True"></asp:RequiredFieldValidator>
<asp:RangeValidator ID="RangeValidator1" runat="server" ControlToValidate="TextBox1" Display="Dynamic" ErrorMessage="输入学号超出范围" ForeColor="#CC3300" MaximumValue="20509999" MinimumValue="20000001" SetFocusOnError="True" Type="Integer"></asp:RangeValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("stu_id") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="姓名" SortExpression="stu_name">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("stu_name") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("stu_name") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2" Display="Dynamic" ErrorMessage="不能为空" ForeColor="#CC3300" SetFocusOnError="True"></asp:RequiredFieldValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("stu_name") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="性别" SortExpression="sex">
<EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("sex") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal" SelectedValue='<%# Bind("sex") %>'>
<asp:ListItem Value="男"></asp:ListItem>
<asp:ListItem Value="女"></asp:ListItem>
</asp:RadioButtonList>
<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="RadioButtonList1" Display="Dynamic" ErrorMessage="性别必填" ForeColor="#CC3300" SetFocusOnError="True"></asp:RequiredFieldValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("sex") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="生日" SortExpression="birth_date">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("birth_date") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("birth_date") %>'></asp:TextBox>
<asp:CompareValidator ID="CompareValidator1" runat="server" ControlToValidate="TextBox4" Display="Dynamic" ErrorMessage="日期格式不正确" ForeColor="#CC3300" Operator="DataTypeCheck" SetFocusOnError="True" Type="Date"></asp:CompareValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("birth_date") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="专业" SortExpression="major">
<EditItemTemplate>
<asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("major") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="sdsMajor" DataTextField="major" DataValueField="major" SelectedValue='<%# Bind("major") %>'>
</asp:DropDownList>
<asp:SqlDataSource ID="sdsMajor" runat="server" ConnectionString="<%$ ConnectionStrings:studentMISConnectionString %>" SelectCommand="SELECT DISTINCT [major] FROM [student]"></asp:SqlDataSource>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label5" runat="server" Text='<%# Bind("major") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CheckBoxField DataField="isCPC" HeaderText="是否入党" SortExpression="isCPC" />
<asp:TemplateField HeaderText="电子邮件" SortExpression="email">
<EditItemTemplate>
<asp:TextBox ID="TextBox5" runat="server" Text='<%# Bind("email") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:TextBox ID="TextBox6" runat="server" Text='<%# Bind("email") %>'></asp:TextBox>
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ControlToValidate="TextBox6" Display="Dynamic" ErrorMessage="格式不正确" ForeColor="#CC3300" SetFocusOnError="True" ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"></asp:RegularExpressionValidator>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label6" runat="server" Text='<%# Bind("email") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowInsertButton="True" />
</Fields>
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#ffffff" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#EFF3FB" />
</asp:DetailsView>
</div>
</form>
</body>
</html>
<%@ Page Language="C#" AutoEven
