title: dynamically create multiple ListBoxes
body: <p>I have a table in SQL Server which gives me a list of products (PRODUCT), and the products category (CAT).  Right now I am putting all the products in the same ListBox:</p>
  
  <pre>
  foreach (DataRow row in ds.Tables["ProductsTbl"].Rows)
  {
      string str = string.Format("{0}", row["PRODUCT"]);
      ListBox1.Items.Add(new ListItem(str));
  }
  </pre>
  
  <p>But I need to create as many listboxes as there are categories, and distribute those products according to the category.  Categories might be added or removed so I need to create them dynamically.</p>
  
  <p>So lets say the table has 5 products in category 1, 4 products in category 2 and 7 products in category 3, I would need 3 Listboxes created.  The first with 5 items, the second with 4 and the last one with 7 items.  Any ideas ?
  Thx.</p>