C连接oracle数据库执行简单的增删改查操作.docVIP

以users表为例，有三个字段，自增长的编号id，int类型；名称name，nvarchar类型，密码pwd，nvarchar类型 首先在vs2005中引入System.Data.OracleClient;命名空间/// summary /// 增加 /// /summary /// param name=name姓名/param /// param name=pwd密码/param /// returns/returns public int Insert(string name, string pwd) { OracleConnection conn = new OracleConnection(@Data Source=SBZX;User ID=simis;Password=zeda);//Data Source后面跟你数据库的名字，User ID为用户名，Password为密码 conn.Open(); string sql = insert into users(name,pwd) values(:name,:pwd); OracleCommand cmd = new OracleCommand(sql, conn); OracleParameter parn = new OracleParameter(:name, name); cmd.Parameters.Add(parn); OracleParameter parp = new OracleParameter(:pwd, name); cmd.Parameters.Add(parp); int result = cmd.ExecuteNonQuery();//result接收受影响行数，也就是说result大于0的话表示添加成功 conn.Close(); cmd.Dispose(); return result; } /// summary /// 删除 /// /summary /// param name=name姓名/param /// param name=pwd密码/param /// returns/returns public int Update(int id) { OracleConnection conn = new OracleConnection(@Data Source=SBZX;User ID=simis;Password=zeda);//Data Source后面跟你数据库的名字，User ID为用户名，Password为密码 conn.Open(); string sql = delete from users where id=:id; OracleCommand cmd = new OracleCommand(sql, conn); OracleParameter pari = new OracleParameter(:id, id); cmd.Parameters.Add(pari); int result = cmd.ExecuteNonQuery();//result接收受影响行数，也就是说result大于0的话表示添加成功 conn.Close(); cmd.Dispose(); return result; } /// summary /// 修改 /// /summary /// param name=name姓名/param /// param name=pwd密码/param /// returns/returns public int Insert(str