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

Accepted 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 outer,right 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 b11y ago

Thanks for the help Ramya and kumar

ramya bharath11y ago

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