1.将oci.dll、orannzsbb11.dll、oraocci11.dll、oraociei11.dll放入到vs安装目录Visual Studio 2005\Projects\项目名称\bin\Debug下
2.创建链接
String constring = "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=服务器的ip) (PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=数据库名)));Persist Security Info=True;User Id=用户名; Password=密码";
OracleConnection conn = new OracleConnection(constring);
查找:
public static void find(){
conn.Open();//打开指定的连接
OracleCommand com = conn.CreateCommand();
com.CommandText = "Select * From student ";//写好想执行的Sql语句
OracleDataReader odr = com.ExecuteReader();
while (odr.Read())//读取数据,如果返回为false的话,就说明到记录集的尾部了
{
Console.WriteLine(odr.GetOracleNumber(0));
Console.WriteLine(odr.GetOracleString(1).ToString() );
Console.WriteLine(odr.GetOracleString(2).ToString());
}
odr.Close();//关闭reader.这是一定要写的
}
插入:
public static void insert(string name,string pwd)
{
conn.Open();//打开指定的连接
OracleCommand com = conn.CreateCommand();
com.CommandText = "insert into student(name,pwd)values(:name,pwd;) ";//写好想执行的Sql语句
OracleParameter param1 = new OracleParameter(":name",name);
OracleParameter param2 = new OracleParameter(":pwd",pwd);
com.Parameters.Add(param1);
com.Parameters.Add(param2);
int result = com.ExecuteNonQuery();
Console.WriteLine("result:"+result);
conn.Close();//关闭打开的连接
}