ODBC MySqlConnection : MySql : ADO.Net C# Examples

    
using  System;
using  System.Drawing;
using  System.Collections;
using  System.ComponentModel;
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.ComponentModel.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.ComponentModel.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();
    }
}