How to join 2 DataTable in a Dataset in VB.NET?

[Sampah]

helo, anyone have any idea of how to join two data table through a primary key in a dataset. For more specific, I have a "employee" table and a "user" table in a dataset. Not all employee are users, but user must be employee. Thus, i want only the employee that are users are displayed in the datagrid. I am using VB.Net as my programming language. Thanks in advance.

[Badaro]

Originally Posted by Sampah

helo, anyone have any idea of how to join two data table through a primary key in a dataset. For more specific, I have a "employee" table and a "user" table in a dataset. Not all employee are users, but user must be employee. Thus, i want only the employee that are users are displayed in the datagrid. I am using VB.Net as my programming language. Thanks in advance.

Which database are you using? Because, unless it doesn't support joins, it's probably a better idea to join the tables in the DB.

[]s Badaro

[Proto]

hmmm.... well i havent used .NET but the sql format would be

"select user.*, employee.* from user,employee where user.iduser = employee.theforeignkeyyouareusing

[ammoQ]

My guess: "select employee.* from user, employee where user.employee_id = employee.id" but it's only slightly different from Proto's attemt.

[Sampah]

thanks any other idea would be welcome, btw I'm using VB.net.