admin.aspx.cs

asp.net 学生信息管理系统！可以作为课程设计来使用

using System;
using System.Data;
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;
using System.Data.SqlClient;

public partial class teacher_admin : System.Web.UI.Page
{
    Datacon dataconn = new Datacon();
    protected void Page_Load(object sender, EventArgs e)
    {
       /*
        if (Session["UserID"] == null)
         {
             Response.Write("<script language=javascript>alert('请先登录');location='Default.aspx'</script>");
         }
       
        if (Session["power"] != "1")
        {
            Response.Write("<script language=javascript>alert('你的权限不够');location='Default.aspx'</script>");
        }
       */

        if (!IsPostBack)
        {
            dataconn.ecadabindinfostring(gvAdminInfo, "select * from users ORDER BY user_id", "user_id");
        }


    }
    protected void LinkButton10_Click(object sender, EventArgs e)
    {
        Response.Write("<script>window.open('UserInsert.aspx','','width=800,height=600')</script>");
        Response.Write("<script>location='javascript:history.go(-1)'</script>");

    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvAdminInfo.PageIndex = e.NewPageIndex;
        dataconn.ecadabind(gvAdminInfo, "Select * From users Where "
                + ddlAdminName.SelectedValue + "  Like  '%" + txtSelect.Text + "%'");
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        dataconn.eccom("delete from users where User_id='" + gvAdminInfo.DataKeys[e.RowIndex].Value + "'");
        Page.Response.Redirect("teacher/admin.aspx");
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        if (txtSelect.Text == "")
        {
            dataconn.ecadabindinfostring(gvAdminInfo, "select * from users ORDER BY user_id ", "user_id");
        }
        else
        {
            dataconn.ecadabind(gvAdminInfo, "Select * From users Where "
                + ddlAdminName.SelectedValue + "  Like  '%" + txtSelect.Text + "%'");
        }
    }

    protected void gvAdminInfo_RowEditing(object sender, GridViewEditEventArgs e)
    {
        SqlConnection strcon = dataconn.getcon();
        strcon.Open();
        SqlDataAdapter sda = new SqlDataAdapter("select * from users order by User_id", strcon);
        DataSet ds = new DataSet();
        sda.Fill(ds, "users");
        gvAdminInfo.DataSource = ds.Tables["users"];
        gvAdminInfo.DataKeyNames = new string[] { "user_id" };
        gvAdminInfo.DataBind();
        string user_id = gvAdminInfo.DataKeys[e.NewEditIndex].Value.ToString();
        Response.Write("<script>window.open('admin_update.aspx?User_id=" + user_id + "','','width=800,height=600')</script>");
        Response.Write("<script>location='javascript:history.go(-1)'</script>");
    }
}