st_classes.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_Classes : 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();
    }
    protected void st_btn_exit_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default.aspx");
    }
    public void DataGrid_Page(object sender, DataGridPageChangedEventArgs e)
    {
        st_dtg_class.CurrentPageIndex = e.NewPageIndex;
        ST_BindGrid();
    }
    public void DataGrid_edit(object sender, DataGridCommandEventArgs e)
    {
        st_dtg_class.EditItemIndex = (int)e.Item.ItemIndex;
        ST_BindGrid();
    }
    public void DataGrid_cancel(object sender, DataGridCommandEventArgs e)
    {
        st_dtg_class.EditItemIndex = -1;
        ST_BindGrid();
    }
    public void DataGrid_delete(object sender, DataGridCommandEventArgs e)
    {
        string st_sqlstr = "delete from ST_class where ST_Class_id=@class_id";
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@class_id", SqlDbType.VarChar, 50));
        st_comm.Parameters["@class_id"].Value = st_dtg_class.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_class set ST_Class_name=@Class_name,ST_Class_department=@Class_department,ST_Class_college=@Class_college,ST_Class_teacherid=@Class_teacherid where ST_Class_id=@Class_id";
        //创建更新命令
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@Class_name", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@Class_department", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@Class_college", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@Class_teacherid", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@Class_id", SqlDbType.VarChar, 50));
        string st_st_colvalue = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
        st_comm.Parameters["@Class_name"].Value = st_st_colvalue;
        st_st_colvalue = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
        st_comm.Parameters["@Class_department"].Value = st_st_colvalue;
        st_st_colvalue = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
        st_comm.Parameters["@Class_college"].Value = st_st_colvalue;
        st_st_colvalue = ((TextBox)e.Item.Cells[4].Controls[0]).Text;
        st_comm.Parameters["@Class_teacherid"].Value = st_st_colvalue;
        st_comm.Parameters["@Class_id"].Value = st_dtg_class.DataKeys[(int)e.Item.ItemIndex];
        st_comm.Connection.Open();
        try
        {
            st_comm.ExecuteNonQuery();
            st_lbl_note.Text = "编辑成功";
            st_dtg_class.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_class";
        SqlDataAdapter st_st_da = new SqlDataAdapter(st_sqlstr, st_conn);
        DataSet st_ds = new DataSet();
        st_st_da.Fill(st_ds);
        st_dtg_class.DataSource = st_ds;
        st_dtg_class.DataBind();
    }

    protected void st_btn_search_Click(object sender, System.EventArgs e)
    {
        st_sqlstr = "select * from ST_class  where ST_Class_id='" + st_tbx_id.Text + "'or ST_Class_name='" + st_tbx_name.Text + "'";
        SqlDataAdapter st_st_da = new SqlDataAdapter(st_sqlstr, st_conn);
        DataSet st_ds = new DataSet();
        st_st_da.Fill(st_ds);
        st_dtg_class.DataSource = st_ds;
        st_dtg_class.DataBind();
    }

}