#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 (JET OLEDB)
string connectionString = "provider=Microsoft.JET.OLEDB.4.0; " + "data source = c:\\nwind.mdb";
// ORACLE 에 TNS 없이 연결할 때는 연결 문자열만 아래로 바꾸면 된다
// 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"] + ")" );
}
}
}
}
