数据库大作业

using System.Web.UI.HtmlControls; using System.Data.SqlClient;

public partial class WebFiles_Department_View_Depart : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

if (!IsPostBack) {

string id = Request[\ string name = Request[\ Session[\ Session[\ Bond(); } }

private void Bond() {

string id = (string)Session[\

string sql = \+ \

string connstr =

ConfigurationManager.ConnectionStrings[\tring;

SqlConnection Sqlconn = new SqlConnection(connstr); Sqlconn.Open();

SqlCommand sc = new SqlCommand(sql, Sqlconn); SqlDataReader myreader = sc.ExecuteReader(); if (myreader.Read()) {

TxtID.Text = myreader[0].ToString();

- 19 -

TxtName.Text = myreader[1].ToString(); TxtTel.Text = myreader[2].ToString(); TxtAddress.Text = myreader[3].ToString(); TxtChief.Text = myreader[4].ToString(); TxtBelong.Text = myreader[5].ToString(); Sqlconn.Close(); } }

protected void Edit_Click(object sender, EventArgs e) {

if ((string)Session[\ {

if ((string)Session[\管理员\ {

string sql = \ +TxtName.Text.Trim()+\ +TxtTel.Text.Trim()+\ +TxtAddress.Text.Trim()+\ +TxtChief.Text.Trim()+\ +TxtBelong.Text.Trim()+\ +TxtID.Text.Trim()+\ string connstr =

ConfigurationManager.ConnectionStrings[\tring;

SqlConnection Sqlconn = new SqlConnection(connstr); Sqlconn.Open();

SqlCommand sc = new SqlCommand(sql, Sqlconn); sc.ExecuteNonQuery();

lbMessage.Text = \您已成功更新1条记录!\ Sqlconn.Close(); }

- 20 -

else {

Response.Write(\只有管理员才可以进行此操作!')\ } } else {

Response.Redirect(\ } }

protected void Delete_Click(object sender, EventArgs e) {

if ((string)Session[\ {

if ((string)Session[\管理员\ {

string id = (string)Session[\

string sql = \from [Tb_department] where D_ID='\+ id + \

string connstr =

ConfigurationManager.ConnectionStrings[\tring;

SqlConnection Sqlconn = new SqlConnection(connstr); Sqlconn.Open();

SqlCommand sc = new SqlCommand(sql, Sqlconn); sc.ExecuteNonQuery(); Sqlconn.Close();

Response.Redirect(\ }

- 21 -

else {

Response.Write(\只有管理员才可以进行此操作!')\ } } else {

Response.Redirect(\ } } }

3、List_Depart（列举部门信息） 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 WebFiles_Department_List_Depart : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

if(!IsPostBack)

- 22 -