using System; using System.Diagnostics; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Data.Odbc; public class Form1 : System.Windows.Forms.Form { private System.Windows.Forms.Button button1; private System.Windows.Forms.DataGrid dataGrid1; private System.Windows.Forms.Button button2; public Form1() { this.button1 = new System.Windows.Forms.Button(); this.dataGrid1 = new System.Windows.Forms.DataGrid(); this.button2 = new System.Windows.Forms.Button(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); this.SuspendLayout(); this.button1.Location = new System.Drawing.Point(8, 240); this.button1.Size = new System.Drawing.Size(104, 32); this.button1.Text = "Get Data From Biblio"; this.button1.Click += new System.EventHandler(this.button1_Click); this.dataGrid1.DataMember = ""; this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid1.Location = new System.Drawing.Point(8, 8); this.dataGrid1.Size = new System.Drawing.Size(280, 224); this.button2.Location = new System.Drawing.Point(120, 240); this.button2.Size = new System.Drawing.Size(152, 32); this.button2.Text = "Get Data From Access Northwind"; this.button2.Click += new System.EventHandler(this.button2_Click); this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(292, 273); this.Controls.AddRange(new System.Windows.Forms.Control[] { this.button2, this.dataGrid1, this.button1}); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); this.ResumeLayout(false); } [STAThread] static void Main() { Application.Run(new Form1()); } private OdbcConnection cn; private void button1_Click(object sender, System.EventArgs e) { try { cn = new OdbcConnection("DRIVER={SQL Server};SERVER=.;uid=admin;pwd=pw;database=biblio"); cn.Open(); OdbcCommand sc = new OdbcCommand("SELECT title, price FROM titles WHERE title LIKE 'Hi%'", cn); OdbcDataAdapter da = new OdbcDataAdapter(sc); DataSet ds = new DataSet("TitlesDS"); da.Fill(ds); dataGrid1.DataSource = ds.Tables[0]; } catch (Exception ex) { Debug.WriteLine(ex.ToString()); } finally { cn.Close(); } } private void button2_Click(object sender, System.EventArgs e) { try { cn = new OdbcConnection(@"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:NorthWind.mdb"); cn.Open(); OdbcCommand sc = new OdbcCommand("SELECT * from Employees", cn); OdbcDataAdapter da = new OdbcDataAdapter(sc); DataSet ds = new DataSet("TitlesDS"); da.Fill(ds); dataGrid1.DataSource = ds.Tables[0]; } catch (Exception ex) { MessageBox.Show("You probably need to change the file path to NorthWind.MDB used in the OdbcConnection Constructor or move a copy of the NorthWind.mdb to c:"); Debug.WriteLine(ex.ToString()); } finally { cn.Close(); } } }