Hi,
am using gridview bind method but repeat row in the table.
am using query:
SELECT a.sno,a.menuname,b.submenu,b.sno from submenu as b inner join topmenu as a on a.sno=b.menuid INNER JOIN Submenulist as c ON b.sno=c.submenuid group by a.sno,a.menuname,b.submenu,b.sno
output:
1 Websit Manager Domain Manager 1
2 Table Reservation Restaurant Manager 1
3 Costomer Manager Team Manager 1
4 Urbane News & Events 1
5 Discover Careers 1
6 Vehicle Maintanance Customer Feedback 1
7 Sales Photo Gallery 1
8 Reports Manage Videos 1
9 Manage Users Health Tips 1
10 Websit Manager Food Menu Manager 1
but i want output:
this format:
websitemanager this main menu
websitemanager
Domain Manager- this is submenu links
Restaurant Manager
Team Manager
Customer Feedback
Food Menu Manager
Table Reservation-this is another main menu
Add new table reservation
Customer manager
Add customer
Thanks to all
chandru