hello,
i have a datatable1 with the following columns Model, type, price
facilityid hotel_name fac_type
1 taj abc
2 taj xyz
3 hotel2 abx
below is the another table(say mastertable). I want to display the facilityid in the gridview acording to as below, if hotel_name of table1 is matched with mastertable. the grid will have 4 columns the multiple values will be in 4th column as shown
hotel_id hotel_name country facility
--------------------------------------------------------------
1 taj india 1,2
how do i go around achieving this??
please suggest me asp.net code for this.
Thanks