help me in show data with list control

[cool_man]

I had 2 table: Category and ChildCategory in the database. Category(CategoryID, Name) ChildCategory(ChildCategoryID,Name,CategoryID) I want to show data like: Web Program (Category) ---- ASP (ChildCategory of this Category) ---- PHP (ChildCategory of this Category) ---- JSP (ChildCategory of this Category) Web Design (Category) ---- Photoshop (ChildCategory of this Category) ---- Illustrator (ChildCategory of this Category) ---- Dreamweaver (ChildCategory of this Category) Please help me to show this data with any control list(datagrid, datalist, or repeater). Thanks.

[Mazdak]

This is ASP.NET forum.. So what is ASP,PHP....? ASP.NET way: in the Load event: if(!Page.IsPostBack) { SqlConnection con = new SqlConnection("...."); SqlDataAdapter adapter = new SqlDataAdater("SELECT * FROM....",Conn); DataSet ds = new DataSet(); adapter.Fill(ds,"Tablename"); datagrid.DataSource = ds.Tables["tablename"]; } Mazy No sig. available now.