Dataset TableAdapter Configuration Wizard Error

Posted on 2007-09-29
Last Modified: 2013-11-26

 I'm connecting my Dataset Into MySQL Instance , I  newly created DataSet in Data Sources view, I select
Edit DataSet with Designer, I wrote the Needed SQL Statement Inside (What Data Should be loaded into the table) the syntax is : Select * from MyTable,I press next , next and before the I press the (Finish) button for the wizard it Displayed the following error:
ERROR[HY010][MYSQL][ODBC 3.51 Driver][mysqld-4.1.20]
Then I couldn't complete the wizard , how I solve this problem?
Question by:mubama0n
    1 Comment
    LVL 12

    Accepted Solution

    hey YES YOU CAN,

    go to the mysql web site and downlad the MySQL connector for .net, ref the dlls in your project- I used it over a year ago and the namespace is based on the msql client so its almost as if you are using the ms sql stuff eg.
    this is a bit of lame code and dont ever use inline sql but its a quick cop and paste to show you...

    using MySql.Data.MySqlClient;
    using MySql.Data.Types;

            DBConnectionStrings myconstr = new DBConnectionStrings();
            MySqlConnection conn = new MySqlConnection(myconstr.MySqlConnectionString);
            MySqlCommand myCmd = new MySqlCommand("select lname as last,fname as first,id,phone,cellphone,fax,address1 as addr1,address2 as addr2,city,state,zip,email,contact_type as type,bill_lender_approved as bla from contact where clientid = ?clientid", conn);
            myCmd.Parameters.Add("?clientid", MySqlDbType.Int32).Value = clientid;
            //open MySql and execute
            MySqlDataAdapter mysqlad = new MySqlDataAdapter();
            mysqlad.SelectCommand = myCmd;
            DataTable cd = new DataTable();
                GridViewContact.DataSource = cd.DefaultView;


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
    Creating and Managing Databases with phpMyAdmin in cPanel.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now