mysql.data.dll下载_c#连接mysql必要插件
mysql.data.dll是C#操作MYSQL的驱动文件,是c#连接mysql必要插件,使c#语言更简洁的操作mysql数据库。当你的电脑弹出提示“丢失mysql.data.dll”或“无法找到mysql.data.dll”等错误问题,请下载本站为你提供的dll文件,使用它可以帮助用户解决上述问题。
dll文件修复方法:
1、解压下载的文件。
2、复制文件“mysql.data.dll”到系统目录下。
3、系统目录一般为:C:\WINNT\System32 64位系统为C:\Windows\SysWOW64
4、最后点击开始菜单-->运行-->输入regsvr32 mysql.data.dll 后,回车即可解决错误提示!
class="best-text mb-10">第三方组件:Mysql.Data.dll
说明:下载Mysql.Data.dll,然后在项目中添加该组件的引用,在代码页里输入using Mysql.Data.MysqlClient,我们就可以顺利的使用该类库的函数建立连接了。
以下是几个常用函数:
1 #region 建立MySql数据库连接 2 /// <summary> 3 /// 建立数据库连接. 4 /// </summary> 5 /// <returns>返回MySqlConnection对象</returns> 6 public MySqlConnection getmysqlcon() 7 { 8 //http://sosoft.cnblogs.com/ 9 string M_str_sqlcon = "server=localhost;user id=root;password=root;database=abc"; //根据自己的设置 10 MySqlConnection myCon = new MySqlConnection(M_str_sqlcon); 11 return myCon; 12 } 13 #endregion 14 15 #region 执行MySqlCommand命令 16 /// <summary> 17 /// 执行MySqlCommand 18 /// </summary> 19 /// <param name="M_str_sqlstr">SQL语句</param> 20 public void getmysqlcom(string M_str_sqlstr) 21 { 22 MySqlConnection mysqlcon = this.getmysqlcon(); 23 mysqlcon.Open(); 24 MySqlCommand mysqlcom = new MySqlCommand(M_str_sqlstr, mysqlcon); 25 mysqlcom.ExecuteNonQuery(); 26 mysqlcom.Dispose(); 27 mysqlcon.Close(); 28 mysqlcon.Dispose(); 29 } 30 #endregion 31 32 #region 创建MySqlDataReader对象 33 /// <summary> 34 /// 创建一个MySqlDataReader对象 35 /// </summary> 36 /// <param name="M_str_sqlstr">SQL语句</param> 37 /// <returns>返回MySqlDataReader对象</returns> 38 public MySqlDataReader getmysqlread(string M_str_sqlstr) 39 { 40 MySqlConnection mysqlcon = this.getmysqlcon(); 41 MySqlCommand mysqlcom = new MySqlCommand(M_str_sqlstr, mysqlcon); 42 mysqlcon.Open(); 43 MySqlDataReader mysqlread = mysqlcom.ExecuteReader(CommandBehavior.CloseConnection); 44 return mysqlread; 45 } 46 #endregion
1 using System.Data; 2 3 using MySql.Data.MySqlClient; 4 5 6 7 8 9 private MySqlConnection conn; 10 11 private DataTable data; 12 13 private MySqlDataAdapter da; 14 15 private MySqlCommandBuilder cb; 16 17 private DataGrid dataGrid; 18 19 20 21 private void connectBtn_Click(object sender, System.EventArgs e) 22 23 { 24 25 if (conn != null) 26 27 conn.Close(); 28 29 30 31 string connStr = String.Format("server={0};user id={1}; password={2}; port={3}; database=mysql; pooling=false; charset=utf8", 32 33 server.Text, userid.Text, password.Text, 3306); 34 35 36 37 try 38 39 { 40 41 conn = new MySqlConnection( connStr ); 42 43 conn.Open(); 44 45 46 47 GetDatabases(); 48 49 MessageBox.Show("连接数据库成功!"); 50 51 } 52 53 catch (MySqlException ex) 54 55 { 56 57 MessageBox.Show( "Error connecting to the server: " + ex.Message ); 58 59 } 60 61 } 62 63 64 65 private void GetDatabases() 66 67 { 68 69 MySqlDataReader reader = null; 70 71 MySqlCommand cmd = new MySqlCommand("SHOW DATABASES", conn); 72 73 74 75 try 76 77 { 78 79 reader = cmd.ExecuteReader(); 80 81 databaseList.Items.Clear(); 82 83 while (reader.Read()) 84 85 { 86 87 databaseList.Items.Add( reader.GetString(0) ); 88 89 } 90 91 } 92 93 catch (MySqlException ex) 94 95 { 96 97 MessageBox.Show("Failed to populate database list: " + ex.Message ); 98 99 } 100 101 finally 102 103 { 104 105 if (reader != null) reader.Close(); 106 107 } 108 109 } 110 111 112 113 private void databaseList_SelectedIndexChanged(object sender, System.EventArgs e) 114 115 { 116 117 MySqlDataReader reader = null; 118 119 conn.ChangeDatabase(databaseList.SelectedItem.ToString()); 120 121 //http://sosoft.cnblogs.com/ 122 123 MySqlCommand cmd = new MySqlCommand("SHOW TABLES", conn); 124 125 try 126 127 { 128 129 reader = cmd.ExecuteReader(); 130 131 tables.Items.Clear(); 132 133 while (reader.Read()) 134 135 { 136 137 tables.Items.Add( reader.GetString(0) ); 138 139 } 140 141 } 142 143 catch (MySqlException ex) 144 145 { 146 147 MessageBox.Show("Failed to populate table list: " + ex.Message ); 148 149 } 150 151 finally 152 153 { 154 155 if (reader != null) reader.Close(); 156 157 } 158 159 } 160 161 162 163 private void tables_SelectedIndexChanged(object sender, System.EventArgs e) 164 165 { 166 167 data = new DataTable(); 168 169 170 171 da = new MySqlDataAdapter("SELECT * FROM " + tables.SelectedItem.ToString(), conn ); 172 173 cb = new MySqlCommandBuilder( da ); // 此处必须有,否则无法更新 174 175 176 177 da.Fill( data ); 178 179 180 181 dataGrid.DataSource = data; 182 183 } 184 185 186 187 private void updateBtn_Click(object sender, System.EventArgs e) 188 189 { 190 191 DataTable changes = data.GetChanges(); 192 193 da.Update( changes ); 194 195 data.AcceptChanges(); 196 197 }
http://www.cnblogs.com/sosoft/p/kaifajishu.html