数据库编程

开发平台：

Visual C++

mentorList.aspx：源码内容

							﻿<%@ Page Language="C#"  MasterPageFile = "../MasterPage3.master" AutoEventWireup="true" CodeFile="mentorList.aspx.cs" Inherits="student_mentorList"  Title="导师查询"%>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
      <div style="margin-top:10px;width:380px; height:350px;"> 
            <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:Button ID="Button" runat="server"  Text="选择" OnClick="Button_Click"/>	  
		   </div>
		   <div style="background-image:url(../image/division.JPG);background-repeat:repeat-x; height:2px; width:380px;">
		   </div>
		   <div>
               <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                   AutoGenerateColumns="False" DataKeyNames="tea_id"  DataSourceID="SqlDataSource1" Width="377px" >
                   <Columns>
                     
                        <asp:HyperLinkfield  Text="选择"  Visible= "true"  SortExpression="tea_name"   DataNavigateUrlFields="tea_id" DataNavigateUrlFormatString = "mentorList.aspx?tea_Id={0}">
                       </asp:HyperLinkfield>
                       <asp:HyperLinkfield DataTextField="tea_name"  HeaderText="教师姓名" SortExpression="tea_name"  DataNavigateUrlFields="tea_id" DataNavigateUrlFormatString = "details.aspx?tea_Id={0}">
                       </asp:HyperLinkfield>
                       <asp:BoundField DataField="tea_toward" HeaderText="研究方向" SortExpression="tea_toward" />
                   </Columns>
                     <SelectedRowStyle BackColor="#FFE0C0"/> 
               </asp:GridView>
               <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ecnuprosysConnectionString %>"
                   SelectCommand="SELECT tea_id, tea_name, tea_toward FROM tea_table WHERE (tea_maxstu > tea_nowstu) GROUP BY tea_toward, tea_id, tea_name">
               </asp:SqlDataSource>
	      </div>
	   </div>  
</asp:Content>

						