键盘钢琴KeyboardPiano（源代码）

键盘钢琴谱 练习打字速度和你的节奏感 ,

using System;
using System.Collections;
using System.Collections.Generic;
using System.Text;
using System.Windows.Forms;
using System.Data.Common;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.Reflection;
using System.IO;
using System.ComponentModel;
using ADOX;//该命名空间包含创建ACCESS的类（方法）
using JRO;//该命名空间包含压缩ACCESS的类（方法）
using System.Data;//1引入操作Access数据库名称空间
using System.Configuration;//2引入读取配置文件的名称空间
using System.xml;
using System.Web;
using System.Security.Cryptography;


namespace KeyboardPiano
{
    #region DBAccess 数据操作和常用函数
    public class DBAccess
    {
        private string connectionString = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=“ + Application.StartupPath.ToString（） + “\\sheetMusic.dat“;

        private DbConnection dbConn;
        private OleDbFactory dbFactory;

        public DBAccess（）
        {
            dbFactory = OleDbFactory.Instance;
            dbConn = dbFactory.CreateConnection（）;
        }

        /// 

        /// 检查数据库连接是否打开
        /// 

        public void CheckConnection（）
        {

            if （dbConn.State == System.Data.ConnectionState.Closed）
            {
                try
                {
                    dbConn.ConnectionString = connectionString;
                    dbConn.Open（）;
                }
                catch （ArgumentException e）
                {
                    const string sConnectionerror = “数据连接失败。“;
                    ShowErrorMsg（sConnectionerror + e.Message）;
                }
            }
        }

        /// 

        /// 取得数据库连接
        /// 

        public DbConnection Connection
        {
            get
            {
                CheckConnection（）;
                return dbConn;
            }
        }

        /// 

        /// 创建Command
        /// 

        /// SQL语法
        /// 
        public DbCommand DBCommand（string sqlString）
        {
            DbCommand cmd = dbFactory.CreateCommand（）;
            cmd.CommandText = sqlString;
            cmd.Connection = Connection;
            return cmd;
        }

        public OleDbFactory DBFactory
        {
            get
            {
                return dbFactory;
            }
        }
        /// 

        /// 创建DataAdapter
        /// 

        /// SQL语法
        /// 
        public DbDataAdapter DBDataAdapter（string sqlString）
        {
            DbDataAdapter dr = dbFactory.CreateDataAdapter（）;
            dr.SelectCommand = DBCommand（sqlString）;
            return dr;
        }

        /// 

        /// 通过语法，取得数值，返回是值的数组
        /// 

        /// SQL语法
        /// 
        public object[] DBSelectValue（string sqlString）
     

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       4286  2011-03-07 16:17  KeyboardPiano\1312160.ico

     文件      28672  2011-02-25 15:18  KeyboardPiano\bin\Debug\AxInterop.ShockwaveFlashobjects.dll

     文件      16021  2006-03-22 12:25  KeyboardPiano\bin\Debug\DiamondBlue.ssk

     文件      16669  2006-03-22 12:26  KeyboardPiano\bin\Debug\DiamondGreen.ssk

     文件      36864  2011-02-24 09:40  KeyboardPiano\bin\Debug\Interop.ADOX.dll

     文件       9216  2011-02-24 09:40  KeyboardPiano\bin\Debug\Interop.JRO.dll

     文件      32768  2011-03-07 16:17  KeyboardPiano\bin\Debug\Interop.ShockwaveFlashobjects.dll

     文件     516096  2006-08-18 11:50  KeyboardPiano\bin\Debug\IrisSkin2.dll

     文件    2434048  2011-02-26 10:13  KeyboardPiano\bin\Debug\Keybarod2.fla

     文件     325734  2011-02-26 10:18  KeyboardPiano\bin\Debug\Keybarod2.swf

     文件     285184  2011-03-07 16:17  KeyboardPiano\bin\Debug\KeyboardPiano.exe

     文件     128512  2011-03-07 16:17  KeyboardPiano\bin\Debug\KeyboardPiano.pdb

     文件       2560  2011-02-26 13:53  KeyboardPiano\bin\Debug\KeyboardPiano.suo

     文件      14328  2011-03-07 16:17  KeyboardPiano\bin\Debug\KeyboardPiano.vshost.exe

     文件        490  2007-07-21 01:33  KeyboardPiano\bin\Debug\KeyboardPiano.vshost.exe.manifest

     文件      15156  2006-03-22 05:55  KeyboardPiano\bin\Debug\MacOS.ssk

     文件      15899  2007-12-22 09:46  KeyboardPiano\bin\Debug\MP10.ssk

     文件      16292  2007-12-22 09:41  KeyboardPiano\bin\Debug\MSN.ssk

     文件       9218  2006-03-22 06:14  KeyboardPiano\bin\Debug\Page.ssk

     文件    1506304  2011-02-26 09:10  KeyboardPiano\bin\Debug\piano.fla

     文件     151927  2011-02-26 09:07  KeyboardPiano\bin\Debug\piano.swf

     文件      12389  2006-03-22 05:57  KeyboardPiano\bin\Debug\RealOne.ssk

     文件       7680  2011-02-26 14:35  KeyboardPiano\bin\Debug\RunningWord.dll

     文件      24064  2011-02-26 14:35  KeyboardPiano\bin\Debug\RunningWord.pdb

     文件     172032  2011-02-24 16:16  KeyboardPiano\bin\Debug\sheetMusic.dat

     文件      13459  2006-03-22 05:58  KeyboardPiano\bin\Debug\SportsOrange.ssk

     文件      15928  2007-12-22 09:10  KeyboardPiano\bin\Debug\Vista2_color7.ssk

     文件      12600  2006-07-13 23:36  KeyboardPiano\bin\Debug\XPSilver.ssk

     文件     118063  2011-02-24 20:05  KeyboardPiano\DBAccessCommon.cs

     文件       1662  2011-02-25 15:34  KeyboardPiano\ImportPiano.cs

............此处省略67个文件信息