C#连接Oracle数据库

来源：互联网发布：淘宝直播开播入口编辑：程序博客网时间：2024/05/19 12:15

http://blog.csdn.net/gyming/article/details/17143153

C#连接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 System.Data.OleDb;namespace WindowsFormsApplication1{    public partial class Form1 : Form    {        public Form1()        {            InitializeComponent();        }        private void button1_Click(object sender, EventArgs e)        {            DataTable sdt = new DataTable();            //OleDbConnection con = new OleDbConnection(string.Format("Provider=MSDAORA;Data Source={0};User ID={1};Password={2};", "ORCL", "satbusiness", "satbusiness"));            //OleDbConnection con = new OleDbConnection(string.Format("Provider=MSDAORA.1;Data Source={0};User ID={1};Password={2};", "ORCL", "satbusiness", "satbusiness"));            //上面2种为 Microsoft公司提供的OleDB驱动，Provider需要根据实际情况修改，只支持32bit.            //OleDbConnection con = new OleDbConnection(string.Format("Provider=OraOLEDB.Oracle;Persist Security Info=False;Data Source={0};User ID={1};Password={2};", "ORCL", "satbusiness", "satbusiness"));            OleDbConnection con = new OleDbConnection(string.Format("Provider=OraOLEDB.Oracle.1;Persist Security Info=False;Data Source={0};User ID={1};Password={2};", "ORCL", "satbusiness", "satbusiness"));            //上面2种为 OleDB连接驱动OraOLEDB.Oracle，Oracle公司提供的OleDB驱动，Provider需要根据实际情况修改,支持32bit与64bit,需要安装Oracle Data Provider for OLE DB（我在电脑上面只是安装了ORACLE就可以了）            OleDbCommand com = new OleDbCommand("select * from sa_ljt1", con);            OleDbDataAdapter ap = new OleDbDataAdapter(com);            ap.Fill(sdt);            dataGridView1.DataSource = sdt;// private System.Windows.Forms.DataGridView dataGridView1;        }    }}

在此只做一个示例，连接上数据库即可。不做其它讨论。

0 0