连接Access数据库

1.web.config中配置

< configuration >

  < appSettings >

    < add key = " dbpa " value = " Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\Jack\Desktop\二代身份证阅读器123\二代身份证阅读器\WebApplication1\DataDirectory\ReadCard.accdb; " />

  </ appSettings >

  < connectionStrings />

2.创建CardTable表的类

[ Serializable ]

     publicpartialclass CardTable

    {

        #region  Model

         privateint  _ID;

         privatestring  _Cardid;

         privatestring  _Name;

         privatestring  _Sex;

         privatestring  _Ethnic;

         privatestring  _BirthDate;

         privatestring  _Address;

         privatestring  _QfOrgan;

         privatestring  _QfDate;

         privatestring  _CutoffDate;

         ///<summary>

         ///   自增ID

         ///</summary>

         publicint  ID

        {

             set  { _ID =  value ; }

             get  {  return  _ID; }

        }

         ///<summary>

         ///   证件号码

         ///</summary>

         publicstring  Cardid

        {

             set  { _Cardid =  value ; }

             get  {  return  _Cardid; }

        }

         ///<summary>

         ///   姓名

         ///</summary>

         publicstring  Name

        {

             set  { _Name =  value ; }

             get  {  return  _Name; }

        }

         ///<summary>

         /// 性别

         ///</summary>

         publicstring  Sex

        {

             set  { _Sex =  value ; }

             get  {  return  _Sex; }

        }

         ///<summary>

         /// 民族

         ///</summary>

         publicstring  Ethnic

        {

             set  { _Ethnic =  value ; }

             get  {  return  _Ethnic; }

        }

         ///<summary>

         /// 出生日期

         ///</summary>

         publicstring  BirthDate

        {

             set  { _BirthDate =  value ; }

             get  {  return  _BirthDate; }

        }

         ///<summary>

         /// 地址

         ///</summary>

         publicstring  Address

        {

             set  { _Address =  value ; }

             get  {  return  _Address; }

        }

         ///<summary>

         /// 签发机关

         ///</summary>

         publicstring  QfOrgan

        {

             set  { _QfOrgan =  value ; }

             get  {  return  _QfOrgan; }

        }

       

         ///<summary>

         /// 签发时间

         ///</summary>

         publicstring  QfDate

        {

             set  { _QfDate =  value ; }

             get  {  return  _QfDate; }

        }

         ///<summary>

         /// 截止时间

         ///</summary>

         publicstring  CutoffDate

        {

             set  { _CutoffDate =  value ; }

             get  {  return  _CutoffDate; }

        }

        #endregion  Model

    }

 

3.创建DBsource类

publicstaticstring  connectionString =  ConfigurationSettings .AppSettings[ "dbpa" ].ToString();

         ///<summary>

         /// 执行查询语句，返回DataSet

         ///</summary>

         ///<param name="SQLString"></param>

         ///<returns></returns>

         public DataSet  Query( string  SQLString)

        {

             OleDbConnection  connection =  new OleDbConnection (connectionString);           

             DataSet  ds =  new DataSet ();

             try

            {

                connection.Open();

                 OleDbDataAdapter  command =  new OleDbDataAdapter (SQLString, connection);

                command.Fill(ds,  "ds" );

            }

             catch  (System.Data.OleDb. OleDbException  ex)

            {

                 thrownew Exception (ex.Message);

            }

             return  ds;           

        }

         ///<summary>

         /// 增加一条数据

         ///</summary>

         publicvoid  Add( CardTable  model)

        {

             OleDbConnection  connection =  new OleDbConnection (connectionString);

            connection.Open();

             string  strinsert =  "insert into CardTable(CardID,Name,Sex,Ethnic,BirthDate,Address,QfOrgan,QfDate,CutoffDate) values (" ;

            strinsert +=  "'" + model.Cardid +  "'"  +  "," ;

            strinsert +=  "'" + model.Name +  "'"  +  "," ;

            strinsert +=  "'" + model.Sex +  "'"  +  "," ;

            strinsert +=  "'"  + model.Ethnic +  "'"  +  "," ;

            strinsert +=  "'"  + model.BirthDate +  "'"  +  "," ;

            strinsert +=  "'"  + model.Address +  "'"  +  "," ;

            strinsert +=  "'"  + model.QfOrgan +  "'"  +  "," ;

            strinsert +=  "'"  + model.QfDate +  "'"  +  "," ;

            strinsert +=  "'"  + model.CutoffDate +  "'"  +  ")" ;

             OleDbCommand  inst =  new OleDbCommand (strinsert, connection);

            inst.ExecuteNonQuery();

            connection.Close();

        }

 

4.后台代码连接，同时绑定GridView，人员列表

string  mySelectQuery =  "select * from CardTable" ; //查询语句

             DBsource  db =  new DBsource ();

             DataSet  ds =  new DataSet ();

            ds = db.Query(mySelectQuery);

            GridSelect.DataSource = ds;

            GridSelect.DataBind();

插入数据

CardTable  cdt =  new CardTable ();

            cdt.Cardid = TextBox1.Text;

            cdt.Name = TextBox2.Text;

            cdt.Sex = TextBox3.Text;

            cdt.Ethnic = TextBox4.Text;

            cdt.BirthDate = TextBox5.Text;

            cdt.Address = TextBox6.Text;

            cdt.QfOrgan = TextBox7.Text;

            cdt.QfDate = TextBox8.Text;

            cdt.CutoffDate = TextBox9.Text;

             DBsource  dbs =  new DBsource ();

            dbs.Add(cdt);

 

5.前台页面

< asp : GridView ID ="GridSelect" runat ="server" AllowPaging ="True" AutoGenerateColumns ="False"

         Width ="662px" Font-Size ="9pt" BackColor ="White" BorderColor ="#CCCCCC" BorderStyle ="None"

         BorderWidth ="1px" CellPadding ="4" ForeColor ="Black" GridLines ="Horizontal" AllowSorting ="True">

         < Columns >

             < asp : BoundField DataField ="CardID" HeaderText ="证件号码"/>

             < asp : BoundField DataField ="Name" HeaderText ="姓名"/>

             < asp : BoundField DataField ="Sex" HeaderText ="性别"/>

             < asp : BoundField DataField ="Ethnic" HeaderText ="民族"/>

             < asp : BoundField DataField ="BirthDate" HeaderText ="出生日期"/>

             < asp : BoundField DataField ="Address" HeaderText ="地址"/>

             < asp : BoundField DataField ="QfOrgan" HeaderText ="签发机关"/>

             < asp : BoundField DataField ="QfDate" HeaderText ="签发时间"/>

             < asp : BoundField DataField ="CutoffDate" HeaderText ="有效截止时间"/>

         </ Columns >

         < FooterStyle BackColor ="#CCCC99" ForeColor ="Black"/>

         < SelectedRowStyle BackColor ="#CC3333" Font-Bold ="True" ForeColor ="White"/>

         < PagerStyle BackColor ="White" ForeColor ="Black" HorizontalAlign ="Right"/>

         < HeaderStyle BackColor ="#333333" Font-Bold ="True" ForeColor ="White"/>

     </ asp : GridView >

 

6.在前台js中给TextBox赋值

document.getElementById( "TextBox1" ).value = arrys[0];