.net 连接ORACLE 数据库
1.安装ORACLE客户端9,修改C:\Oracle\ora90\network\ADMIN下的tnsnames.ora文件为:
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
dpas =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.70)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
# Generated by Oracle configuration tools.
dpas =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.70)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
2.在解决方案资源管理器中,右击引用->添加引用->浏览->选择System.Data.OracleClient.dll->确定,然后using System.Data.OracleClient。 下载
3.在web.config中加入:
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=dpas;User ID=dpas;Password=dpas;Unicode=True" providerName="System.Data.OracleClient"/>
</connectionStrings>
<add name="ConnectionString" connectionString="Data Source=dpas;User ID=dpas;Password=dpas;Unicode=True" providerName="System.Data.OracleClient"/>
</connectionStrings>
4. 后台代码:
using System.Data.OracleClient; //要引用的类库
public partial class Demo3 : System.Web.UI.Page
{
public System.Data.OracleClient.OracleConnection objConn; //声明一个OracleConnection对象
public System.Data.OracleClient.OracleCommand objCmd; //声明一个OracleCommand对象
public System.Data.OracleClient.OracleDataAdapter objAdp; //数据库适配器
public System.Data.DataSet dset; //DataSet 用于数据填充
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = "";
string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
objConn = new OracleConnection(strconn);
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
try
{
string StrSql = "select * from DPA";
objConn.Open();
objCmd = new OracleCommand(StrSql, objConn);
objAdp = new OracleDataAdapter(objCmd);
dset = new DataSet();
objAdp.Fill(dset);
objConn.Close();
GridView1.DataSource = dset;
GridView1.DataBind();
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
return;
}
}
}
public partial class Demo3 : System.Web.UI.Page
{
public System.Data.OracleClient.OracleConnection objConn; //声明一个OracleConnection对象
public System.Data.OracleClient.OracleCommand objCmd; //声明一个OracleCommand对象
public System.Data.OracleClient.OracleDataAdapter objAdp; //数据库适配器
public System.Data.DataSet dset; //DataSet 用于数据填充
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = "";
string strconn = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
objConn = new OracleConnection(strconn);
}
protected void Btn_Search_Click(object sender, EventArgs e)
{
try
{
string StrSql = "select * from DPA";
objConn.Open();
objCmd = new OracleCommand(StrSql, objConn);
objAdp = new OracleDataAdapter(objCmd);
dset = new DataSet();
objAdp.Fill(dset);
objConn.Close();
GridView1.DataSource = dset;
GridView1.DataBind();
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
return;
}
}
}