DataSet contains more columns. BUG?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
Posts: 13
Joined: Wed 19 Jan 2005 10:53

DataSet contains more columns. BUG?

Post by trygvelo » Wed 19 Jan 2005 10:59


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:


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?

Trygve Lorentzen

Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

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.

Post Reply