网站建设公司海报,综合性门户网站有,linux wordpress mysql 配置,网络域名怎么设置ASP.NET Mysql操作类 以下连接MySql数据库以VS2010为例#xff0c;对于其他的编辑器也差不多 1. 我们需要在Mysql官网下载一个组件http://dev.mysql.com/downloads/connector/net/ 下载最新版的即可#xff0c;并且安装connector#xff0c;其实仅仅只是为了得到Mysql.Data…ASP.NET Mysql操作类 以下连接MySql数据库以VS2010为例对于其他的编辑器也差不多 1. 我们需要在Mysql官网下载一个组件http://dev.mysql.com/downloads/connector/net/ 下载最新版的即可并且安装connector其实仅仅只是为了得到Mysql.Data.dll ( 0.0 ) 2. 在你的VS2010 解决方案管理器里面添加 Mysql.Data.dll 引用(通常在c:\program files\MySQL\MySQL Connector Net(your version here)\Assemblies\v4.0 or v2.0) 3. 在你的web.config里面添加connection: [csharp] view plain copy connectionStrings add nameMySQLConnString connectionStringServeryour_MySql_Server_IP;Port3306;DatabasedatabaseName;Uidusername;Pwdyourpassword;poolingfalse; providerNameMySql.Data.MySqlClient/ /connectionStrings 4. 在你的代码前面添加using MySQL.Data.MySqlClient; 下面是个简单的连接Mysql 并且使用的例子 [csharp] view plain copy protected void Page_Load(object sender, EventArgs e) { DataSet ds_temp GetObjects(); ListBox1.DataSource ds_temp; ListBox1.DataTextField yourColumn; ListBox1.DataValueField yourColumn; ListBox1.DataBind(); } protected static DataSet GetObjects() { DataSet ds_temp Connection_cls.GetDataSetQuery(SELECT yourColumn FROM yourtable, null); return ds_temp; } private static string getHostString() { string host ConfigurationManager.ConnectionStrings[MySQLConnString].ConnectionString; return host; } public static DataSet GetDataSetQuery(string sql, ArrayList paramList) { using (MySqlConnection conn new MySqlConnection(getHostString())) { try { conn.Open(); MySqlDataAdapter da new MySqlDataAdapter(sql, conn); da.SelectCommand.Parameters.Clear(); if (paramList ! null) { for (int i 0; i paramList.Count; i) { da.SelectCommand.Parameters.Add(paramList[i] as MySqlParameter); } } DataSet ds new DataSet(); da.Fill(ds); return ds; } finally { conn.Close(); } } } Mysql官方.net连接文档 Im using Visual Web Developer 2010 Express Edition (and Visual C# 2010 Express) with MySQL. This is what I did:1 - Download and install MySQL connector(just to get MySql.Data.dll).2 - VWD 2010 in the Solution Explorer add reference to MySql.Data.dll(usually in c:\program files\MySQL\MySQL Connector Net(your version here)\Assemblies\v4.0 or v2.0)3 - In the web.config add your string connection:connectionStringsadd nameMySQLConnString connectionStringServeryour_MySql_Server_IP;Port3306;DatabasedatabaseName;Uidusername;Pwdyourpassword;poolingfalse; providerNameMySql.Data.MySqlClient//connectionStrings4 - In the code behind type in: using MySQL.Data.MySqlClient;Now you can use it as in this example:protected void Page_Load(object sender, EventArgs e){DataSet ds_temp GetObjects();ListBox1.DataSource ds_temp;ListBox1.DataTextField yourColumn;ListBox1.DataValueField yourColumn;ListBox1.DataBind();}protected static DataSet GetObjects(){DataSet ds_temp Connection_cls.GetDataSetQuery(SELECT yourColumn FROM yourtable, null);return ds_temp;}private static string getHostString(){string host ConfigurationManager.ConnectionStrings[MySQLConnString].ConnectionString;return host;}public static DataSet GetDataSetQuery(string sql, ArrayList paramList){using (MySqlConnection conn new MySqlConnection(getHostString())){try{conn.Open();MySqlDataAdapter da new MySqlDataAdapter(sql, conn);da.SelectCommand.Parameters.Clear();if (paramList ! null){for (int i 0; i paramList.Count; i){da.SelectCommand.Parameters.Add(paramList[i] as MySqlParameter);}}DataSet ds new DataSet();da.Fill(ds);return ds;}finally{conn.Close();}} } 转载于:https://www.cnblogs.com/qqhfeng/p/5223054.html
