protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { string str = Request.QueryString["str"]; searchContent.InnerText = str; var data = new DB().GetDataTable("select * from Device where DeviceName like '%" + str + "%' or type1 like '%" + str + "%' or type2 like '%" + str + "%' or type3 like '%" + str + "%' or brand like '%" + str + "%' or tag like '%" + str + "%'"); if (data.Rows.Count < 1) { resultDIv.InnerText = "对不起,暂时没有相关产品!"; return; } Repeater0.DataSource = data; Repeater0.DataBind(); } }
void SetData() { Repeater0.DataSource = new DB().GetDataTable("Select type1 From device group by type1 order by min(ID)"); Repeater0.DataBind(); }