form1.cs

仿华为CC08数据库查询分析器.含相同的数据表和功能.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using System.Data.OleDb;

namespace RedEye
{
    public partial class Form1 : Form
    {
        static private string envpath = System.Environment.CurrentDirectory;
        public Form1()
        {
            InitializeComponent();            
        }

        private void aToolStripMenuItem_Click(object sender, EventArgs e)
        {
            

        }

        private void bToolStripMenuItem_Click(object sender, EventArgs e)
        {
            OleDbConnectionStringBuilder connectStringBuilder= new OleDbConnectionStringBuilder();           
            connectStringBuilder.DataSource = envpath+"\\cc08.mdb";
            connectStringBuilder.Provider="Microsoft.Jet.OLEDB.4.0";
            using (OleDbConnection cn=new OleDbConnection(connectStringBuilder.ConnectionString))
            {

                DataSet ds=new DataSet();
                OleDbCommand cmdLiming=new OleDbCommand("SELECT * FROM tbl_slot", cn);
                cn.Open();
                using (OleDbDataReader drLiming=cmdLiming.ExecuteReader())
                {
                    ds.Load(drLiming, LoadOption.OverwriteChanges, new string[] { "tbl_slot" });
                    // 将 BindingSource 组件绑定到 DataSet 当中的"学生"数据表。
                    this.bindingSource1.DataSource=ds.Tables["tbl_slot"];
                    // 将 DataGridView 控件绑定到 BindingSource 组件。
                    this.dataGridView1.DataSource = this.bindingSource1;

                }

            }

        }

        private void menuStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            switch (e.ClickedItem.Text)
            {
                case "a":
                    {
                        MessageBox.Show(e.ClickedItem.Text);
                        break;
                    }
                default:
                    break;
            }
        }

        private void bindingSource1_CurrentChanged(object sender, EventArgs e)
        {

        }
    }
}