[C#] OleDb를 이용한 accdb 파일 연결

Access 파일을 연결하여 DB Query 하기.
info_Tab 테이블에 데이터를 삽입하고 select하는 구문.
돌려보진 않았으니 디버깅 해보시길~

참조 : http://blog.naver.com/PostView.nhn?blogId=unidenti&logNo=90083354068

            OleDbConnection conn = new OleDbConnection();
            OleDbCommand connCmd = new OleDbCommand();
            try
            {                      
                conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" + this.accFileName + ";Mode=ReadWrite;Jet OLEDB:Database Password="+this.dbPasswd;
                conn.Open();
                connCmd.Connection = conn;

                connCmd.CommandText = "INSERT INTO info_Tab(userId, passwd, treeNO) VALUES(@userId, @passwd, @treeNO)";
                connCmd.Parameters.Add(new OleDbParameter("@userId", 1));
                connCmd.Parameters.Add(new OleDbParameter("@passwd", 1));
                connCmd.Parameters.Add(new OleDbParameter("@treeNO", 1));
                connCmd.ExecuteNonQuery();    // 입력
               
                connCmd.CommandText = "SELECT * FROM info_Tab";
                OleDbDataReader oleData = connCmd.ExecuteReader(CommandBehavior.CloseConnection);
                while (oleData.Read())
                {
                    Console.WriteLine(oleData["userId"].ToString());
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
            }
            finally
            {
                conn.Close();
            }