gridview binding

Question

I want to use a single gridview to bind data from multiple database table having different fields..i use stored procedure for selecting database table and i am fetching all fields from table..since i am using a single gridview i'm unable to bind only specific fields in gridview using template field..how to bind specific coulmns to a gridview programmatically? Please help..

Khaja Moizuddin · Answer

I hope you can bind columns using template field  you have to declare what columns you need to bind to grid by joining the table by using joins concept and fetch the records and bind it to the grid. Please refer the below links https://msdn.microsoft.com/en-us/library/bb288032.aspx https://www.codeproject.com/Questions/1010442/how-we-can-display-two-tables-in-a-single-gridview https://forums.asp.net/t/1337967.aspx?Data+from+2+tables+on+1+GridView http://geekswithblogs.net/dotNETvinz/archive/2008/07/23/biding-one-gridview-with-different-tables-from-the-database-based.aspx http://www.dotnetinterviewquestions.in/article_aspnet-interview-questions:-can-we-merge-two-dataset-in-to-a-single-gridview-in-aspnet_52.html It helps you.