C# oracle datagridView Example

1.ODP .NET (Oracle Data Provider for .NET) 드라이버 설치

-"Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio" 패키지 설치(32Bit용)

-참조불로그:http://yaraba.tistory/316

2.ODP.NET Managed 드라이버의 클래스 포함

 -프로젝트>참조>참조추가로 "Oracle.ManagedDataAccess"를 찾아 [확인]으로 추가

3,MS SQL VS Oracle

SqlConnection -> OracleConnection

SqlCommand -> OracleCommand

SqlDbType -> OracleDbType

SqlException -> OracleException

SqlDataReader -> OracleDataReader

샘플코드

using Oracle.ManagedDataAccess.Client;

using Oracle.ManagedDataAccess.Types; 

public void read()

    {

        try

        {

            using(OracleConnection conn = new OracleConnection("....."))

            using(OracleCommand cmd = new OracleCommand("select * from t1", conn))

            {

                conn.Open();

                using(OracleDataReader reader = cmd.ExecuteReader())

                {

                     DataTable dataTable = new DataTable();

                     dataTable.Load(reader);

                     dataGridView1.DataSource = dataTable;

                }

            }

        }

        catch (Exception ex)

        {

            MessageBox.Show(ex.Message);

        }

    }

 }