C#： MySqlHelper 操作Mysql数据库，将dataset内的数据存入Mysql

 public class MySqlDbHelper
    {

        #region 私有变量
        private const string defaultConfigKeyName = " Database='sensetechtest';Data Source='127.0.0.1';User Id='root';Password='1234';pooling=true";//连接字符串 Database='数据库';Data Source='IP地址';User Id='sa';Password='sa';pooling=true
        private string connectionString = " Database='sensetechtest';Data Source='127.0.0.1';User Id='root';Password='1234';pooling=true";
        private string providerName = " Database='sensetechtest';Data Source='127.0.0.1';User Id='root';Password='1234';pooling=true";

        #endregion

        #region 构造函数

        /// <summary>
        /// 默认构造函数(DbHelper)
        /// </summary>
        public MySqlDbHelper()
        {
            //this.connectionString = ConfigurationManager.ConnectionStrings[defaultConfigKeyName].ConnectionString;
            //this.providerName = ConfigurationManager.ConnectionStrings[defaultConfigKeyName].ProviderName;
        }

        /// <summary>
        /// DbHelper构造函数