How to Add Data to GridView from Multiple Tables in c#

Question

How to Add Data to GridView from Multiple Tables in c#.... i had 2 tables one is owner table from that i want 0wnerName and the other is FileUpload table from that i want Filenamefilepath and date. i want this four fields in grid view plz help me...

Pankaj Kumar Choudhary · Answer

Hello @Navya you can use concept of join. I means use join in DB and create a single table now you can bind this single table to grid view . You can use inner left outerright outer join as per your requirement http://www.codeproject.com/Tips/712941/Types-of-Join-in-SQL-Server http://www.w3schools.com/sql/sql_join.asp http://www.tutorialspoint.com/sql/sql-using-joins.htm

navya b · Answer

Thanks for the help Ramya and kumar

ramya bharath · Answer

Refer this http://aspdotnetcodes.com/SQLDataSource_StoredProcedure_Multiple_Tables_Update.aspx instead of store procedure u can also do the same with a query