查询页面 (Search)

private void Page_Load(object sender, System.EventArgs e)

         {

              // 在此处放置用户代码以初始化页面

              if(!Page.IsPostBack)

              {

              showAll();

              }

         }

 

         #region Web 窗体设计器生成的代码

         override protected void OnInit(EventArgs e)

         {

              //

              // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。

              //

              InitializeComponent();

              base.OnInit(e);

         }

        

         /// <summary>

         /// 设计器支持所需的方法 - 不要使用代码编辑器修改

         /// 此方法的内容。

         /// </summary>

         private void InitializeComponent()

         {   

              this.Button1.Click += new System.EventHandler(this.Button1_Click);

              this.Load += new System.EventHandler(this.Page_Load);

 

         }

         #endregion

 

         private void Button1_Click(object sender, System.EventArgs e)

         {

        

              string keyw = this.txtKey.Text.Trim();

             

 

              //关键字不空执行搜索

              if(keyw !="")

              {

                   SqlConnection conn = new SqlConnection();

                  

                   conn.ConnectionString =

                       "Data Source=(local);user id=sa;password=;initial catalog=zc";

                  

                   //按姓名搜索

                   SqlCommand cmd = new SqlCommand();

                   cmd.CommandText =

                       "Select ID, UserName,Userjg from user_info where UserName like '%"+ keyw +"%'";

                                  

                   cmd.Connection = conn;

 

                   //打开连接,执行操作,返回阅读器

                   conn.Open();

                   SqlDataReader reader = cmd.ExecuteReader();

 

                   //绑定数据

                   this.myGrid.DataSource = reader;

                   this.myGrid.DataBind();

 

                   reader.Close();

                   conn.Close();

              }

              else

              {

                   showAll();

              }

         }

 

         void showAll()

         {

              SqlConnection conn = new SqlConnection();

              conn.ConnectionString =

                   "Data Source=(local);user id=sa;password=;initial catalog=zc";

             

              SqlCommand cmd = new SqlCommand();

              cmd.CommandText =

                   "Select ID,UserName,Userjg from user_info";

              //按姓名搜索

             

              cmd.Connection = conn;

 

              //打开连接,执行操作,返回阅读器

              conn.Open();

              SqlDataReader reader = cmd.ExecuteReader();

 

              //绑定数据

              this.myGrid.DataSource = reader;

              this.myGrid.DataBind();

 

              reader.Close();

              conn.Close();

         }