ADO.net连接access2007数据库插入语句，删除语句，查找语句，苦逼学生党求大神帮忙

Question

ado.netaccess数据库c#c#连接access数据库

Answer 1

http://blog.csdn.net/xianfajushi/article/details/8548117

Answer 2

http://blog.sina.com.cn/s/blog_901abc39010103ut.html

Answer 3

照理说网上的例子很多，看你是学生，还是直接发你代码吧private static string connStr = ConfigurationManager.ConnectionStrings["OleDbConnStr"].ConnectionString;        private static string _gstrSQL;//用来保存全局SQL
        public static string gstrSQL
        {
            get { return _gstrSQL; }
            set { _gstrSQL = value; }
        }        #region 执行SQL语句,返回受影响行数
        public static int ExecuteNonQuery(string sql, params OleDbParameter[] parameters)
        {
            using (OleDbConnection conn = new OleDbConnection(connStr))
            {
                conn.Open();
                using (OleDbCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    cmd.Parameters.AddRange(parameters);
                    return cmd.ExecuteNonQuery();
                }
            }
        }
        #endregion        #region 执行SQL语句,返回第一行,第一列数据
        public static object ExecuteScalar(string sql, params OleDbParameter[] parameters)
        {
            using (OleDbConnection conn = new OleDbConnection(connStr))
            {
                conn.Open();
                using (OleDbCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    cmd.Parameters.AddRange(parameters);
                    return cmd.ExecuteScalar();
                }
            }
        }
        #endregion        #region 执行SQL语句,返回DataTable;只用来执行查询结果比较少的Oracle
        public static DataTable ExecuteDataTable(string sql, params OleDbParameter[] parameters)
        {
            using (OleDbConnection conn = new OleDbConnection(connStr))
            {
                conn.Open();
                using (OleDbCommand cmd = conn.CreateCommand())
                {
                    cmd.CommandText = sql;
                    cmd.Parameters.AddRange(parameters);
                    OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);
                    DataTable datatable = new DataTable();
                    adapter.Fill(datatable);
                    return datatable;
                }
            }
        }
        #endregion