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 ;
}
}
}