/// <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));
}
