c#连接Access(含有插入日期类型)

 

1. using System;
2. using System.Collections.Generic;
3. using System.Text;
4. using System.Data;
5. using System.Data.OleDb; 
7. namespace We_Are_AA_CSharp_ACCESS_
8. {
9.     class BuyThingTable
10.     {
12.         public string mydataSource = "WeAreAA.mdb";
14.         public string connstr = "Provider=Microsoft.jet.OLEDB.4.0;Data Source=WeAreAA.mdb";
16.         //获得购物表
17.         public DataSet getbuyThingTable()
18.         {
19.             DataSet ds = new DataSet();
20.             string cmdStr = "select id,buyUserName,ThingName,moneyTotal,buyDate from buyThingTable order by buyDate desc";
21.             OleDbConnection conn = new OleDbConnection(connstr);
23.             OleDbDataAdapter dataAd