dynamic control using innerhtml

 Hi,


i need to show the products in dropdownlist order by category in label using div1.innerhtml.

i am having sql query for display the products oredr by category.

"select p.productname, p.productid, c. categoryname from ProductTable p innerjoin CategoryTable c on c.Itemid=p.categoryId order by c.catgeoryname, p. productname"

    
           Page_Load()
                  {
                    Conn.Open();
                    constr = "select p.productname, p.productid, c. categoryname from ProductTable p innerjoin CategoryTable c on c.Itemid=p.categoryId order by c.catge ...