protected void btnSearch_Click(object sender, EventArgs e) { string Key = "'%" + this.txtKey.Text + "%'"; string where = "bookTitle like" + Key + "or ISBN like" + Key + "or auther like" + Key; DataTable dt = Bbook.GetList(where).Tables[0]; GridView1.DataSource = dt; GridView1.DataBind(); }
public void rpBind() { //设置购物车内容的数据源 dtTable = new DataTable(); DataColumn column2 = new DataColumn("ISBN"); //商品ID代号 DataColumn column3 = new DataColumn("bookTitle"); //商品名称 DataColumn column4 = new DataColumn("Num"); //数量 DataColumn column5 = new DataColumn("price"); //单价 DataColumn column6 = new DataColumn("totalPrice"); //总价 DataColumn column7 = new DataColumn("bookState"); //状态 dtTable.Columns.Add(column2); dtTable.Columns.Add(column3); dtTable.Columns.Add(column4); dtTable.Columns.Add(column5); dtTable.Columns.Add(column6); dtTable.Columns.Add(column7); string str = "'" + Session["OrderID"].ToString() + "'"; DataTable dsTableo = ordersh.GetList("orderNo=" + str).Tables[0]; DataTable dsTables = sale.GetList("orderNo=" + str).Tables[0]; DataTable dsTableb; foreach (DataRow Rrow in dsTables.Rows) { DataRow row = dtTable.NewRow(); row["ISBN"] = Rrow["ISBN"]; dsTableb = book.GetList("ISBN=" + "'" + Rrow["ISBN"].ToString() + "'").Tables[0]; row["bookTitle"] = dsTableb.Rows[0]["bookTitle"]; row["Num"] = Rrow["quantity"]; row["price"] = dsTableb.Rows[0]["salePrice"]; row["totalPrice"] = (int.Parse(row["Num"].ToString()) * float.Parse(row["price"].ToString())).ToString(); row["bookState"] = Rrow["bookState"]; dtTable.Rows.Add(row); } this.rptOrderItems.DataSource = dtTable.DefaultView; this.rptOrderItems.DataBind(); }