DataGrideView

Question

Hi all Can any one guide me out how to fill the datagridview field with column from multi-table.. example  suppose i have 3 table  Table A (Cust_IDFirst NameLastName); Table B (Emp_IDEmployeeNameTask) and Table C (Status_IdInProgressPending). I want to fill the grideview with selected column like; DatagrideView ----------------------------------------------------------- [FirstName] [EmployeeName] [Task] [Status] ------------------------------------------------------------ A sample code will help me a lot. Thanks

Biswa Pujarini Mohapatra · Answer

You can't bind multiple table to gridview. But there are lot of options. Write a sql query with join to get one resultset then fill the dataset but as per your table structure i could see there is no relationship with tables.