Oracle数据库安装下载使用https://blog.csdn.net/xiaomanong123/article/details/108518368
Oracle 数据库中独有的类型 varchar2 比varchar多去尾空格
点击查看代码
using Oracle.ManagedDataAccess.Client;
using System.Data;
using System.Net;namespace test3
{public class Class1{static void Main(string[] args){OracleConnection conn = null;try{conn = OpenConn();//这里的查询语句块 会在第一个while 就跳出循环 无论表内有多少行数据 reader.Read()有问题？//var cmd = conn.CreateCommand();//cmd.CommandText = "select EMP_NAME from employees";////cmd.CommandType = CommandType.Text;//var reader = cmd.ExecuteReader();//while (reader.Read())//{// //Console.WriteLine(reader.GetString(0));// Console.WriteLine(string.Format("AwbPre:{0}", reader["EMP_NAME"]));//}//插入语句可以正常执行string sql = "INSERT INTO employees (emp_id, emp_name) VALUES (:值1, :值2)";OracleCommand cmd = new OracleCommand(sql, conn);cmd.Parameters.Add("值1", OracleDbType.Int16).Value = 3;cmd.Parameters.Add("值2", OracleDbType.Varchar2).Value = "John";cmd.ExecuteNonQuery();}catch (Exception ex){Console.WriteLine(ex.Message);}finally{CloseConn(conn);}}static OracleConnection OpenConn(){//使用这种链接oracle数据库方式可以 具体参数参照 tnsnames.oraOracleConnection conn = new OracleConnection();conn.ConnectionString = "Data Source = (DESCRIPTION = " +"(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))" +"(CONNECT_DATA = (SERVICE_NAME = orcl))); " +"Persist Security Info = True; " +//"User ID = system; Password = Oracle123; ";"User ID = C##user1; Password = user1; ";//string conStringUser = "User Id=C##user1" + ";Password=user1" + ";Data Source=" + db + ";";conn.Open();return conn;}static void CloseConn(OracleConnection conn){if (conn == null) return;try{if (conn.State != ConnectionState.Closed){conn.Close();}}catch (Exception ex){Console.WriteLine(ex.Message);}finally{conn.Dispose();}}}
}