C#编程：轻松操作Access数据库指南

 public static List<CaiJi> GetCaijiWin(string strWhere, string path)
        {
            //获取数据连接
            string con_str = ConfigurationManager.ConnectionStrings["access_con"].ConnectionString
 + path;
            OleDbConnection conn = new OleDbConnection(con_str);
            conn.Open();
            List<CaiJi> lis = new List<CaiJi>();
            try
            {
                string sql = "select [desc],[discount],[name],[PageUrl],[pic11],[pic12],[pic21],[pic22],[price],[price1],[size],[sku],[isbn],[isbn1] from Content where " + strWhere;
                OleDbCommand comm = new OleDbCommand(sql, conn);

                OleDbDataReader reader = comm.ExecuteReader();
                CaiJi cai = null;

                while (reader.Read())
                {
                    cai = new CaiJi();
                    cai.desc = reader["desc"].ToString();
                    cai.discount = reader["discount"].ToString();
                    cai.name = reader["name"].ToString();
                    cai.pageurl = reader["PageUrl"].ToString();
                    cai.pic11 = reader["pic11"].ToString();
                    cai.pic12 = reader["pic12"].ToString();
                    cai.pic21 = reader["pic21"].ToString();
                    cai.pic22 = reader["pic22"].ToString();
                    cai.price = reader["price"].ToString();
                    cai.price1 = reader["price1"].ToString();
                    cai.size = reader["size"].ToString();