连接Access数据库

1.web.config中配置

<configuration>

  <appSettings>

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

  </appSettings>

  <connectionStrings/>

2.创建CardTable表的类

[Serializable]

    publicpartialclassCardTable

    {

        #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>

        publicDataSet Query(string SQLString)

        {

            OleDbConnection connection = newOleDbConnection(connectionString);           

            DataSet ds = newDataSet();

            try

            {

                connection.Open();

                OleDbDataAdapter command = newOleDbDataAdapter(SQLString, connection);

                command.Fill(ds, "ds");

            }

            catch (System.Data.OleDb.OleDbException ex)

            {

                thrownewException(ex.Message);

            }

            return ds;           

        }

        ///<summary>

        ///增加一条数据

        ///</summary>

        publicvoid Add(CardTable model)

        {

            OleDbConnection connection = newOleDbConnection(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 = newOleDbCommand(strinsert, connection);

            inst.ExecuteNonQuery();

            connection.Close();

        }

 

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

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

            DBsource db = newDBsource();

            DataSet ds = newDataSet();

            ds = db.Query(mySelectQuery);

            GridSelect.DataSource = ds;

            GridSelect.DataBind();

插入数据

CardTable cdt = newCardTable();

            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 = newDBsource();

            dbs.Add(cdt);

 

5.前台页面

<asp:GridViewID="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:BoundFieldDataField="CardID"HeaderText="证件号码"/>

            <asp:BoundFieldDataField="Name"HeaderText="姓名"/>

            <asp:BoundFieldDataField="Sex"HeaderText="性别"/>

            <asp:BoundFieldDataField="Ethnic"HeaderText="民族"/>

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

            <asp:BoundFieldDataField="Address"HeaderText="地址"/>

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

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

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

        </Columns>

        <FooterStyleBackColor="#CCCC99"ForeColor="Black"/>

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

        <PagerStyleBackColor="White"ForeColor="Black"HorizontalAlign="Right"/>

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

    </asp:GridView>

 

6.在前台js中给TextBox赋值

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