.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();
}
}
}

巴特西

.Net 连接Oracle 数据库写法

最新文章

热门文章