oracle数据库连接写法,.Net 连接Oracle 数据库写法

using System;

using System.Collections.Generic;

using

System.ComponentModel;

using System.Data;

using System.Drawing;

using

System.Linq;

using System.Text;

using System.Windows.Forms;

using

Oracle.DataAccess.Client;

namespace OracleDataAccess

{

public partial class

Form1 : Form

{

public

Form1()

{

InitializeComponent();

}

private void button1_Click(object

sender, EventArgs e)

{

OracleConnection connection = new OracleConnection("Data Source=orcl;User

ID=uqbuy;Password=root");

connection.Open();

OracleCommand cmd = new OracleCommand("select * from test") { Connection =

connection, ArrayBindCount = 10 };

OracleDataAdapter adapter = new

OracleDataAdapter(cmd);

DataTable dt = new

DataTable();

adapter.Fill(dt);

connection.Close();

}

}

}

原文：http://www.cnblogs.com/yexinw/p/3532065.html