tablemark.aspx.cs

医院护理管理系统

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.OleDb;

public partial class tableMark : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
       
    }
    protected void btnBack_Click(object sender, EventArgs e)
    {
        Response.Redirect("AdminLogin.aspx");
    }
    protected void btnOk_Click(object sender, EventArgs e)
    {
        string strNurName = txtNurName.Text;
        string strDept = "";
        string strSql = "";
        string strSql1 = "";
        OleDbConnection connAcc = new OleDbConnection();
        string connStr = "Provider =Microsoft.Jet.OLEDB.4.0;Data Source = " + Server.MapPath("App_Data/Nurse.mdb");
        connAcc.ConnectionString = connStr;
       
        connAcc.Open();
        strSql = "select * from NurseInfo where NurName = '" + strNurName + "'";
        OleDbCommand Comm = new OleDbCommand(strSql, connAcc);
        OleDbDataReader dr = Comm.ExecuteReader();
        while (dr.Read())
        {
            NurDepartment.Text = dr["NurDepartment"].ToString();
        }
        lblDateTime.Text = System.DateTime.Now.ToString();
        connAcc.Close();

        connAcc.Open();
        strSql1 = "select StandDetailID ,StandDetail,BelongedItem,StandMark,NurName,RecordDate,Grade" +
                 " from StandDetail,Grade "+ "where Grade.NurName = '"
            + strNurName + "' and  StandDetail.StandDetailID = Grade.Detail;";
        OleDbCommand Comm1 = new OleDbCommand(strSql1, connAcc);
        OleDbDataAdapter da = new OleDbDataAdapter();
        da.SelectCommand = Comm1;
        DataSet ds = new DataSet();
        da.Fill(ds, "GradeView");
        GridView1.DataSource = ds.Tables["GradeView"].DefaultView;
        GridView1.DataBind();
       /* OleDbDataReader dr1 = Comm1.ExecuteReader();
        while (dr1.Read())
        {
            Response.Write(dr1["Detail"].ToString());
            Response.Write(dr1["Detail"].ToString());
        }
       */
        connAcc.Close();

    }
}