Hi,

I want to bind a sqldatasource to a Gridview.

there is no problem, when data come from one table, like:
"Select Price,ProductID From Prices"

But I get an Error, when data come from two tables, like:
"Select Price,ProductName From Prices JOIN Products ON Prices.ProductID = Prices.ProductID"

I have built the select command with the querybuilder and the results of the query test are ok.

Best Regards
Coder

What is the error? Also, if you have reconfigured the sqldatasource, you need to refresh the schema of the gridview from the gridview's smarttag options.