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

oblivion_lurks · Answer

No problem!! Im glad you got it to work!!

datique · Answer

XB Gamer After seeing your post i tried it again and it seemed to be working now. I must have done something stupid. Thanks fore your help. Really appriciated.

oblivion_lurks · Answer

Sorry it took me soo long to respond!! That query you provided from your last response is basically the same exact query your running right? But you said its seems to be broken? I just ran a query similiar to yours and everything worked fine. This is what i typed in: SELECT Orders.OrderID Customers.CustomerID Employees.EmployeeID FROM Employees INNER JOIN (Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID) ON Employees.EmployeeID = Orders.EmployeeID and this is the code for my button click event: SqlCommand sqlCmd = this.sqlConnection1.CreateCommand(); sqlCmd.CommandType = CommandType.Text; sqlCmd.CommandText = this.textBox1.Text; DataSet ds = new DataSet(); SqlDataAdapter sqlDa = new SqlDataAdapter(sqlCmd); try { sqlDa.Fill(ds); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } this.dataGrid1.DataSource = ds; Let me know what you think.

datique · Answer

Thanks for the reply. But isnt the relation already defined in my sql query. I know what you mean by DataRelation but thats a lot of extra work for no reason. Can i not do with the DataRelation? I have pretty complex queries connecting 4/5 tables so you can imagine... Thanks in advance for any help

oblivion_lurks · Answer

Im a little scratchy in this erea but im pretty sure youll have to create a new DataRelation object to relate the two or three tables from the DataSet(s). Then add the new relation to the DataGrid. Hope this helps.