st_course_student.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_course_student : 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 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();
    }
}