1<%...@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="myliuyan" Title="报名表" %>
  2<asp:Content ID="Content1"  ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
  3   <div  align="center"> 
  4       <div style="text-align: center">
  5           <table border="0" cellpadding="0" cellspacing="0">
  6               <tr>
  7                   <td align="center" style="width: 100px; height: 309px" valign="top">
  8                       <table style="width: 711px">
  9                           <tr>
 10                               <td style="width: 100px; height: 44px">
 11                               </td>
 12                               <td style="width: 588px; height: 44px">
 13                                   <font color="green" size="6">网上报名</font>
 14                               </td>
 15                               <td style="width: 100px; height: 44px">
 16                               </td>
 17                           </tr>
 18                       </table>
 19    <asp:FormView ID="FormView1" runat="server" DataKeyNames="编号" DataSourceID="AccessDataSource1"
 20        DefaultMode="Insert" Width="705px" Font-Size="XX-Large" OnItemInserted="FormView1_ItemInserted">
 21        <InsertItemTemplate>
 22            <div style="text-align: center">
 23                <table border="0" cellpadding="0" cellspacing="0" style="width: 596px">
 24                    <tr>
 25                        <td align="right" style="width: 124px; height: 22px">
 26                            申报部门：</td>
 27                        <td align="left" style="width: 400px; height: 22px">
 28                            <asp:DropDownList ID="DropDownList2" runat="server" SelectedValue='<%# Bind("aihao") %>' Width="180px">
 29                                <asp:ListItem Selected="True">请选择</asp:ListItem>
 30                                  <asp:ListItem>团委组织部</asp:ListItem>
 31                                <asp:ListItem>团委秘书处</asp:ListItem>
 32                                <asp:ListItem>团委宣传部</asp:ListItem>  
 33                                <asp:ListItem>学生会办公室</asp:ListItem>
 34                                <asp:ListItem>学生会学习部</asp:ListItem>
 35                                 <asp:ListItem>学生会外联部</asp:ListItem>
 36                                  <asp:ListItem>学生会生活部</asp:ListItem>
 37                                    <asp:ListItem>学生会宣传部</asp:ListItem>
 38                                      <asp:ListItem>学生会大学生心理健康咨询部</asp:ListItem>
 39                                        <asp:ListItem>学生会体育部</asp:ListItem>
 40                                          <asp:ListItem>学生会文艺部</asp:ListItem>
 41                            </asp:DropDownList></td>
 42                    </tr>
 43                    <tr>
 44                        <td align="right" style="width: 124px; height: 22px;">
 45                            学校邮箱：</td>
 46                        <td align="left" style="width: 400px; height: 22px;">
 47            <asp:TextBox ID="youxiangTextBox" runat="server" Text='<%# Bind("youxiang") %>'></asp:TextBox></td>
 48                    </tr>
 49                    <tr>
 50                        <td align="right" style="width: 124px">
 51                            密　　码：</td>
 52                        <td align="left" style="width: 400px">
 53            <asp:TextBox ID="mimaTextBox" runat="server" Text='<%# Bind("mima") %>' TextMode="Password"></asp:TextBox></td>
 54                    </tr>
 55                    <tr>
 56                        <td align="right" style="height: 24px; width: 124px;">
 57                            确认密码：</td>
 58                        <td align="left" style="width: 400px; height: 24px;">
 59                            <asp:TextBox ID="TextBox1" runat="server" TextMode="Password"></asp:TextBox></td>
 60                    </tr>
 61                    <tr>
 62                        <td align="right" style="height: 23px; width: 124px;">
 63                            真实姓名：</td>
 64                        <td align="left" style="width: 400px; height: 23px">
 65            <asp:TextBox ID="xingmingTextBox" runat="server" Text='<%# Bind("xingming") %>'>
 66            </asp:TextBox>
 67                            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="xingmingTextBox"
 68                                EnableClientScript="False" ErrorMessage="此项必填"></asp:RequiredFieldValidator></td>
 69                    </tr>
 70                    <tr>
 71                        <td align="right" style="width: 124px; height: 7px">
 72                            性　　别：</td>
 73                        <td align="left" style="width: 400px; height: 7px">
 74                            <asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal"
 75                                SelectedValue='<%# Bind("xingbie") %>' Width="152px">
 76                                <asp:ListItem Selected="True">女</asp:ListItem>
 77                                <asp:ListItem>男</asp:ListItem>
 78                            </asp:RadioButtonList></td>
 79                    </tr>
 80                    <tr>
 81                    <tr>
 82                        <td align="right" style="width: 124px">
 83                            专业班级：</td>
 84                        <td align="left" style="width: 400px">
 85            <asp:TextBox ID="nianlingTextBox" runat="server" Text='<%# Bind("nianling") %>'></asp:TextBox><font color="red">（示例：07客户管理2班）</font></td>
 86                    </tr>
 87                    <tr>
 88                        <td align="right" style="width: 124px; height: 19px;">
 89                            联系电话：</td>
 90                        <td align="left" style="width: 400px; height: 19px;">
 91            <asp:TextBox ID="dianhuaTextBox" runat="server" Text='<%# Bind("dianhua") %>'>
 92            </asp:TextBox><font color="red">请正确输入，以便联系</font></td>
 93                    </tr>
 94                    <tr>
 95                        <td align="right" style="width: 124px; height: 19px">
 96                            留　　言：</td>
 97                        <td align="left" style="width: 400px; height: 19px">
 98            <asp:TextBox ID="liuyanTextBox" runat="server" Text='<%# Bind("liuyan") %>' Height="93px" TextMode="MultiLine" Width="287px"></asp:TextBox></td>
 99                    </tr>
