17 else
{Response.Redirect(\}}
protected void Delete_Click(object sender, EventArgs e) {if ((string)Session[\{ if ((string)Session[\¹ÜÀíÔ±\{string id = (string)Session[\
string sql = \string connstr =
ConfigurationManager.ConnectionStrings[\String;
SqlConnection Sqlconn = new SqlConnection(connstr); Sqlconn.Open();
SqlCommand sc = new SqlCommand(sql, Sqlconn); sc.ExecuteNonQuery(); Sqlconn.Close();
Response.Redirect(\} else
{Response.Write(\Ö»ÓйÜÀíÔ±²Å¿ÉÒÔ½øÐд˲Ù×÷')\
}} else
{Response.Redirect(\3.3.3 ²¿ÃÅÐÅÏ¢Áбí
²¿ÃÅÐÅÏ¢ÁбíÖ÷ÒªÊÇ»ã×ÜÏÔʾËùÓв¿ÃŵÄÐÅÏ¢£¬ÕâÀïÖ÷ÒªÓõ½µÄ¼¼ÊõÊý¾Ý¿âµÄ°ó¶¨¸úµ¼Èë¡£ÒªÕýÈ·µÄ°ó¶¨Êý¾Ý±íTb_departmentÈ»ºóµ¼Èëÿһ¸ö²¿ÃŵÄÐÅÏ¢£¬¸ù¾Ý¸÷×ֶεÄ˳ÐòÒ»´ÎÏÔʾ:²¿ÃűàºÅ×÷ΪÖ÷¼üÏÔʾÔÚǰ£¬È»ºóÒÀ´ÎÏÔʾ²¿ÃÅÃû³Æ¡¢ÁªÏµµç»°¡¢ÁªÏµµØÖ·¡¢¸ºÔðÈË¡¢ºÍËùÊô²¿ÃÅ¡£Õâ¸ö˳ÐòÊǸúǰÁ½¸öµ¥ÔªÌí¼Ó²¿ÃÅÐÅÏ¢ºÍÃÅÏêϸÐÅÏ¢µÄÊý¾Ý±í½øÐйØÏµ´¦ÀíµÄ£¬Ã¿¸öµ¥Ôª¶¼ÊÇͬ²½´¦ÀíÒ»¸öÊý¾Ý¿â±íµÄ¡£ÔÚÕâ¸öµ¥ÔªÄ£¿éÉÏ£¬Ò»°ãÓû§ºÍ¹ÜÀíÔ±Ö®¼äµÄȨÏÞÊÇÒ»ÑùµÄ£¬¶¼ÊDz鿴²¿ÃÅÐÅÏ¢µÄÁÐ±í¡£µã»÷µÚÒ»Ïî¿ÉÒÔÏÔʾ²¿ÃŵÄÏêϸÐÅÏ¢¡£²¿ÃÅÐÅÏ¢ÁбíµÄ½çÃæÉè¼ÆÈçͼËùʾ:
ͼ3-5 ²¿ÃÅÐÅÏ¢ÁбíÉè¼ÆÍ¼ ²¿ÃÅÐÅÏ¢ÁÐ±í¹¦ÄÜʵÏÖ´úÂë:
public partial class WebFiles_Department_List_Depart : System.Web.UI.Page
{protected void Page_Load(object sender, EventArgs e) {if(!IsPostBack) Bind(); 18 }
private void Bind() {SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings[\n\
string sql = \²¿ÃűàºÅ,D_Name ²¿ÃÅÃû³Æ,D_Tel ÁªÏµµç»°,D_Address ÁªÏµµØÖ·,D_Chief ¸ºÔðÈË,D_Belong ËùÊô²¿ÃÅrom [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(); },
3.3.4 ²¿ÃÅÐÅÏ¢ËÑË÷
ÔÚÕâÒ»¸öµ¥ÔªÄ£¿éÖÐÖ»ÒªÊäÈë·ûºÏϵͳµÄËÑË÷Ìõ¼þ£¬²¿ÃÅÐÅÏ¢ËÑË÷Õâһģ¿éÊÇÏòËùÓеÄÓû§¿ª·ÅµÄ¡£²¿ÃÅÐÅÏ¢ËÑË÷ÊǸù¾Ý²¿ÃÅÖ÷Òª¹Ø¼ü×ֶμìË÷(²¿ÃűàºÅ¡¢²¿ÃÅÃû³Æ¡¢¸ºÔðÈË)£¬È»ºóÌø³öÓû§ÏëÒªËÑË÷µÄ²¿ÃÅ£¬²¿ÃÅÐÅÏ¢Ö÷ÒªÉè¼Æ·½·¨¾ÍÊÇÊ×ÏȸúÊý¾Ý±íTb_department²¢µ¼È룬ȻºóÔÚ֮ǰÉè¼Æ²¼¾Ö±í¸ñ¹¤¾ßµÄ»ù´¡Ö®ÉÏÌí¼ÓÒ»¸ö DropDownList¿Ø¼þ£¬È»ºóÌí¼ÓÒ»¸ö²éѯ°´Å¥µÄʼþ¡£¸Ãľ¿éÖ÷ÒªÊǸúÊý¾Ý±íTb_department°ó¶¨Á¬½ÓµÄ¡£²¿ÃÅÐÅÏ¢ËÑË÷Ä£¿éµÄÔËÐÐЧ¹ûÈçͼËùʾ:
ͼ3-6 ²¿ÃÅÐÅÏ¢ËÑË÷½çÃæ ²¿ÃÅÐÅÏ¢ËÑË÷¹¦ÄÜʵÏֵĴúÂë:
public partial class WebFiles_Department_Search_Depart : System.Web.UI.Page
{ protected void brn_search_Click(object sender, EventArgs e) {if (role.SelectedValue == \²¿ÃűàºÅ\{if (TxtContent.Text.Trim() == \
{Response.Write(\²¿ÃűàºÅ²»ÄÜΪ¿Õ!')\} else 19
{string sql = \²¿ÃűàºÅ,D_Name²¿ÃÅÃû³Æ,D_TelÁªÏµµç»° ,D_AddressÁªÏµµØ
Ö·,D_Chief¸ºÔðÈË,D_BelongËùÊô²¿ÃÅ from [Tb_department] where [D_ID]='\
TxtContent.Text.Trim() + %user Search = new user();
SqlDataReader myreader = Search.Login(sql); List_employee.DataSource = myreader; List_employee.DataBind(); }}
else if (role.SelectedValue == \²¿ÃÅÃû³Æ\