I would like to bind to a datagrid, but I am using an inner join within the query, therefore how do I do the databind.

eg

myadapter.Fill(dsdata, "tablename")

As the above doesn't work

Thanks

Louisa

What error are you getting?

The SQL behind the query should be irrelevant to the result. Does the SQL work by itself? Can you test it within the database environment to confirm that the syntax is correct?

Peter
------------------------------------------------------
Work smarter, not harder.

The error I am getting is: -
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

I have checked my SQL query and that work fine in the access database.

I have put both the tables name in the databinding, which are used in the query, but I get the same error with both.

Louisa