/// <summary> /// Update the gridview when the /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SupplierDDL_SelectedIndexChanged(object sender, EventArgs e) { if (SupplierDDL.SelectedIndex <= 0) { return; } List <List <string> > results = NorthwindAccess.GetProducts(SupplierDDL.SelectedValue); if (results.Count <= 0) { return; } TableHeaderRow header = new TableHeaderRow(); results[0].ForEach(x => header.Cells.Add(new TableHeaderCell() { Text = x })); ProductT.Rows.Add(header); foreach (List <string> item in results.Skip(1)) { TableRow row = new TableRow(); item.ForEach(x => row.Cells.Add(new TableCell() { Text = x })); ProductT.Rows.Add(row); } }
protected void _DDL_Comapnies_Index(object sender, EventArgs e) { if (_DDL_Comapnies.SelectedIndex < 1) { return; } Table1.Rows.Clear(); List <List <string> > Data = NorthwindAccess.GetProducts(_DDL_Comapnies.SelectedValue); TableHeaderRow THR = new TableHeaderRow(); foreach (string s in Data[0]) { TableHeaderCell THC = new TableHeaderCell(); THC.Text = s; THC.Font.Size = 50; THR.BorderStyle = BorderStyle.Solid; THR.Cells.Add(THC); } THR.Height = 50; THR.BackColor = System.Drawing.Color.Lavender; Table1.Rows.Add(THR); for (int i = 1; i < Data.Count; i++) { TableRow TR = new TableRow(); foreach (string s in Data[i]) { TableCell TC = new TableCell(); TC.Text = s; TC.BorderStyle = BorderStyle.Solid; TC.HorizontalAlign = HorizontalAlign.Center; TR.Cells.Add(TC); } Table1.Rows.Add(TR); } }
protected void DropDownListSuppliers_SelectedIndexChanged(object sender, EventArgs e) { BuildTable(NorthwindAccess.GetProducts(DropDownListSuppliers.SelectedValue)); }