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)

#region Using directives

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Windows.Forms;

#endregion

namespace UsingADOManagedProvider
{
   partial class ADONetForm1 : Form
   {
      public ADONetForm1( )
      {
         InitializeComponent( );
         // connect to Northwind Access database
         string connectionString = "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 =";

         // get records from the customers table
         string commandString = "Select CompanyName, ContactName from Customers";

         // create the data set command object 
         // and the DataSet

         OleDbDataAdapter DataAdapter = new OleDbDataAdapter( commandString, connectionString );

         DataSet DataSet = new DataSet( );

         // fill the data set object
         DataAdapter.Fill( DataSet, "Customers" );

         // Get the one table from the DataSet
         DataTable dataTable = DataSet.Tables[0];

         // for each row in the table, display the info
         foreach ( DataRow dataRow in dataTable.Rows )
         {
            lbCustomers.Items.Add( dataRow["CompanyName"] + " (" + dataRow["ContactName"] + ")" );
         }
      }
   }
}

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

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

(0) (0)

#region Using directives

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Windows.Forms;

#endregion

namespace UsingADOManagedProvider
{
   partial class ADONetForm1 : Form
   {
      public ADONetForm1( )
      {
         InitializeComponent( );

         // connect to Northwind Access database
         string connectionString = "provider=Microsoft.JET.OLEDB.4.0; " + "data source = c:\\nwind.mdb";

         // get records from the customers table
         string commandString = "Select CompanyName, ContactName from Customers";

         // create the data set command object 
         // and the DataSet

         OleDbDataAdapter DataAdapter = new OleDbDataAdapter( commandString, connectionString );

         DataSet DataSet = new DataSet( );

         // fill the data set object
         DataAdapter.Fill( DataSet, "Customers" );

         // Get the one table from the DataSet
         DataTable dataTable = DataSet.Tables[0];

         // for each row in the table, display the info
         foreach ( DataRow dataRow in dataTable.Rows )
         {
            lbCustomers.Items.Add( dataRow["CompanyName"] + " (" + dataRow "ContactName"] + ")" );
         }
      }
   }
}

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

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

(0) (0)