Re: Dynamic SQL generation failing

[David Harvey]

I did not do a full expansion and none of the columns are invisible.

I did, however, find a solution.

I changed the Data Adapter instantiation, put the Builder instantiation before the Fill statement, and then removed the Get*Commands.

Now everything works. I have no idea why, what makes the difference, or what has changed from previous versions.

Here is the good code:

var sc = new MySqlConnection(MySQLConnectString);
var sa = new MySqlDataAdapter();
sa.SelectCommand = new MySqlCommand("SELECT * FROM Table_Name", sc);
var builder = new MySqlCommandBuilder(sa);
var ds = new DataSet();
sa.Fill(ds, "Table_Name");

Thanks for the help!!

Dave Harvey