Data Binding from many Tables to Gridview
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.