连接串:Data Source=xxx; User Id=scott; Password=tiger; 使用OracleCommandusing System; using System.Collections.Generic; using System.Text; using System.Data; using System.Data.OracleClient; class OracleAdapter { public OracleAdapter(string connectString) { command = new OracleCommand(); command.Connection = new OracleConnection(connectString); } protected OracleCommand command; public void addParameter(string name, object value) { command.Parameters.Add(new OracleParameter(name, value)); } public DataSet query(string sql) { command.Connection.Open(); command.CommandText = sql; OracleDataAdapter adapter = new OracleDataAdapter(command); DataSet set = new DataSet(); adapter.Fill(set); command.Connection.Close(); return set; }
{
String retString = String.Empty;
string[] objects = new string[] { asServer, asDBUser, asDBUserPassword, asDBParam };
retString = String.Format("Data Source={0};User ID={1};Password={2};{3}", objects);
return retString;
}
public bool UpdateByDataTable(DataTable adtDestination, string asSql)
{
ClearLastError();
using (OracleConnection conn = new OracleConnection(ConnectString))
{
try
{
conn.Open();
OracleCommand comm = conn.CreateCommand();
comm.CommandText = asSql;
comm.CommandType = CommandType.Text;
OracleDataAdapter data = new OracleDataAdapter(comm);
OracleCommandBuilder builder = new OracleCommandBuilder(data); data.Update(adtDestination);
}
catch (Exception ex)
{
HasException(ex, null);
}
}
return IsSafe;
}
cn.ConnectionString="Data Source=ora9i;Persist Security Info=True;User ID=kqin;Password=kqin116;Unicode=True;Provider=MSDAORA.1";
我用的是这种给我指正一下吧
使用OracleCommandusing System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OracleClient;
class OracleAdapter {
public OracleAdapter(string connectString)
{
command = new OracleCommand();
command.Connection = new OracleConnection(connectString);
} protected OracleCommand command; public void addParameter(string name, object value)
{
command.Parameters.Add(new OracleParameter(name, value));
} public DataSet query(string sql)
{
command.Connection.Open();
command.CommandText = sql;
OracleDataAdapter adapter = new OracleDataAdapter(command);
DataSet set = new DataSet();
adapter.Fill(set); command.Connection.Close();
return set;
}
public void insert(string sql)
{
...
}
}
}
这个类在我的2003中没有啊
OleDbConnection cn=new OleDbConnection();
cn.ConnectionString="Data Source=ora9i;Persist Security Info=True;User ID=kqin;Password=kqin116;Unicode=True;Provider=MSDAORA.1";
string wname=this.TextBoxName.Text;
string wuri=this.TextBoxURI.Text;
string wpro=TextBoxPro.Text;
string sql = "insert into WZXXB(wzmc,wzdz,wzsm) values('" + wname + "','" + wuri + "','" + wpro + "')";
OleDbCommand cmd = new OleDbCommand(sql, cn);
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
throw new Exception(ex.Message);
}
我本来想贴图片上来的但是贴不了只能告诉你步骤了
选中你的项目点添加引用在.net一项中将你的System.Data.OracleClient就不会报缺少引用的错误了
注意:VS2003下要使用Oracle9i时,需要修改一下Oracle/Bin目录下的权限,否则是会报错的。
OleDbConnection cn=new OleDbConnection();
cn.ConnectionString="Data Source==(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.68.239.234)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=ora9i))) ;Persist Security Info=True;User ID=scott;Password=tiger;Unicode=True;Provider=MSDAORA.1";
cn.Open();