C#(.net)连接mysql

2016-10-27 阅读(4296)

Dll.rar  引用该dll

using MySql.Data.MySqlClient;

  MySqlConnection conn = new MySqlConnection("Database=XXX;Data Source=ip;User Id='';Password='';pooling=true;Minimum Pool Size=5;Maximum Pool Size=10;CharSet=utf8;port=3306;Connect Timeout=3600");

  conn.Open();

  MySqlCommand cmd = new MySqlCommand("存储过程名字", conn);    

  cmd.CommandType = System.Data.CommandType.StoredProcedure;

  cmd.Parameters.Add("?in_title", MySqlDbType.VarChar, 100);   /////带有输入参数

  cmd.Parameters["?in_title"].Value = "";

  int rows = Convert.ToInt32(cmd.ExecuteScalar());