how to join two datatable datas into one datatable to show in one gridview in asp.net

Question

how to join two datatable datas into one datatable to show in one gridview

i.e in 1 datatable i have username and pwd and in another datatable i have that user details. how to show all these in one datatable to get those values display in gridview(asp.net)

any idea????

Answer 1

What you need is a join on the tables before reading them into a DataTable: SQL Joins

Answer 2

@Ranjana have a look at this MSDN article it deals with what you want..

Answer 3

You can merge two datatable, here is the sample for that. http://msdn.microsoft.com/en-us/library/system.data.datatable.merge.aspx