.NET WIN7 64位 连接Oracle数据库

来源:互联网 发布:上海交通事故数据统计 编辑:程序博客网 时间:2024/05/21 12:44
先右击项目,添加引用。COM选项卡下搜System.Data.OracleClient这个。引用到项目里。
如果下方代码报ORA-06413连接未打开的错误。请参考我上篇日志
using System;using System.Collections.Generic;using System.Web;using System.Web.UI;using Microsoft.VisualBasic;using Microsoft.VisualBasic.CompilerServices;using EIPWebService.Entity;using System.Data;using System.Data.SqlClient;using ADODB;using EIPWebService.DAL;using System.Data.OracleClient;namespace EIPWebService{    public partial class WebForm1 : System.Web.UI.Page    {        protected void Page_Load(object sender, EventArgs e)        {            string oradb = "Data Source=(DESCRIPTION="           + "(ADDRESS=(PROTOCOL=TCP)(HOST=数据库IP地址)(PORT=1521))"           + "(CONNECT_DATA=(SERVICE_NAME=数据源服务名)));"           + "User Id=数据库登录名;Password=密码;";            OracleConnection conn = new OracleConnection(oradb);            //OracleConnection conn = new OracleConnection();             conn.ConnectionString = oradb;            conn.Open();            string sql = " select * from 表名 where 列名 ='10000' ";             OracleCommand cmd = new OracleCommand(sql, conn);            cmd.CommandType = CommandType.Text;            OracleDataReader dr = cmd.ExecuteReader(); // C#            dr.Read();            string aa = dr["字段名"].ToString();            conn.Close();   // C#            conn.Dispose(); // C#            Response.Write(aa);        }           }}


0 0
原创粉丝点击