default2.aspx.cs

学生管理系统 功能不是很强大 但是很实用

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
//该源码下载自www.51aspx.com(５１sｓpｘ．ｃｏｍ)

public partial class Default2 : System.Web.UI.Page
{
    string student;
    protected void Page_Load(object sender, EventArgs e)
    {
        student = this.Session["name"].ToString();
        string myConnstr = "data source=localhost;database=学生成绩智能管理系统;user id=sa;password=sa;";
        SqlConnection myConn = new SqlConnection(myConnstr);
        string sql = "select 学号,姓名,性别,院系,出生日期,家庭住址,入学时间,政治面貌,备注 from 学生表 where 学号= '"+student+"'";
        SqlCommand myComm = new SqlCommand(sql, myConn);
        myConn.Open();
        SqlDataReader myDataReader = myComm.ExecuteReader();
        if(myDataReader.Read())
        {
            TextBox1.Text = myDataReader.GetValue(0).ToString();
            DataBind();
            TextBox2.Text = myDataReader.GetValue(1).ToString();
            DataBind();
            TextBox3.Text = myDataReader.GetValue(2).ToString();
            DataBind();
            TextBox4.Text = myDataReader.GetValue(3).ToString();
            DataBind();
            TextBox5.Text = myDataReader.GetValue(4).ToString();
            DataBind();
            TextBox6.Text = myDataReader.GetValue(5).ToString();
            DataBind();
            TextBox7.Text = myDataReader.GetValue(6).ToString();
            DataBind();
            TextBox8.Text = myDataReader.GetValue(7).ToString();
            DataBind();
            TextBox9.Text = myDataReader.GetValue(8).ToString();
            DataBind();
        }
        myConn.Close();
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        this.Response.Redirect("登陆页面.aspx");
    }
}