st_query.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_query : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        // 在此处放置用户代码以初始化页面


        string st_connstr = ConfigurationManager.AppSettings["st_dbconn"];
        SqlConnection st_conn = new SqlConnection(st_connstr);
        string st_sqlstr = "select * from ST_student where ST_Student_id=@id";
        SqlCommand st_comm = new SqlCommand(st_sqlstr, st_conn);
        st_comm.Parameters.Add(new SqlParameter("@id", SqlDbType.VarChar, 50));
        st_comm.Parameters["@id"].Value = Session["user_id"].ToString();
        st_conn.Open();
        SqlDataReader st_dr = st_comm.ExecuteReader();
        st_rp_information.DataSource = st_dr;
        st_rp_information.DataBind();
        st_conn.Close();
    }
}