连接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];
 
 
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值