Displaying Data

Question

Hi All, My first post in this forum. Hope to be a regular here from now on, hopefully will contribute something to the forum. Anyhow my question is, how can i display data from different table in a DataGrid in C#. E.g following is my SQL Query. sql= "SELECT Contacts.Con_Id, Contacts.Con_First_Name, Contacts.Con_Last_Name, Organisation.Org_Name" ; sql+= "FROM Contacts INNER JOIN"; sql+= "Organisation ON Contacts.Org_Id = Organisation.Org_Id"; Now i am trying to use DataSet (through a Data Adapter) but it only works if i select the data from one table, i get problem when i have SQL Join query. How can i solve this problem. Thanks. Danial