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 ?

:(

Ya it is possible , You will use the CommandText method.
It is very useful for you.

Regards
Adalarasu. S

Thank you arasu. How do I use commandtext method. If I call a procedure from my application, how will I get the result of the query back to the dataset

run the sql statment as you have it, or use a stored procedure. not sure what your question is

I shall explain what I need, excuse me if my query is too primitive. From ASP .net application I want to run a stored procedure and get the result into a datagrid in the application. How will I do it ?