数据库大作业

Bind(); }

private void Bind() {

SqlConnection con = new

SqlConnection(ConfigurationManager.ConnectionStrings[\\

string sql = \部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department]\

SqlDataAdapter sda = new SqlDataAdapter(sql, con); DataSet ds = new DataSet(); sda.Fill(ds, \ con.Close();

ListDepart.DataSource = ds.Tables[\ ListDepart.DataBind(); }

protected void ListDepart_PageIndexChanging(object sender, GridViewPageEventArgs e) {

ListDepart.PageIndex = e.NewPageIndex; DataBind(); } }

4、Search_Depart（查询部门信息） using System; using System.Data;

using System.Configuration; using System.Collections;

- 23 -

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_Search_Depart : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void brn_search_Click(object sender, EventArgs e) {

if (role.SelectedValue == \部门编号\ {

if (TxtContent.Text.Trim() == \ {

Response.Write(\部门编号不能为空!')\ } else {

string sql = \部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department] where [D_ID]='\ user Search = new user();

SqlDataReader myreader = Search.Login(sql); List_employee.DataSource = myreader;

- 24 -

List_employee.DataBind(); } }

else if (role.SelectedValue == \部门名称\ {

if (TxtContent.Text.Trim() == \ {

Response.Write(\部门名称不能为空!')\ } else {

string sql = \部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department] where [D_Name]='\ user Search = new user();

SqlDataReader myreader = Search.Login(sql); List_employee.DataSource = myreader; List_employee.DataBind(); } } else {

if (TxtContent.Text.Trim() == \ {

Response.Write(\负责人不能为空!')\ } else {

- 25 -

string sql = \部门编号,D_Name 部门名称,D_Tel 联系电话,D_Address 联系地址,D_Chief 负责人,D_Belong 所属部门 from [Tb_department] where [D_Chief]='\+ TxtContent.Text.Trim() + \ user Search = new user();

SqlDataReader myreader = Search.Login(sql); List_employee.DataSource = myreader; List_employee.DataBind(); } } } }

4.2系统测试

1.添加部门信息界面

图4.2.1添加部门信息

2.部门信息查询（按部门编号）界面

- 26 -