Problem:

If you use SQL Select queries which contain multiple databases (in 1 query), the DataSet Designer and VS often crash.

Solution:

  • Try to use „" before and after the database name in the SQL query, e.g. select meow from mydbname.mytablename myshortname`
  • Don’t use the database name in the query, if it is already in the ConnectionString. Use it only for „foreign“ databases.
  • Test the szenario without primary-key cols or indices.
  • Create the table, e.g. with a simple query that always works, to get the right columns. Then overwrite this query in the partial class of the DataSet, or in the Designer code, with your more complex query.
  • Try MySql.Data for .Net 2.0 and 4.0.
  • Create a new DataSet.

Using some of these tips, you should be able to create the DataTable and DataTablerAdapter in the DataSet.

  [email protected]