1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Data.SqlClient;
  6using System.Configuration;
  7using System.Drawing;
  8using System.Web;
  9using System.Web.SessionState;
 10using System.Web.UI;
 11using System.Web.UI.WebControls;
 12using System.Web.UI.HtmlControls;
 13
 14namespace STGROUP
 15...{
 16    /**//// <summary>
 17    /// _class 的摘要说明。
 18    /// </summary>
 19    public class ST_classes : System.Web.UI.Page
 20    ...{
 21        SqlConnection st_conn;
 22        protected System.Web.UI.WebControls.TextBox st_tbx_name;
 23        protected System.Web.UI.WebControls.TextBox st_tbx_id;
 24        protected System.Web.UI.WebControls.Button st_btn_search;
 25        protected System.Web.UI.WebControls.DataGrid st_dtg_class;
 26        protected System.Web.UI.WebControls.Label st_lbl_note;
 27        protected System.Web.UI.WebControls.Button st_btn_exit;
 28        string st_sqlstr;
 29        private void Page_Load(object sender, System.EventArgs e)
 30        ...{
 31            // 在此处放置用户代码以初始化页面
 32            string st_connstr= ConfigurationSettings.AppSettings["st_dbconn"];
 33            st_conn=new SqlConnection(st_connstr);    
 34            if(!IsPostBack) 
 35                ST_BindGrid();
 36        }
 37
 38        Web Form Designer generated code#region Web Form Designer generated code
 39        override protected void OnInit(EventArgs e)
 40        ...{
 41            //
 42            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
 43            //
 44            InitializeComponent();
 45            base.OnInit(e);
 46        }
 47        
 48        /**//// <summary>
 49        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 50        /// 此方法的内容。
 51        /// </summary>
 52        private void InitializeComponent()
 53        ...{    
 54            this.st_btn_search.Click += new System.EventHandler(this.st_btn_search_Click);
 55            this.st_btn_exit.Click += new System.EventHandler(this.st_btn_exit_Click);
 56            this.Load += new System.EventHandler(this.Page_Load);
 57
 58        }
 59        #endregion
 60
 61        private void st_btn_exit_Click(object sender, System.EventArgs e)
 62        ...{
 63            Response.Redirect("default.aspx");
 64        }
 65        public void DataGrid_Page(object sender,DataGridPageChangedEventArgs e)
 66        ...{
 67            st_dtg_class.CurrentPageIndex=e.NewPageIndex;
 68            ST_BindGrid();
 69        }
 70        public void DataGrid_edit(object sender,DataGridCommandEventArgs e)
 71        ...{        
 72            st_dtg_class.EditItemIndex=(int)e.Item.ItemIndex;
 73            ST_BindGrid();    
 74        }
 75        public void DataGrid_cancel(object sender,DataGridCommandEventArgs e)
 76        ...{            
 77            st_dtg_class.EditItemIndex=-1;
 78            ST_BindGrid();    
 79        }
 80        public void DataGrid_delete(object sender,DataGridCommandEventArgs e)
 81        ...{        
 82            string st_sqlstr="delete from ST_class where ST_Class_id=@class_id";
 83            SqlCommand st_comm=new SqlCommand(st_sqlstr,st_conn);
 84            st_comm.Parameters.Add(new SqlParameter("@class_id",SqlDbType.VarChar,50));
 85            st_comm.Parameters["@class_id"].Value=st_dtg_class.DataKeys[(int)e.Item.ItemIndex];
 86            st_comm.Connection.Open();
 87            try
 88            ...{
 89                st_comm.ExecuteNonQuery();
 90                st_lbl_note.Text="删除成功";
 91                
 92            }
 93            catch(SqlException)
 94            ...{
 95                st_lbl_note.Text="删除失败";
 96                st_lbl_note.Style["color"]="red";
 97            }
 98            st_comm.Connection.Close();            
 99            ST_BindGrid();
100        }
101        public void DataGrid_update(object sender,DataGridCommandEventArgs e)
102        ...{
103            //数据库更新字符串
104            string st_sqlstr="update ST_class set ST_Class_name=@Class_name,ST_Class_department=@Class_department,ST_Class_college=@Class_college,ST_Class_teacherid=@Class_teacherid where ST_Class_id=@Class_id";
105            //创建更新命令
106            SqlCommand st_comm=new SqlCommand(st_sqlstr,st_conn);
107            st_comm.Parameters.Add(new SqlParameter("@Class_name",SqlDbType.VarChar,50));
108            st_comm.Parameters.Add(new SqlParameter("@Class_department",SqlDbType.VarChar,50));
109            st_comm.Parameters.Add(new SqlParameter("@Class_college",SqlDbType.VarChar,50));
110            st_comm.Parameters.Add(new SqlParameter("@Class_teacherid",SqlDbType.VarChar,50));
111            st_comm.Parameters.Add(new SqlParameter("@Class_id",SqlDbType.VarChar,50));
112            string st_st_colvalue=((TextBox)e.Item.Cells[1].Controls[0]).Text;
113            st_comm.Parameters["@Class_name"].Value=st_st_colvalue;
114            st_st_colvalue=((TextBox)e.Item.Cells[2].Controls[0]).Text;
115            st_comm.Parameters["@Class_department"].Value=st_st_colvalue;
116            st_st_colvalue=((TextBox)e.Item.Cells[3].Controls[0]).Text;
117            st_comm.Parameters["@Class_college"].Value=st_st_colvalue;
118            st_st_colvalue=((TextBox)e.Item.Cells[4].Controls[0]).Text;
119            st_comm.Parameters["@Class_teacherid"].Value=st_st_colvalue;
120            st_comm.Parameters["@Class_id"].Value=st_dtg_class.DataKeys[(int)e.Item.ItemIndex];
121            st_comm.Connection.Open();
122            try
123            ...{
124                st_comm.ExecuteNonQuery();
125                st_lbl_note.Text="编辑成功";
126                st_dtg_class.EditItemIndex=-1;
127            }
128            catch(SqlException)
129            ...{
130                st_lbl_note.Text="编辑失败";
131                st_lbl_note.Style["color"]="red";
132            }
133            st_comm.Connection.Close();        
134            ST_BindGrid();
135            
136        }
137        public void ST_BindGrid()
138        ...{
139            st_sqlstr="select * from ST_class";
140            SqlDataAdapter st_st_da=new SqlDataAdapter(st_sqlstr,st_conn);
141            DataSet st_ds=new DataSet();
142            st_st_da.Fill(st_ds);
143            st_dtg_class.DataSource=st_ds;
144            st_dtg_class.DataBind();
145        }
146
147        private void st_btn_search_Click(object sender, System.EventArgs e)
148        ...{
149            st_sqlstr="select * from ST_class  where ST_Class_id='"+st_tbx_id.Text+"'or ST_Class_name='"+st_tbx_name.Text+"'";
150            SqlDataAdapter st_st_da=new SqlDataAdapter(st_sqlstr,st_conn);
151            DataSet st_ds=new DataSet();
152            st_st_da.Fill(st_ds);
153            st_dtg_class.DataSource=st_ds;
154            st_dtg_class.DataBind();
155        }
156
157
158    }
159}
160