In ASP.net how do I relate tables. I am using Connection, Command and DataReader classes, is it possible to relate tables. OR if I use DataSet Class, is it possible to relate tables.
Basically, I want to get the result on a data grid for the Select Statment like
"SELECT T1.NAME, T2.DEPARTMENT FROM EMPLOYEES T1, DEPARTMENTS T2 WHERE T2.DEPARTMENTID = T1.DEPARTMENTID"
How do I do this ?