How to view two tables data in gridview separately.

Faysal Chowdhury

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

Extension Table

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg7y ago
Accepted answer
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.
Faysal Chowdhury7y ago
Thank you all sir.
Jignesh Kumar7y ago
Did you try this link, http://technico.qnownow.com/grouping-gridview-aspnet
Faysal Chowdhury7y ago
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
Jignesh Kumar7y ago
Please try below link it does the same,

http://technico.qnownow.com/grouping-gridview-aspnet/
Salman Beg7y ago
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