1、分析

1、类库链接

 private static OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=|DataDirectory|\\zanlve.mdb;");

默认放在App_Data文件夹内即可。

2、插入操作

 

 需要执行两次命令

        /// <summary>
        /// 执行一条SQL语句 返回结果ID
        /// </summary>
        /// <param name="sqlstr"></param>
        /// <returns></returns>
        public static int ExecuteScalarSql(string sqlstr)
        {
            ConnOpen("conn");
            OleDbCommand cmd = conn.CreateCommand();
            cmd.CommandText = sqlstr;
            int count = cmd.ExecuteNonQuery();
            cmd.CommandText = "SELECT @@IDENTITY";
            int rowId = Convert.ToInt32(cmd.ExecuteScalar());
            ConnClose("conn");
            return rowId;
        }