C#抽奖

C#抽奖

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace ParkLottery
{
    class DataAccess
    {
        public static string CONNECT_STRING = “Provider=Microsoft.Jet.OLEDB.4.0;Data Source=“+AppDomain.CurrentDomain.baseDirectory+“\\Park.mdb“;
        OleDbDataAdapter  dataAdapter = new  OleDbDataAdapter （）;
      
        public DataSet GetDataSet（string sql）
        {
            try
            {
                OleDbConnection  conn = new  OleDbConnection （CONNECT_STRING）;
                OleDbDataAdapter da = new OleDbDataAdapter（sql conn）;
                DataSet ds = new DataSet（）;
                da.Fill（ds “TABLE“）;
                conn.Close（）;
                return ds;
            }
            catch
            {
                return null;

            }
        }
	//Download by http://www.codefans.net
        public bool SQLExecute（string sql）
        {
            try
            {
                OleDbConnection conn = new OleDbConnection（CONNECT_STRING）;
                conn.Open（）;
                OleDbCommand comm = new  OleDbCommand （）;
                comm.Connection = conn;
                comm.CommandText = sql;
                comm.ExecuteNonQuery（）;
                comm.Connection.Close（）;
                conn.Close（）;
                return true;
            }
            catch
            {
                return false;

            }
        }
    }
}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2015-09-28 19:31  ParkLottery\