数据库编程

开发平台：
Visual C++

index.aspx：源码内容
							﻿<%@ Page Language="C#"  MasterPageFile = "../MasterPage5.master" AutoEventWireup="true" CodeFile="index.aspx.cs" Inherits="administration_index"  Title="老师首页"%>
<%@ Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
    Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>
    
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<div style="margin-top:20px;height:350px;">
    <div style="width:250px;float:left;">
        <div style="margin-top:20px; margin-left:30px;float:left;">
           <img src="../image/huashixw.gif" longdesc="../image/huashixw.gif" id="IMG1"/><br />
            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                AutoGenerateColumns="False" DataKeyNames="sut_id" DataSourceID="SqlDataSource1" Width="247px" Height="283px">
                <Columns>
                    <asp:TemplateField>
                           <ItemTemplate>
                               <asp:CheckBox ID="CheckBox1" runat="server" Checked="false" />
                           </ItemTemplate>
                       </asp:TemplateField>
                    <asp:BoundField DataField="sut_id" HeaderText="学号" ReadOnly="True" SortExpression="sut_id" />
                    <asp:HyperLinkField HeaderText="学生姓名"　DataNavigateUrlFields="sut_id" DataNavigateUrlFormatString="stu_details.aspx?stu_Id={0}" DataTextField="stu_name" SortExpression="stu_name"/>
                     <asp:HyperLinkField HeaderText="导师姓名"　DataNavigateUrlFields="tea_id" DataNavigateUrlFormatString="tea_details.aspx?tea_Id={0}" DataTextField="tea_name" SortExpression="tea_name"/>
                 
                    <asp:BoundField DataField="state" HeaderText="状态" SortExpression="state" />
                </Columns>
            </asp:GridView>
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ecnuprosysConnectionString %>"
                SelectCommand="select stu_tea.sut_id,stu_id_num.stu_name,tea_table.tea_name,stu_tea.state,stu_tea.tea_id from stu_tea,stu_id_num,tea_table&#13;&#10;where stu_tea.sut_id = stu_id_num.stu_id and&#13;&#10;stu_tea.tea_id = tea_table.tea_id&#13;&#10;group by stu_tea.state,tea_table.tea_name,stu_tea.sut_id,stu_id_num.stu_name,stu_tea.tea_id">
            </asp:SqlDataSource>
       </div>
    </div>
    <div style="float:left;width:250px;margin-left:40px;height:350px;">
       <div style="height:250px;">
       <div style=" margin-left:250px;">
          <asp:Button ID="Button1" runat="server" Text="发邮件" OnClick="Button1_Click"/>
       </div>
        <img src="../image/huashixw.gif" longdesc="../image/huashixw.gif" id="IMG3"/><br />
        学生导师选择统计&nbsp;<br />
         <img src="../image/graph1.gif" longdesc="../image/graph1.gif" id="IMG4"/><br />
       
       </div>
   
     
    </div>
 </div>
</asp:Content>

						