一个类似百度的搜索。。。。。

 protected void ImageButton1_Click(object sender, ImageClickEventArgs e)//搜索
    {
        Panel1.Visible = false;

        DateTime t = DateTime.Now;
        double d = 0;
        int n=0;
        string[] ss = new string[] {"oname","tel","address","pay","omoney","number","otime","remark"};
        string condition = TextBox1.Text.Trim();
        if (condition == "")
            return;

        DataTable dtb = new DataTable();

        for (int i = 0; i < ss.Length; i++)
        {
            if (ss[i] == "otime" && DateTime.TryParse(condition,out t) == false)//如果查到时间时，如果时间不合法就跳出循环
                continue;
            if (ss[i] == "pay" && double.TryParse(condition, out d) == false)
                continue;
            if (ss[i] == "omoney" && double.TryParse(condition, out d) == false)
                continue;
            if (ss[i] == "number" && int.TryParse(condition, out n) == false)
                continue;

            cmdstr = "select * from [order],product where [order].pid=product.pid and "+ss[i]+=@0;
            dt = new DataSet();
            h = new sqlhelp(cmdstr, database, out adapter, condition);
            adapter.Fill(dt);
            if (dt.Tables[0].Rows.Count != 0)//如果有数据就不进行下一步操作
            {
                dtb.Merge(dt.Tables[0]);
            }
        }
     
        DataList1.DataSource = dtb;
        DataList1.DataKeyField = "oid";
        DataList1.DataBind();

       
       
    }