100                </table>
101            </div>
102            &nbsp;<br />
103            &nbsp;<asp:LinkButton ID="InsertButton" runat="server" CausesValidation="True" CommandName="Insert"
104                Text="提交"></asp:LinkButton>
105            <asp:LinkButton ID="InsertCancelButton" runat="server" CausesValidation="False" CommandName="Cancel"
106                Text="取消">
107            </asp:LinkButton>
108        </InsertItemTemplate>
109    </asp:FormView>
110                   </td>
111               </tr>
112           </table>
113       </div>
114       <br />
115       &nbsp;<asp:AccessDataSource ID="AccessDataSource1" runat="server" ConflictDetection="CompareAllValues"
116        DataFile="~/App_Data/itbm.mdb" DeleteCommand="DELETE FROM [myliuyan] WHERE [编号] = ? AND [xingming] = ? AND [mima] = ? AND [xingbie] = ? AND [xingzuo] = ? AND [nianling] = ? AND [dianhua] = ? AND [youxiang] = ? AND [aihao] = ? AND [liuyan] = ?"
117        InsertCommand="INSERT INTO [myliuyan] ( [xingming], [mima], [xingbie], [xingzuo], [nianling], [dianhua], [youxiang], [aihao], [liuyan]) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?)"
118        OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [编号], [xingming], [mima], [xingbie], [xingzuo], [nianling], [dianhua], [youxiang], [aihao], [liuyan] FROM [myliuyan]"
119        UpdateCommand="UPDATE [myliuyan] SET [xingming] = ?, [mima] = ?, [xingbie] = ?, [xingzuo] = ?, [nianling] = ?, [dianhua] = ?, [youxiang] = ?, [aihao] = ?, [liuyan] = ? WHERE [编号] = ? AND [xingming] = ? AND [mima] = ? AND [xingbie] = ? AND [xingzuo] = ? AND [nianling] = ? AND [dianhua] = ? AND [youxiang] = ? AND [aihao] = ? AND [liuyan] = ?">
120        <DeleteParameters>
121            <asp:Parameter Name="original_编号" Type="Int32" />
122            <asp:Parameter Name="original_xingming" Type="String" />
123            <asp:Parameter Name="original_mima" Type="String" />
124            <asp:Parameter Name="original_xingbie" Type="String" />
125            <asp:Parameter Name="original_xingzuo" Type="String" />
126            <asp:Parameter Name="original_nianling" Type="String" />
127            <asp:Parameter Name="original_dianhua" Type="String" />
128            <asp:Parameter Name="original_youxiang" Type="String" />
129            <asp:Parameter Name="original_aihao" Type="String" />
130            <asp:Parameter Name="original_liuyan" Type="String" />
131        </DeleteParameters>
132        <UpdateParameters>
133            <asp:Parameter Name="xingming" Type="String" />
134            <asp:Parameter Name="mima" Type="String" />
135            <asp:Parameter Name="xingbie" Type="String" />
136            <asp:Parameter Name="xingzuo" Type="String" />
137            <asp:Parameter Name="nianling" Type="String" />
138            <asp:Parameter Name="dianhua" Type="String" />
139            <asp:Parameter Name="youxiang" Type="String" />
140            <asp:Parameter Name="aihao" Type="String" />
141            <asp:Parameter Name="liuyan" Type="String" />
142            <asp:Parameter Name="original_编号" Type="Int32" />
143            <asp:Parameter Name="original_xingming" Type="String" />
144            <asp:Parameter Name="original_mima" Type="String" />
145            <asp:Parameter Name="original_xingbie" Type="String" />
146            <asp:Parameter Name="original_xingzuo" Type="String" />
147            <asp:Parameter Name="original_nianling" Type="String" />
148            <asp:Parameter Name="original_dianhua" Type="String" />
149            <asp:Parameter Name="original_youxiang" Type="String" />
150            <asp:Parameter Name="original_aihao" Type="String" />
151            <asp:Parameter Name="original_liuyan" Type="String" />
152        </UpdateParameters>
153        <InsertParameters>
154            <asp:Parameter Name="xingming" Type="String" />
155            <asp:Parameter Name="mima" Type="String" />
156            <asp:Parameter Name="xingbie" Type="String" />
157            <asp:Parameter Name="xingzuo" Type="String" />
158            <asp:Parameter Name="nianling" Type="String" />
159            <asp:Parameter Name="dianhua" Type="String" />
160            <asp:Parameter Name="youxiang" Type="String" />
161            <asp:Parameter Name="aihao" Type="String" />
162            <asp:Parameter Name="liuyan" Type="String" />
163        </InsertParameters>
164    </asp:AccessDataSource>
165   </div> 
166</asp:Content>
167
168