st_course.aspx.cs

来自「学生管理系统。C#开发。偏重与数据库的应用。」· CS 代码 · 共 122 行

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_course : 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_course.CurrentPageIndex = e.NewPageIndex;
        ST_BindGrid();
    }
    public void DataGrid_edit(object sender, DataGridCommandEventArgs e)
    {

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

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

        st_dtg_course.EditItemIndex = -1;
        ST_BindGrid();

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

        string st_sqlstr = "delete from ST_course where ST_Course_id=@course_id";
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@course_id", SqlDbType.VarChar, 50));
        st_comm.Parameters["@course_id"].Value = st_dtg_course.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_course set ST_Course_name=@Course_name,ST_Course_period=@Course_period,ST_Course_credit=@Course_credit,ST_Course_kind=@Course_kind where ST_Course_id=@Course_id";
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@Course_name", SqlDbType.VarChar, 50));
        st_comm.Parameters.Add(new SqlParameter("@Course_period", SqlDbType.Int, 4));
        st_comm.Parameters.Add(new SqlParameter("@Course_credit", SqlDbType.Int, 4));
        st_comm.Parameters.Add(new SqlParameter("@Course_kind", SqlDbType.Int, 4));
        st_comm.Parameters.Add(new SqlParameter("@Course_id", SqlDbType.VarChar, 50));
        string st_colvalue = ((TextBox)e.Item.Cells[1].Controls[0]).Text;
        st_comm.Parameters["@Course_name"].Value = st_colvalue;
        st_colvalue = ((TextBox)e.Item.Cells[2].Controls[0]).Text;
        st_comm.Parameters["@Course_period"].Value = st_colvalue;
        st_colvalue = ((TextBox)e.Item.Cells[3].Controls[0]).Text;
        st_comm.Parameters["@Course_credit"].Value = st_colvalue;
        st_colvalue = ((DropDownList)e.Item.FindControl("st_ddl_coursekind")).SelectedIndex.ToString();
        st_comm.Parameters["@Course_kind"].Value = st_colvalue;
        st_comm.Parameters["@Course_id"].Value = st_dtg_course.DataKeys[(int)e.Item.ItemIndex];
        st_comm.Connection.Open();
        try
        {
            st_comm.ExecuteNonQuery();
            st_lbl_note.Text = "编辑成功";
            st_dtg_course.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_course";
        SqlDataAdapter st_da = new SqlDataAdapter(st_sqlstr, st_conn);
        DataSet st_ds = new DataSet();
        st_da.Fill(st_ds);
        st_dtg_course.DataSource = st_ds;
        st_dtg_course.DataBind();
    }
    protected void st_btn_search_Click(object sender, EventArgs e)
    {
        st_sqlstr = "select * from ST_course  where ST_Course_id='" + st_tbx_id.Text + "'or ST_Course_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_course.DataSource = st_ds;
        st_dtg_course.DataBind();
    }
    protected void st_btn_exit_Click(object sender, EventArgs e)
    {
        Response.Redirect("default.aspx");
    }
}