private void BindProductRepeater() { SqlConnection con = new SqlConnection(ConnectString); con.Open(); if (Request.QueryString["ürün"] != null) { string data = Request.QueryString["ürün"].ToString(); SqlDataAdapter sda = new SqlDataAdapter("select * from Table_Product where (ProductName like '%" + data + "%')or (id like '%" + data + "%')", con); DataTable dt = new DataTable(); sda.Fill(dt); RepeaterProducts.DataSource = dt; RepeaterProducts.DataBind(); con.Close(); //SqlCommand cmd = new SqlCommand("select * from Table_Product P where P.ProductName=@id", con); //cmd.Parameters.AddWithValue("@id", data); //cmd.ExecuteNonQuery(); //DataTable dt = new DataTable(); //SqlDataAdapter sda = new SqlDataAdapter(cmd); //sda.Fill(dt); RepeaterProducts.DataSource = dt; RepeaterProducts.DataBind(); } else { Response.Redirect("~/Products.aspx"); } }
private void BindProductRepeater() { SqlConnection con = new SqlConnection(ConnectString); con.Open(); if (Request.QueryString["category"] != null) { int id = Convert.ToInt32(Request.QueryString["category"]); SqlCommand cmd = new SqlCommand("select * from Table_Product P inner join Tbl_Category C on C.CategoryId=P.Category inner join Tbl_Brands B on B.BrandId=P.Brand where C.CategoryId=@id", con); cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); RepeaterProducts.DataSource = dt; RepeaterProducts.DataBind(); } else if (Request.QueryString["BrandId"] != null) { int id = Convert.ToInt32(Request.QueryString["BrandId"]); SqlCommand cmd = new SqlCommand("select * from Table_Product P inner join Tbl_Brands B on B.BrandId=P.Brand where B.BrandId=@id", con); cmd.Parameters.AddWithValue("@id", id); cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); RepeaterProducts.DataSource = dt; RepeaterProducts.DataBind(); } else if (Request.QueryString["ürün"] != null) { string data = Request.QueryString["ürün"].ToString(); SqlCommand cmd = new SqlCommand("select * from Table_Product where (ProductName like '% @data %')or (id like '%@data%')", con); cmd.Parameters.AddWithValue("@data", data); // SqlDataAdapter sda = new SqlDataAdapter("select * from Table_Product where (ProductName like '%" + data + "%')or (id like '%" + data + "%')", con); DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); RepeaterProducts.DataSource = dt; RepeaterProducts.DataBind(); con.Close(); RepeaterProducts.DataSource = dt; RepeaterProducts.DataBind(); } else { SqlCommand cmd = new SqlCommand("select P.id, P.ProductName, P.ProductDescription,P.ProductImages,P.ProductPrice, C.CategoryName,B.Name from Table_Product P inner Join Tbl_Category C on C.CategoryId=P.Category inner join Tbl_Brands B on B.BrandId=P.Brand ", con); cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlDataAdapter sda = new SqlDataAdapter(cmd); sda.Fill(dt); RepeaterProducts.DataSource = dt; RepeaterProducts.DataBind(); con.Close(); } }
private void LoadProducts() { String id_category = Request.QueryString["id"].ToString(); int converId = Int16.Parse(id_category); if (converId < 4) { RepeaterProducts.DataSource = DB.getProductsByCategories(converId); RepeaterProducts.DataBind(); } else { Response.Redirect("Contact.aspx"); } }
//do dữ liệu //phantrang private void NapDuLieu(int currPage, int recodperpage, int Pagesize) { DataSet ds = DB.StoreToDataSet(currPage, recodperpage, Pagesize); DataTable dtbData = ds.Tables[0]; DataTable dtbPhanTrang = ds.Tables[1]; if (dtbData.Rows.Count > 0) { RepeaterProducts.DataSource = dtbData; RepeaterProducts.DataBind(); if (dtbPhanTrang.Rows.Count > 0) { ltlPhanTrang.Text = dtbPhanTrang.Rows[0]["PhanTrang"] + ""; } } }
private void LoadProducts() { String id_category = Request.QueryString["id"].ToString(); int converId = Int16.Parse(id_category); if (DB.getProductsByProducer(converId).Rows.Count > 0) { lblTitle.Visible = false; RepeaterProducts.DataSource = DB.getProductsByProducer(converId); RepeaterProducts.DataBind(); } else { lblTitle.Visible = true; lblTitle.Text = "Sản phẩm đã hết hàng."; } }
protected void ddl_sort_TextChanged(object sender, EventArgs e) { if (ddl_sort.Text == "Nome") { var list = Products.OrderBy(p => p.ProductName); RepeaterProducts.DataSource = list.ToList(); RepeaterProducts.DataBind(); } else if (ddl_sort.Text == "Preço Ascendente") { var list = Products.OrderBy(p => p.Price); RepeaterProducts.DataSource = list.ToList(); RepeaterProducts.DataBind(); } else if (ddl_sort.Text == "Preço Descendente") { var list = Products.OrderByDescending(p => p.Price); RepeaterProducts.DataSource = list.ToList(); RepeaterProducts.DataBind(); } }
private void LoadProducts() { RepeaterProducts.DataSource = DB.getLidtProduct(); RepeaterProducts.DataBind(); }
private void LoadAllProducts() { RepeaterProducts.DataSource = _productManager.GetAllProducts(); RepeaterProducts.DataBind(); }
void RepeaterProducts_Yukle() { RepeaterProducts.DataSource = repoProduct.GetAll().Select(s => new { s.ID, s.Name, s.Picture, s.Description, s.Price, s.Stock, Brand = s.Brand.Name }).OrderByDescending(o => o.ID).ToList(); RepeaterProducts.DataBind(); }
private void BindigRepeaterProducts(string product) { /*string query = " select Product.productId, Product.productName,Product.price, Product.description,Product.quantity," + * "Category.description from Product inner join Category on Category.categoryId = Product.categoryId " + * "order by Product.productName";*/ Products = new List <Product>(); SqlConnection myConn = new SqlConnection(ConfigurationManager.ConnectionStrings["OnShopCenterConnectionString"].ConnectionString); SqlCommand mycommand = new SqlCommand { CommandType = CommandType.StoredProcedure, CommandText = "GetProduct", Connection = myConn }; myConn.Open(); var reader = mycommand.ExecuteReader(); while (reader.Read()) { string base64 = string.Empty; if (reader[6] != null && reader[6].ToString().Length > 1) { base64 = Convert.ToBase64String((byte[])reader[6]); } string path; if (string.IsNullOrEmpty(base64)) { path = "../Config/images/no-image.png"; } else { path = $"data:image/jpeg;base64,{base64}"; } Products.Add(new Product { ProductId = reader.GetInt32(0), ProductName = reader.GetString(1), Price = reader.GetSqlMoney(2), Description = reader.GetString(3), Category = reader.GetString(5), ImagePath = path }); } reader.Close(); myConn.Close(); var list = Products.Where(p => p.ProductName.ToLower().Contains(product)); RepeaterProducts.DataSource = list.ToList(); RepeaterProducts.DataBind(); }