Hi, There I am new in asp.net. I am facing some problem to separat gridview data. I have created two tables in database like this, Branch Table BranchID BranchName 1 Silvar Tower 2 MM Tower 3 Bogra Extension Table ExtensionId SL.No Name Extension BranchID 1 1 Test 101 1 2 2 TestTwo 205 1 3 3 TestThree 301 2 4 4 TestFour 405 2 5 5 TestFive 505 3 6 6 TestSix 601 3 Now I want to view those tables data like this image below, Please help how can I do this with grid view in aspx page. Thanks.

You can follow up with this link and this link contains exactly what you want, https://www.c-sharpcorner.com/UploadFile/e06010/grouping-in-Asp-Net-gridview/ . Thanks.

Did you try this link, http://technico.qnownow.com/grouping-gridview-aspnet

Thank you sir for replying me. I joined two tables and the result view like the image below. But I can't separat them by Branch Name group. How can I do this like this image below Please help me to solve this issue. Thanks

Please try below link it does the same, http://technico.qnownow.com/grouping-gridview-aspnet/

Hi. You need to join those two tables and after that you need to apply group by in branchname or branchid. But in these two tables I didn't find any columns. After that retrieve data and bind in gridview. Thanks