当前文件： AthletesFile/matchrecord.aspx[16K，2009-6-12 11:32:51]，打开代码结构图

		            
  1<%...@ Page Language="C#" MasterPageFile="~/mainMaster.master" AutoEventWireup="true" CodeFile="matchrecord.aspx.cs" Inherits="xxx" Title="比赛的记录情况" %>
  2<asp:Content ID="Content1" ContentPlaceHolderID="CPH" Runat="Server">
  3    <br />
  4    <br />
  5    <asp:Panel ID="Panel1" runat="server" Font-Size="Large" Height="93px" Style="z-index: 100;
  6        left: 216px; position: absolute; top: 295px" Width="588px">
  7        &nbsp;
  8        <asp:Label ID="Label1" runat="server" BackColor="White" BorderColor="Transparent"
  9            Font-Size="XX-Large" Height="25px" Style="z-index: 100; left: 119px; position: absolute;
 10            top: 14px" Text="运动员比赛记录登记表" Width="331px"></asp:Label>
 11        &nbsp;
 12        <asp:LinkButton ID="LinkButton2" runat="server" OnClick="LinkButton2_Click" Style="z-index: 101;
 13            left: 417px; position: absolute; top: 63px">修改记录</asp:LinkButton>
 14        <asp:LinkButton ID="LinkButton3" runat="server" OnClick="LinkButton3_Click" Style="z-index: 102;
 15            left: 91px; position: absolute; top: 61px">插入记录</asp:LinkButton>
 16        &nbsp;
 17        <asp:LinkButton ID="LinkButton4" runat="server" OnClick="LinkButton4_Click" Style="z-index: 103;
 18            left: 251px; position: absolute; top: 63px">查找记录</asp:LinkButton>
 19        &nbsp; &nbsp;&nbsp;
 20    </asp:Panel>
 21    &nbsp;&nbsp;&nbsp;<br />
 22    <br />
 23    <br />
 24    &nbsp;
 25    <asp:Panel ID="Panel3" runat="server" Height="443px" Style="z-index: 101; left: 235px;
 26        position: absolute; top: 399px" Width="517px" Visible="False">
 27        <asp:Label ID="Label9" runat="server" Style="z-index: 100; left: 30px; position: absolute;
 28            top: 345px" Text="备注"></asp:Label>
 29        <br />
 30        <asp:Label ID="Label18" runat="server" Font-Size="Large" Height="29px" Style="font-size: 23pt;
 31            z-index: 101; left: 162px; color: #0000ff; font-family: 华文行楷; position: absolute;
 32            top: 11px; text-decoration: underline" Text="新建运动员记录" Width="236px"></asp:Label>
 33        &nbsp;&nbsp;
 34        <asp:TextBox ID="TextBox11" runat="server" Style="z-index: 102; left: 152px; position: absolute;
 35            top: 264px"></asp:TextBox>
 36        <asp:Label ID="Label10" runat="server" Style="z-index: 103; left: 30px; position: absolute;
 37            top: 191px" Text="性别　"></asp:Label>
 38        <asp:TextBox ID="TextBox13" runat="server" Style="z-index: 104; left: 90px; position: absolute;
 39            top: 347px" TextMode="MultiLine"></asp:TextBox>
 40        &nbsp;
 41        <asp:TextBox ID="TextBox9" runat="server" Style="z-index: 105; left: 152px; position: absolute;
 42            top: 224px"></asp:TextBox>
 43        &nbsp;
 44        <asp:Label ID="Label13" runat="server" Style="z-index: 106; left: 30px; position: absolute;
 45            top: 266px" Text="参加比赛项目"></asp:Label>
 46        <asp:Label ID="Label12" runat="server" Style="z-index: 107; left: 30px; position: absolute;
 47            top: 305px" Text="是否获得奖项"></asp:Label>
 48        &nbsp;
 49        <asp:Label ID="Label11" runat="server" Style="z-index: 108; left: 30px; position: absolute;
 50            top: 229px" Text="时间"></asp:Label>
 51        &nbsp;
 52        <asp:Label ID="Label15" runat="server" Style="z-index: 109; left: 30px; position: absolute;
 53            top: 116px" Text="编号"></asp:Label>
 54        &nbsp;
 55        <asp:TextBox ID="TextBox14" runat="server" Style="z-index: 110; left: 152px; position: absolute;
 56            top: 77px"></asp:TextBox>
 57        <asp:TextBox ID="TextBox16" runat="server" Style="z-index: 111; left: 152px; position: absolute;
 58            top: 114px"></asp:TextBox>
 59        <asp:TextBox ID="TextBox15" runat="server" Style="z-index: 112; left: 152px; position: absolute;
 60            top: 150px"></asp:TextBox>
 61        <asp:Label ID="Label14" runat="server" Style="z-index: 113; left: 30px; position: absolute;
 62            top: 150px" Text="姓名"></asp:Label>
 63        <asp:Label ID="Label16" runat="server" Style="z-index: 114; left: 30px; position: absolute;
 64            top: 79px" Text="记录号码"></asp:Label>
 65        &nbsp;
 66        <asp:Button ID="Button4" runat="server" Style="z-index: 115; left: 320px; position: absolute;
 67            top: 404px" Text="取消" Width="56px" OnClick="Button4_Click" />
 68        &nbsp; &nbsp;
 69        <asp:RadioButtonList ID="RadioButtonList2" runat="server" RepeatDirection="Horizontal"
 70            Style="z-index: 116; left: 159px; position: absolute; top: 305px">
 71            <asp:ListItem Selected="True">True</asp:ListItem>
 72            <asp:ListItem>false</asp:ListItem>
 73        </asp:RadioButtonList>
 74        <asp:RadioButtonList ID="RadioButtonList1" runat="server" RepeatDirection="Horizontal"
 75            Style="z-index: 117; left: 155px; position: absolute; top: 187px">
 76            <asp:ListItem Selected="True">男</asp:ListItem>
 77            <asp:ListItem>女</asp:ListItem>
 78        </asp:RadioButtonList>
 79        <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox14"
 80            Display="Dynamic" ErrorMessage="必须要填写" Style="z-index: 118; left: 322px; position: absolute;
 81            top: 76px"></asp:RequiredFieldValidator>
 82        &nbsp;
 83        <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="TextBox16"
 84            Display="Dynamic" ErrorMessage="必须要填写" Style="z-index: 119; left: 323px; position: absolute;
 85            top: 116px"></asp:RequiredFieldValidator>
 86        <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="TextBox15"
 87            Display="Dynamic" ErrorMessage="必须要填写" Style="z-index: 120; left: 324px; position: absolute;
 88            top: 154px"></asp:RequiredFieldValidator>
 89        &nbsp;
 90        <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Style="z-index: 128;
 91            left: 100px; position: absolute; top: 408px" Text="插入" Width="51px" />
 92        &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
 93    </asp:Panel>
 94    &nbsp; &nbsp;&nbsp; &nbsp;<br />
 95    <br />
 96    <br />
 97    <br />
 98    <br />
 99    <br />
