0 - 4 중 3 번째 페이지

ORACLE Connect Sample using DataAdapter without TNS

#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"] + ")" );
			}
		}
	}
}

#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"] + ")" );

}

JET OLEDB Connect Sample using DataAdapter

#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"] + ")" );
			}
		}
	}
}

#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"] + ")" );

}

select 시에 세로행 출력을 가로행 출력으로 변환

출처 : http://bomb.egloos.com/1073673

SELECT
	MAX(DECODE(A, '1', B) as COL1,
	MAX(DECODE(A, '2', B) as COL2,
	MAX(DECODE(A, '3', B) as COL3
FROM
(
	SELECT A, B FROM [table]
)

SELECT

MAX(DECODE(A, '1', B) as COL1,

MAX(DECODE(A, '2', B) as COL2,

MAX(DECODE(A, '3', B) as COL3

FROM

(

SELECT A, B FROM [table]

)

anydragon

참고자료

최신 글

보관함

ORACLE Connect Sample using DataAdapter without TNS

JET OLEDB Connect Sample using DataAdapter

select 시에 세로행 출력을 가로행 출력으로 변환

태그

링크

메타