GridView 和 ViewState 来实现条件查寻

最新推荐文章于 2016-05-30 12:59:12 发布

转载最新推荐文章于 2016-05-30 12:59:12 发布 · 156 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/MySpace/archive/2009/11/10/1599742.html

文章标签：

#c# #ui #数据库

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            bind();
        }
    }
    string sql = "select * from Tree";
   public void  bind()
    {
        //Response.Write(ViewState["text"].ToString());
        if(ViewState["text"]==null||ViewState["text"].ToString()=="")
        {
            sql = "select * from Tree";
        }
        else
        {
            sql += " where "+this.DropDownList1.SelectedValue+" like'%"+ViewState["text"].ToString()+"%'";
        }
        this.GridView1.DataSource=Query(sql);
        this.GridView1.DataBind();
    }
    public DataTable Query(string sql)
    {
        SqlConnection sqlcon = new SqlConnection("server=LUOBO-77FC1CCCD\\FRANK;database=TreeDB;uid=sa;pwd=sasa;");
        SqlDataAdapter sqladap=new SqlDataAdapter (sql,sqlcon);
        //SqlDataReader sqlreader=new SqlDataReader();
        DataSet ds=new DataSet ();
        sqladap.Fill(ds);
        return ds.Tables[0];
    }


    protected void  GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        this.GridView1.EditIndex=e.NewEditIndex;
        bind();
    }
    protected void GridView1_RowCancelingEdit(object sender,GridViewCancelEditEventArgs e)
    {
        this.GridView1.EditIndex =-1;
        bind();
    }
    //条件查询：
    protected void Button1_Click(object sender,EventArgs e)
    {
        //if(this.TextBox1.Text.Trim() != "")
        //{
            ViewState["text"] = this.TextBox1.Text.Trim();
        //}
        bind();
    }
}

转载于:https://www.cnblogs.com/MySpace/archive/2009/11/10/1599742.html