DataSet contains more columns. BUG?

trygvelo · Post by **trygvelo** » Wed 19 Jan 2005 10:59

Hi,

I'm using the latest (2.70) version of the MySQL Direct .NET connector. Discovered something I believe is not correct behaviour today. I have a dataadapter with a select statement like:

SELECT * FROM table

The corresponding datatable in the dataset is however not defined with all the columns that the SQL returns. When I use the dataset designtime it seems to be correct and the columns that are not defined in the dataset is not there, but at runtime those columns have automatically been added to the datatable. Is this correct behaviour?

Regards,
Trygve Lorentzen

Oleg · Post by **Oleg** » Wed 19 Jan 2005 16:47

If you want to get not all columns from your table, you must specify these columns in your select SQL.