使用sharpdevelop连接MySQL

MySQL版本为：5.0.88；

sharpdevelop版本3.1

 

综合网上查找的信息，通过MySQL.DATA这个类来连接数据库，其特性和ODBC一样，其中的方法和属性也基本一致。

首先去MySQL网页上下载5.0.9版本的Connector。Connector/Net5.0。

安装好以后可以在/windows/assembly文件夹找到MySQL.DATA这个组件。这时候已经将这个组件注册到全局程序集中了，

我们就可以在sharpdevelop中使用该组件。

打开sharpdevelop和要使用MySQL数据库的工程，在展开的工程中右键点击引用，选择添加引用。在弹出的GAC对话框中选中MySQL.Data并点击右边的选择，将该引用加入到该工程。在文件的顶部加入 using Mysql.Data.MysqlClient;后即可使用MySqlConnection、MySqlCommand、MySqlDataReader、MysqlDataAdapter、MysqlGrid等方法进行数据库操作。

 

以下是官方给出的示例代码。

/* * Created by SharpDevelop. * User: Lecenio Helio Trein Junior - lecenoi@yahoo.com.br * Date: 3/23/2005 * Time: 13:56 * */ using System; using System.Drawing; using System.Windows.Forms; using System.Data; using MySql.Data.MySqlClient; namespace MySqlSample { /// <summary> /// Application to show how to connect with mySQL /// </summary> public class MainForm : System.Windows.Forms.Form { private System.Windows.Forms.DataGrid MyDataGrid; private MySqlConnection MyConn; private MySqlDataAdapter MyAdapter; private DataSet MyDataSet; public MainForm() { InitializeComponent(); MyDataSet = new DataSet(); MyConn = new MySqlConnection("Database=myDatabase;Data Source=10.0.4.217;User Id=lecenio;Password=senha"); try{ MyConn.Open(); } catch(System.Exception e) { MessageBox.Show(e.Message.ToString()); } if (MyConn.State == ConnectionState.Open) { MyAdapter = new MySqlDataAdapter("SELECT * FROM myTable", MyConn); MyAdapter.Fill(MyDataSet, "MyTable"); MyDataGrid.DataSource = MyDataSet; MyDataGrid.DataMember = "MyTable"; } } protected override void Dispose(bool disposing) { if (disposing) { if (MyConn.State == ConnectionState.Open) { MyConn.Close(); } } base.Dispose(disposing); } [STAThread] public static void Main(string[] args) { Application.Run(new MainForm()); } #region Windows Forms Designer generated code /// <summary> /// This method is required for Windows Forms designer support. /// Do not change the method contents inside the source code editor. The Forms designer might /// not be able to load this method if it was changed manually. /// </summary> private void InitializeComponent() { this.MyDataGrid = new System.Windows.Forms.DataGrid(); ((System.ComponentModel.ISupportInitialize)(this.MyDataGrid)).BeginInit(); this.SuspendLayout(); // // MyDataGrid // this.MyDataGrid.DataMember = ""; this.MyDataGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.MyDataGrid.Location = new System.Drawing.Point(16, 8); this.MyDataGrid.Name = "MyDataGrid"; this.MyDataGrid.Size = new System.Drawing.Size(352, 336); this.MyDataGrid.TabIndex = 0; // // MainForm // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(384, 357); this.Controls.Add(this.MyDataGrid); this.Name = "MainForm"; this.Text = "MainForm"; ((System.ComponentModel.ISupportInitialize)(this.MyDataGrid)).EndInit(); this.ResumeLayout(false); } #endregion } }  

 

sharpdevelop网站的wiki给出的解决方案点这里。