- 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\\n or move a copy of the NorthWind.mdb to c:\\\\");
- Debug.WriteLine(ex.ToString());
- } finally {
- cn.Close();
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/2003201511952.html
来源: http://www.codesnippet.cn/detail/2003201511952.html