如何通过app.config来连接mysql

Question

如何通过app.config来连接mysql
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
     <add name ="conMysql"
         connectionString="DataLayer=MySQL; Server=127.0.0.1; Database=nsytowel; User ID=root; Password=;" />
  </connectionStrings>
</configuration>

Answer 1

mysql我记得有针对.NET的Connector的，你下一个Connector之后连接和操作都可以了。默认.NET好像没有针对mysql操作的类吧？(只用过mysql的.net connector,而且只是看了一下。呵呵)

Answer 2

在app.config里怎么写连接mysql的字符串? 最近改用mysql, 有点地方还没弄明白

Answer 3

string SqlConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["conMysql"].ConnectionString;

Answer 4

  <connectionStrings>
        <add name="abc" connectionString="data source=192.168.1.1;Initial Catalog=db;Max Pool Size=512;user id=sa;password=" />
    </connectionStrings>

Answer 5

<connectionStrings>
        <add name="connStr" connectionString="server=hostName(ip); user id=user; password=password; database=dbName;" providerName="MySql.Data.MySqlClient"/>
    </connectionStrings>
string dbConnectionString = ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
string dbProviderName = ConfigurationManager.ConnectionStrings["ConnStr"].ProviderName;
http://www.cnblogs.com/chy710/archive/2006/09/05/495000.aspx

Answer 6

     /// <summary>
        /// 返回DataSet数据集
        /// </summary>
        /// <param name="strSql">SQL语句</param>
        public DataSet GetDs(string strSql)
        {
            #region
            try
            {
                Open();
                sqlda = new MySQLDataAdapter(strSql, sqlcn);
                ds = new DataSet();
                sqlda.Fill(ds);    //报错的断点处
                Close();
                return ds;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                throw new Exception("在执行操作时发生了异常。"+ex.Message.ToString());
            }
            finally
            {
                Close();
            }
            #endregion
        }<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="conStr" 
         providerName="System.Data.SqlClient" 
         connectionString="server=.;database=nsytowel;Integrated Security=SSPI" />
    <add name="conMysql" 
         connectionString="server=localhost;user id=root; password=; Database=nsytowel;CharacterSet =gb2312;"
         providerName="MySql.Data.MySqlClient"/>
  </connectionStrings>
</configuration>在执行操作时发生了异常。MySQLDriverCS Exception: MySQLDriverCS Error: wrong query.No database selected  

Answer 7

使用Enterprise library ,然后让他同时支持sqlserver, oracle, mysql好了

Answer 8

我是想通过app.config来部署数据库连接.. mssql还可以, 现在改用mysql 就问题出来了

Answer 9

问题解决  贴出代码<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
     <add name="conMysql" 
         connectionString="Location=127.0.0.1;UserID=root;Password=;Data Source=nsytowel;CharacterSet =gb2312;"
         providerName="System.Data.MySqlClient"/>
  </connectionStrings>
</configuration>