1.新建文件夹DLL将Oracle.ManagedDataAccess的dll文件放到该文件下
2.添加对该dll的引用
引用-》右键-》添加引用-》浏览-(找到你项目下存放DLL路径下的Oracle.ManagedDataAccess.dll)-》添加
3.写一个连接oracle数据库的类MyOracleConnect.cs
class MyOracleConnect
{
private OracleConnection conn = null;
public void getConn()
{
string connString = "Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ATEST)));Persist Security Info=True;User ID=system;Password=123456;";
conn = new OracleConnection(connString);
if(conn!=null)
{
try
{
conn.Open();
Console.WriteLine("数据库连接成功");
}
catch(System.Exception ex)
{
Console.WriteLine(ex.Message);
}
}
}
public void CloseConn()
{
if(conn!=null&&conn.State==ConnectionState.Open)
{
conn.Close();
conn = null;
}
}
public DataTable getSelect(string selectstring)
{
getConn();
string sql = selectstring;
OracleCommand command = new OracleCommand(sql, conn);
OracleDataAdapter oda = new OracleDataAdapter(command);
DataTable datatable = new DataTable();
oda.Fill(datatable);
CloseConn();
return datatable;
}
}
}
4.连接与查询
在你的后台MainWindow.xaml.cs代码中,点击前台确定按钮事件代码中写入读取数据库的操作
string ss = “select * from usertable where u_name=’” + this.txtUsername.Text + “’”;
MyOracleConnect myo = new MyOracleConnect();
DataTable table = myo.getSelect(ss);
具体每一步什么意思可以自己看代码
我的数据库是建的一个usertable的表
create table USERTABLE
(
u_id NUMBER not null,
u_name VARCHAR2(20) not null,
u_password VARCHAR2(20)
primary key (u_id)
)
nologging
tablespace DATA_TEST
/
5.源代码
获得源代码