st_teacher.aspx.cs

学生管理系统。C#开发。偏重与数据库的应用。

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 ST_teacher : System.Web.UI.Page
{
    SqlConnection st_conn;
    string st_sqlstr;
    protected void Page_Load(object sender,EventArgs e)
    {
        // 在此处放置用户代码以初始化页面
        string st_connstr = ConfigurationManager.AppSettings["st_dbconn"];
        st_conn = new SqlConnection(st_connstr);
        if (!IsPostBack)
            ST_BindGrid();
    }
    public void DataGrid_Page(object sender, DataGridPageChangedEventArgs e)
    {
        st_dtg_teacher.CurrentPageIndex = e.NewPageIndex;
        ST_BindGrid();
    }
    public void DataGrid_edit(object sender, DataGridCommandEventArgs e)
    {

        st_dtg_teacher.EditItemIndex = (int)e.Item.ItemIndex;
        ST_BindGrid();

    }
    public void DataGrid_cancel(object sender, DataGridCommandEventArgs e)
    {

        st_dtg_teacher.EditItemIndex = -1;
        ST_BindGrid();

    }
    public void DataGrid_delete(object sender, DataGridCommandEventArgs e)
    {

        string st_sqlstr = "delete from ST_teacher where ST_Teacher_id=@teacher_id";
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@teacher_id", SqlDbType.VarChar, 50));
        st_comm.Parameters["@teacher_id"].Value = st_dtg_teacher.DataKeys[(int)e.Item.ItemIndex];
        st_comm.Connection.Open();
        try
        {
            st_comm.ExecuteNonQuery();
            st_lbl_note.Text = "删除成功";

        }
        catch (SqlException)
        {
            st_lbl_note.Text = "删除失败";
            st_lbl_note.Style["color"] = "red";
        }
        st_comm.Connection.Close();
        ST_BindGrid();
    }
    public void DataGrid_update(object sender, DataGridCommandEventArgs e)
    {
        string st_sqlstr = "update ST_teacher set ST_Teacher_name=@teacher_name,ST_Teacher_college=@teacher_college where ST_Teacher_id=@teacher_id";
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@teacher_name", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@teacher_college", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@teacher_id", SqlDbType.VarChar, 50));
        string st_colvalue = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
        st_comm.Parameters["@teacher_name"].Value = st_colvalue;
        st_colvalue = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
        st_comm.Parameters["@teacher_college"].Value = st_colvalue;
        st_comm.Parameters["@teacher_id"].Value = st_dtg_teacher.DataKeys[(int)e.Item.ItemIndex];
        st_comm.Connection.Open();
        try
        {
            st_comm.ExecuteNonQuery();
            st_lbl_note.Text = "编辑成功";
            st_dtg_teacher.EditItemIndex = -1;
        }
        catch (SqlException)
        {
            st_lbl_note.Text = "编辑失败";
            st_lbl_note.Style["color"] = "red";
        }
        st_comm.Connection.Close();
        ST_BindGrid();

    }
    public void ST_BindGrid()
    {
        st_sqlstr = "select * from ST_teacher";
        SqlDataAdapter st_da = new SqlDataAdapter(st_sqlstr, st_conn);
        DataSet st_ds = new DataSet();
        st_da.Fill(st_ds);
        st_dtg_teacher.DataSource = st_ds;
        st_dtg_teacher.DataBind();
    }

    protected void st_btn_exit_Click(object sender, EventArgs e)
    {
        Response.Redirect("default.aspx");
    }
    protected void st_btn_search_Click(object sender, EventArgs e)
    {
        st_sqlstr = "select * from ST_teacher  where ST_Teacher_id='" + st_tbx_id.Text + "'or ST_Teacher_name='" + st_tbx_name.Text + "'";
        SqlDataAdapter st_da = new SqlDataAdapter(st_sqlstr, st_conn);
        DataSet st_ds = new DataSet();
        st_da.Fill(st_ds);
        st_dtg_teacher.DataSource = st_ds;
        st_dtg_teacher.DataBind();
    }
    public void DataGrid_sort(object sender, DataGridCommandEventArgs e)
    {

        string st_sqlstr = "insert into ST_users(ST_User_id,ST_User_password,ST_User_power) values(@userid,@userpwd,0)";
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@userid", SqlDbType.VarChar, 50));
        st_comm.Parameters["@user_id"].Value = st_dtg_teacher.DataKeys[(int)e.Item.ItemIndex];
        st_comm.Parameters.Add(new SqlParameter("@userpwd", SqlDbType.VarChar, 50));
        st_comm.Parameters["@userpwd"].Value = st_dtg_teacher.DataKeys[(int)e.Item.ItemIndex];
        st_comm.Connection.Open();
        try
        {
            st_comm.ExecuteNonQuery();
            Response.Redirect("ST_userlist.aspx");

        }
        catch (SqlException)
        {
            st_lbl_note.Text = "添加失败";
            st_lbl_note.Style["color"] = "red";
        }
        st_comm.Connection.Close();
    }
}