数据库编程

开发平台：
Visual C++

index.aspx：源码内容
							﻿<%@ Page Language="C#"  MasterPageFile = "../MasterPage4.master" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="teacher_index"  Title="老师首页"%>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
    <div style="margin-top:20px;height:380px;">
        <div style="float:left;width:270px;">
           <div style="margin-top:10px;background-image:url(../image/25707_0906160458331.jpg);width:270px;height:233px; float:left;">   
           </div>
           <div style="margin-top:20px;height:150px; ">
	         <img src="../image/huashixw.gif" longdesc="../image/huashixw.gif" id="IMG1"/>
		     <li class="STYLE6"><a href="http://www.xgb.ecnu.edu.cn/system/xsglgd_list.asp" target="_blank">规章制度</a></li><li class="STYLE6"><a href="http://www.xgb.ecnu.edu.cn/system/zxtz_list.asp" target="_blank">通知公告</a></li><li class="STYLE6"><a href="http://www.xgb.ecnu.edu.cn/system/jzgl_list.asp" target="_blank">奖助信息</a></li><li class="STYLE6"><a href="http://www.xgb.ecnu.edu.cn/system/bszn_list.asp" target="_blank">办事指南</a></li></div>  
        </div>
        <div style="float:left;width:300px; margin-left:25px;">
           <div style="float:left;">
              <img src="../image/biaoti_xiushi.gif" width="21" height="21" longdesc="../image/biaoti_xiushi.gif" />
           </div>
		   <div style="float:left;">
			  <span class="STYLE4">学生查询</span>			  
		   </div>
		   <div style="float:right;">
              <asp:RadioButton ID="RadioButton1" runat="server" /> 
              <asp:Label ID="Label1" runat="server" Text="选择" Font-Size="XX-Small" Font-Bold="true"></asp:Label>
              <asp:RadioButton ID="RadioButton2" runat="server" /> 
              <asp:Label ID="Label2" runat="server" Text="拒绝" Font-Size="XX-Small" Font-Bold="true"  ForeColor="red" ></asp:Label>
              <asp:Button ID="Button1" runat="server" Text="提交" OnClick="Button1_Click" />
		   </div>
		   <div style="background-image:url(../image/division.JPG);background-repeat:repeat-x; height:2px; width:400px;">
		   </div>
		   <div>
		       <span class="STYLE6">
                   <asp:GridView ID="GridView2" runat="server" DataSourceID="SqlDataSource2" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" Width="398px" >
                   
               <Columns>
                    <asp:TemplateField>
                           <ItemTemplate>
                               <asp:CheckBox ID="CheckBox1" runat="server" Checked="false" />
                           </ItemTemplate>
                     </asp:TemplateField>
                   <asp:HyperLinkField DataNavigateUrlFields="stu_id" DataNavigateUrlFormatString="details.aspx?stu_Id={0}" DataTextField="stu_name" />
                  
       
                   <asp:BoundField DataField="state" HeaderText="状态" SortExpression="state">
                       
                   </asp:BoundField>
               </Columns>
                   </asp:GridView>
                   <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ecnuprosysConnectionString %>" SelectCommand="SELECT stu_id_num.stu_id, stu_id_num.stu_name, stu_tea.state FROM stu_id_num INNER JOIN stu_tea ON stu_id_num.stu_id = stu_tea.sut_id and stu_tea.state= '未选择'"></asp:SqlDataSource>
               </span>
          </div>  
	   </div>   
	   <div style="float:left;width:180px; height:180px;margin-left:25px;margin-top:10px;">
		    <img src="../image/shangcaigk.gif" longdesc="../image/shangcaigk.gif" />&nbsp;<br />
           <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" DataKeyNames="stu_id" AllowPaging="True" AllowSorting="True">
               <Columns>
                   <asp:HyperLinkField DataNavigateUrlFields="stu_id" DataNavigateUrlFormatString="thesises.aspx?stu_Id={0}" DataTextField="stu_name"/>
               </Columns>
           </asp:GridView>
           <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ecnuprosysConnectionString %>"
               SelectCommand="select stu_id_num.stu_id,stu_id_num.stu_name from stu_id_num,stu_tea where stu_id_num.stu_id = stu_tea.sut_id  ">
           </asp:SqlDataSource>
       </div>
	   <div style="float:right; width:180px; height:180px;margin-top:10px;">
	        <img src="../image/gonggongfw.gif" longdesc="../image/gonggongfw.gif" /><br />
           &nbsp;
           <asp:GridView ID="GridView3" runat="server" Height="141px" Width="193px" AutoGenerateColumns="False" DataKeyNames="stu_id" DataSourceID="SqlDataSource3">
                <Columns>
                    <%--<asp:BoundField DataField="stu_id" HeaderText="stu_id" ReadOnly="True" SortExpression="stu_id" />
                    <asp:BoundField DataField="arg_time" HeaderText="arg_time" SortExpression="arg_time" />
                    <asp:BoundField DataField="arg_place" HeaderText="arg_place" SortExpression="arg_place" />
                    <asp:BoundField DataField="arg_tea_id" HeaderText="arg_tea_id" SortExpression="arg_tea_id" />
                    <asp:BoundField DataField="exam_id" HeaderText="exam_id" ReadOnly="True" SortExpression="exam_id" />
                    <asp:BoundField DataField="stu_id1" HeaderText="stu_id1" SortExpression="stu_id1" />
                    <asp:BoundField DataField="stu_name" HeaderText="stu_name" SortExpression="stu_name" />
                    <asp:BoundField DataField="stu_score" HeaderText="stu_score" SortExpression="stu_score" />
                    <asp:BoundField DataField="avg_point" HeaderText="avg_point" SortExpression="avg_point" />--%>
                    <asp:HyperLinkField HeaderText="学生姓名" DataNavigateUrlFields="stu_id" DataNavigateUrlFormatString="arrangement.aspx?stu_Id={0}" DataTextField="stu_name" />
                    <asp:BoundField DataField="arg_time" HeaderText="答辩时间" SortExpression="arg_time" />
                    <asp:BoundField DataField="arg_place" HeaderText="答辩地点" SortExpression="arg_place" />
                </Columns>
           </asp:GridView>
           <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:ecnuprosysConnectionString %>"
               SelectCommand="select * from rep_to_arg,stu_id_num where (stu_id_num.stu_id = rep_to_arg.stu_id)">
           </asp:SqlDataSource>
           &nbsp;
       </div> 
    </div>  
</asp:Content>

						