.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();
}
}
}
郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。