private OleDbDataReader rd;
private OleDbConnection Conn;
private string strRet;
private OleDbCommand cmd;
private StringBuilder sbSQL;
private OleDbParameter paramnSeq;

try
{
    // SQLOLEDB MSDAORA
    Conn = new OleDbConnection("Provider=MSDAORA;Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.xxx )(PORT = 1521)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = GROUP))); User Id =; Password =;");
    Conn.Open();

    try
    {
        sbSQL = new StringBuilder();

        sbSQL.Append(" SELECT *                             ");
        sbSQL.Append(" FROM   HEIS_CUSTOMER                 ");
        sbSQL.Append(" WHERE  1=1                           ");
        sbSQL.Append(" AND    CUSTOMER_CODE = ?             ");

        paramnSeq = new OleDbParameter("CUSTOMER_CODE", OleDbType.Char, 4);
        paramnSeq.Value = "0003";

        cmd = new OleDbCommand(sbSQL.ToString(), Conn);
        cmd.Parameters.Add(paramnSeq);

        rd = cmd.ExecuteReader();

        if (rd.Read())
        {
            strRet = rd["CUSTOMER_CODE"].ToString();
        }
        else
        {
            strRet = "";
        }
    }
    catch (System.Exception e1)
    {
        throw e1;
    }
    finally
    {
        rd.Close();
    }
}
catch (System.Exception e2)
{
    throw e2;
}
finally
{
    Conn.Close();
}

크리에이티브 커먼즈 라이센스

이 저작물은 크리에이티브 커먼즈 코리아 저작자표시-비영리-변경금지 2.0 대한민국 라이센스에 따라 이용하실 수 있습니다.

(0) (0)