100    <br />
101    <br />
102    <br />
103    <br />
104    <br />
105    <br />
106    <br />
107    <br />
108    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:LocalSqlServer %>"
109        InsertCommand="INSERT INTO Jilu(Sp_num, Sp_nums, Sp_name, Sp_sex, Sp_time, Sp_project, Sp_award, Sp_remarks) VALUES (@Sp_num, @Sp_nums, @Sp_name, @Sp_sex, @Sp_time, @Sp_project, @Sp_award, @Sp_remarks)" SelectCommand="SELECT * FROM [Jilu]"
110        >
111        <InsertParameters>
112            <asp:ControlParameter ControlID="TextBox14" Name="Sp_num" PropertyName="Text" />
113            <asp:ControlParameter ControlID="TextBox16" Name="Sp_nums" PropertyName="Text" />
114            <asp:ControlParameter ControlID="TextBox15" Name="Sp_name" PropertyName="Text" />
115            <asp:ControlParameter ControlID="RadioButtonList1" Name="Sp_sex" PropertyName="SelectedValue" />
116            <asp:ControlParameter ControlID="TextBox9" Name="Sp_time" PropertyName="Text" />
117            <asp:ControlParameter ControlID="TextBox11" Name="Sp_project" PropertyName="Text" />
118            <asp:ControlParameter ControlID="RadioButtonList2" Name="Sp_award" PropertyName="SelectedValue" />
119            <asp:ControlParameter ControlID="TextBox13" Name="Sp_remarks" PropertyName="Text" />
120        </InsertParameters>
121    </asp:SqlDataSource>
122    <br />
123    <br />
124    &nbsp;<br />
125    <br />
126    <asp:Panel ID="Panel4" runat="server" Height="253px" Style="z-index: 100; left: 311px;
127        position: absolute; top: 411px" Width="418px" Visible="False">
128        <asp:Label ID="Label5" runat="server" Style="z-index: 100; left: 31px; position: absolute;
129            top: 73px" Text="编号"></asp:Label>
130        &nbsp;&nbsp;
131        <asp:Label ID="Label6" runat="server" Style="z-index: 101; left: 32px; position: absolute;
132            top: 140px" Text="姓名"></asp:Label>
133        &nbsp;
134        <asp:TextBox ID="TextBox3" runat="server" Style="z-index: 102; left: 92px; position: absolute;
135            top: 140px"></asp:TextBox>
136        <asp:TextBox ID="TextBox4" runat="server" Style="z-index: 103; left: 93px; position: absolute;
137            top: 73px"></asp:TextBox>
138        <asp:Label ID="Label7" runat="server" Style="font-size: 23pt; z-index: 104; left: 108px;
139            color: blue; font-family: 华文行楷; position: absolute; top: 17px; text-decoration: underline"
140            Text="查找比赛记录" Width="190px"></asp:Label>
141        &nbsp; &nbsp; &nbsp;
142        <asp:Button ID="Button5" runat="server" OnClick="Button1_Click" Style="z-index: 105;
143            left: 65px; position: absolute; top: 182px" Text="查找" />
144        <asp:Button ID="Button6" runat="server" Style="z-index: 106; left: 261px; position: absolute;
145            top: 181px" Text="取消" OnClick="Button6_Click" />
146        <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ErrorMessage="必须填写"
147            Style="z-index: 109; left: 255px; position: absolute; top: 76px" ControlToValidate="TextBox4"></asp:RequiredFieldValidator>
148        <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ErrorMessage="必须填写"
149            Style="z-index: 108; left: 251px; position: absolute; top: 138px" ControlToValidate="TextBox3"></asp:RequiredFieldValidator>
150    </asp:Panel>
151    <br />
152    &nbsp;
153    <asp:Panel ID="Panel2" runat="server" BackColor="White" Height="640px" Style="z-index: 100;
154        left: 289px; position: absolute; top: 399px" Width="434px" Visible="False">
155        <asp:Label ID="Label2" runat="server" Height="19px" Style="font-size: 23pt; z-index: 100;
156            left: 108px; color: blue; font-family: 华文行楷; position: absolute; top: 21px; text-decoration: underline"
157            Text="修改记录登记" Width="195px"></asp:Label>
158        <asp:Label ID="Label3" runat="server" Style="z-index: 101; left: 39px; position: absolute;
159            top: 251px" Text="姓名"></asp:Label>
160        <asp:Label ID="Label4" runat="server" Style="z-index: 102; left: 39px; position: absolute;
161            top: 204px" Text="编号"></asp:Label>
162        &nbsp;
163        <asp:TextBox ID="TextBox2" runat="server" Style="z-index: 103; left: 142px; position: absolute;
164            top: 209px"></asp:TextBox>
165        <asp:TextBox ID="TextBox1" runat="server" Style="z-index: 104; left: 141px; position: absolute;
166            top: 248px"></asp:TextBox>
167        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click1" Style="z-index: 105;
168            left: 92px; position: absolute; top: 570px" Text="确定" />
169        <asp:Button ID="Button2" runat="server" Style="z-index: 106; left: 290px; position: absolute;
170            top: 569px" Text="取消" OnClick="Button2_Click" />
171        &nbsp;&nbsp;
172        <asp:Label ID="Label8" runat="server" Style="z-index: 107; left: 41px; position: absolute;
173            top: 489px" Text="备注"></asp:Label>
174        <asp:Label ID="Label17" runat="server" Style="z-index: 108; left: 39px; position: absolute;
175            top: 432px" Text="是否获奖"></asp:Label>
176        <asp:Label ID="Label19" runat="server" Style="z-index: 109; left: 39px; position: absolute;
177            top: 383px" Text="参加比赛项目"></asp:Label>
178        <asp:Label ID="Label20" runat="server" Style="z-index: 110; left: 39px; position: absolute;
179            top: 334px" Text="参加比赛时间"></asp:Label>
180        <asp:Label ID="Label21" runat="server" Style="z-index: 111; left: 39px; position: absolute;
181            top: 290px" Text="性别"></asp:Label>
182        <asp:Label ID="Label22" runat="server" Style="z-index: 112; left: 39px; position: absolute;
183            top: 169px" Text="记录编号"></asp:Label>
184        <asp:RadioButtonList ID="RadioButtonList3" runat="server" RepeatDirection="Horizontal"
185            Style="z-index: 113; left: 148px; position: absolute; top: 288px">
186            <asp:ListItem Selected="True">男</asp:ListItem>
187            <asp:ListItem>女</asp:ListItem>
188        </asp:RadioButtonList>
189        <asp:TextBox ID="TextBox5" runat="server" Style="z-index: 114; left: 161px; position: absolute;
190            top: 385px"></asp:TextBox>
191        <asp:TextBox ID="TextBox6" runat="server" Style="z-index: 115; left: 160px; position: absolute;
192            top: 330px"></asp:TextBox>
193        <asp:RadioButtonList ID="RadioButtonList4" runat="server" RepeatDirection="Horizontal"
194            Style="z-index: 116; left: 135px; position: absolute; top: 435px">
195            <asp:ListItem Selected="True">True</asp:ListItem>
196            <asp:ListItem>False</asp:ListItem>
197        </asp:RadioButtonList>
198        <asp:TextBox ID="TextBox7" runat="server" Style="z-index: 117; left: 112px; position: absolute;
199            top: 488px" TextMode="MultiLine"></asp:TextBox>
200        <asp:TextBox ID="TextBox8" runat="server" Style="z-index: 118; left: 141px; position: absolute;
201            top: 167px"></asp:TextBox>
202        &nbsp;
203        <asp:Label ID="Label24" runat="server" Style="z-index: 120; left: 13px; position: absolute;
204            top: 89px" Text="要修改运动员编号"></asp:Label>
205        &nbsp; &nbsp;
206        <asp:TextBox ID="TextBox10" runat="server" Style="z-index: 122; left: 169px; position: absolute;
207            top: 90px"></asp:TextBox>
208        <asp:Button ID="Button7" runat="server" OnClick="Button7_Click" Style="z-index: 124;
209            left: 371px; position: absolute; top: 91px" Text="查找" />
210    </asp:Panel>
211    <br />
212    <br />
213    <br />
214    <br />
215    <br />
216    <asp:GridView ID="GridView1" runat="server" Style="z-index: 103; left: 263px; position: absolute;
217        top: 690px" Visible="False" Width="169px" DataSourceID="SqlDataSource4" AutoGenerateColumns="False" Height="1px">
218        <Columns>
219            <asp:BoundField DataField="Sp_num" HeaderText="Sp_num" SortExpression="Sp_num" />
220            <asp:BoundField DataField="Sp_nums" HeaderText="Sp_nums" SortExpression="Sp_nums" />
221            <asp:BoundField DataField="Sp_name" HeaderText="Sp_name" SortExpression="Sp_name" />
222            <asp:BoundField DataField="Sp_sex" HeaderText="Sp_sex" SortExpression="Sp_sex" />
223            <asp:BoundField DataField="Sp_time" HeaderText="Sp_time" SortExpression="Sp_time" />
224            <asp:BoundField DataField="Sp_project" HeaderText="Sp_project" SortExpression="Sp_project" />
225            <asp:CheckBoxField DataField="Sp_award" HeaderText="Sp_award" SortExpression="Sp_award" />
226            <asp:BoundField DataField="Sp_remarks" HeaderText="Sp_remarks" SortExpression="Sp_remarks" />
227        </Columns>
228    </asp:GridView>
229    <asp:SqlDataSource ID="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:LocalSqlServer %>"
230        SelectCommand="SELECT DISTINCT Sp_num, Sp_nums, Sp_name, Sp_sex, Sp_time, Sp_project, Sp_award, Sp_remarks FROM Jilu WHERE (Sp_num = @Sp_num) AND (Sp_name = @Sp_name)">
231        <SelectParameters>
232            <asp:ControlParameter ControlID="TextBox4" DefaultValue="1101" Name="Sp_num" PropertyName="Text"
233                Type="String" />
234            <asp:ControlParameter ControlID="TextBox3" DefaultValue="李利" Name="Sp_name" PropertyName="Text"
235                Type="String" />
236        </SelectParameters>
237    </asp:SqlDataSource>
238    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:LocalSqlServer %>"
239        SelectCommand="SELECT * FROM [Jilu]" UpdateCommand="UPDATE Jilu SET Sp_num = @Sp_num, Sp_nums = @Sp_nums, Sp_name = @Sp_name, Sp_sex = @Sp_sex, Sp_time = @Sp_time, Sp_project = @Sp_project, Sp_award = @Sp_award, Sp_remarks = @Sp_remarks where Sp_num=@Sp_num">
240        <UpdateParameters>
241            <asp:ControlParameter ControlID="TextBox10" Name="Sp_num" PropertyName="Text" />
242            <asp:ControlParameter ControlID="TextBox2" Name="Sp_nums" PropertyName="Text" />
243            <asp:ControlParameter ControlID="TextBox1" Name="Sp_name" PropertyName="Text" />
244            <asp:ControlParameter ControlID="RadioButtonList3" Name="Sp_sex" PropertyName="SelectedValue" />
245            <asp:ControlParameter ControlID="TextBox6" Name="Sp_time" PropertyName="Text" />
246            <asp:ControlParameter ControlID="TextBox5" Name="Sp_project" PropertyName="Text" />
247            <asp:ControlParameter ControlID="TextBox4" Name="Sp_award" PropertyName="Text" />
248            <asp:ControlParameter ControlID="TextBox7" Name="Sp_remarks" PropertyName="Text" />
249        </UpdateParameters>
250    </asp:SqlDataSource>
251    <br />
252    <br />
253    <br />
254    <br />
255</asp:Content>
256
257