how to dynamically build and fill a table
Posted on 2011-10-31
I am using asp.net
I want to retrieve some data, then dynamically build a table based on the data returned.
I know I can easily use a gridview for this purpose. But I want to learn how to do this.
Can someone give me some suggestions on how to approach this.
My SQ!L query would look similar to this one.
ITEMS.FULL_NAME as 'Item#',
ITEMS.SALESDESCRIPTION as 'Description',
ITEMS.MANUFACTURER as 'Mfg',
ITEM_LOCATION_MAP.ON_HAND_COUNT as 'Total',
ITEMS.ITEM_CLASS as 'Class',
LEFT OUTER JOIN Administrator.ITEM_LOCATION_MAP ON Administrator.ITEM_LOCATION_MAP.ITEM_ID = Administrator.ITEMS.ITEM_ID
Left join notes_user on notes_user.item_id = items.item_id
where Administrator.Items.IsInactive = 'No' and items.name like '7402%'