Csharp/CSharp Tutorial/ADO.Net/MySql

Материал из .Net Framework эксперт
Версия от 15:19, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

ODBC MySqlConnection

<source lang="csharp">using System; using System.Drawing; using System.Collections; using System.ruponentModel; using System.Windows.Forms; using System.Data; using Microsoft.Data.Odbc; public class MainClass : System.Windows.Forms.Form {

 private System.Windows.Forms.DataGrid dataGrid1;
 public MainClass()
 {
   InitializeComponent();
 }
 private void InitializeComponent()
 {
   this.dataGrid1 = new System.Windows.Forms.DataGrid();
   ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
   this.SuspendLayout();
   // 
   // dataGrid1
   // 
   this.dataGrid1.DataMember = "";
   this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
   this.dataGrid1.Location = new System.Drawing.Point(0, 8);
   this.dataGrid1.Name = "dataGrid1";
   this.dataGrid1.Size = new System.Drawing.Size(376, 288);
   this.dataGrid1.TabIndex = 0;
   // 
   // MainClass
   // 
   this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
   this.ClientSize = new System.Drawing.Size(384, 302);
   this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                   this.dataGrid1});
   this.Load += new System.EventHandler(this.MainClass_Load);
   ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
   this.ResumeLayout(false);
 }
 [STAThread]
 static void Main() 
 {
   Application.Run(new MainClass());
 }
 private void MainClass_Load(object sender, System.EventArgs e)
 {
   string connectionString = @"Driver={MySQL};SERVER=localhost;DATABASE=NorthwindMySQL;";
   OdbcConnection conn= new OdbcConnection(connectionString);
   conn.Open();
   OdbcDataAdapter da = new OdbcDataAdapter ("SELECT CustomerID, ContactName, ContactTitle FROM Customers", conn);            
   DataSet ds = new DataSet("Cust");     
   da.Fill(ds, "Customers");
   dataGrid1.DataSource = ds.DefaultViewManager;
   conn.Close();
 }

}</source>

Use OdbcDataAdapter to read data from ODBC MySql connection

<source lang="csharp">using System; using System.Drawing; using System.Collections; using System.ruponentModel; using System.Windows.Forms; using System.Data; using Microsoft.Data.Odbc; public class MainClass : System.Windows.Forms.Form {

 private System.Windows.Forms.DataGrid dataGrid1;
 public MainClass()
 {
   InitializeComponent();
 }
 private void InitializeComponent()
 {
   this.dataGrid1 = new System.Windows.Forms.DataGrid();
   ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
   this.SuspendLayout();
   // 
   // dataGrid1
   // 
   this.dataGrid1.DataMember = "";
   this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
   this.dataGrid1.Location = new System.Drawing.Point(0, 8);
   this.dataGrid1.Name = "dataGrid1";
   this.dataGrid1.Size = new System.Drawing.Size(376, 288);
   this.dataGrid1.TabIndex = 0;
   // 
   // MainClass
   // 
   this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
   this.ClientSize = new System.Drawing.Size(384, 302);
   this.Controls.AddRange(new System.Windows.Forms.Control[] {
                                   this.dataGrid1});
   this.Load += new System.EventHandler(this.MainClass_Load);
   ((System.ruponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
   this.ResumeLayout(false);
 }
 [STAThread]
 static void Main() 
 {
   Application.Run(new MainClass());
 }
 private void MainClass_Load(object sender, System.EventArgs e)
 {
   string connectionString = @"Driver={MySQL};SERVER=localhost;DATABASE=NorthwindMySQL;";
   OdbcConnection conn= new OdbcConnection(connectionString);
   conn.Open();
   OdbcDataAdapter da = new OdbcDataAdapter ("SELECT CustomerID, ContactName, ContactTitle FROM Customers", conn);            
   DataSet ds = new DataSet("Cust");     
   da.Fill(ds, "Customers");
   dataGrid1.DataSource = ds.DefaultViewManager;
   conn.Close();
 }

}</source>