Datagrid - 2 Tables - MySQL

[tomomark]

Hi everyone,

I have tried everything i know and searched google for hours with no joy, perhaps its just not possible.

What it is, i have two tables, stored in MySQL and i want to take info from both of those tables and enter the data into 1 datagrid.

There is a primary key which is related to both tables, any ideas if this is possible?

MArk

 

[ca8msm]

Can't you just join the tables in your SQL statement?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]