rentsearch.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class rentsearch : System.Web.UI.Page
{

    SqlConnection conn = DB.getcon();
    protected void Page_Load(object sender, EventArgs e)
    {
        this.kefang();

    }
    public void kefang()
    {
        SqlConnection con = DB.getcon();
        DataSet ds = new DataSet();
        SqlDataAdapter sda = new SqlDataAdapter("select   * from house where lx='二手房出售' and sp='1' and (" + " zj like '" + Request.QueryString["k"] + "%'" + "or dj like '" + Request.QueryString["k"] + "%'" + "or xq like '" + Request.QueryString["k"] + "%'" + "or fx like '" + Request.QueryString["k"] + "%'" + "or mj like '" + Request.QueryString["k"] + "%'" + "or lc like '" + Request.QueryString["k"] + "%'" + "or nd like '" + Request.QueryString["k"] + "%'" + "or cx like '" + Request.QueryString["k"] + "%'" + " )", con);
        sda.Fill(ds, "mclass");
        this.XRepeater.DataSource = ds.Tables["mclass"].DefaultView;
        this.XRepeater.DataBind();
        this.pageInfo.InnerHtml = pageNum.GetPageNumRe(ds, XRepeater, 10);
    }
}