1：首先在web配置文件对连接字符串进行配置
<connectionStrings>
<add name="conStr" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)
(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=orcl)));User ID=admin1;Password=admin1"/>
</connectionStrings>
2：添加在项目里添加引用oracle的dll文件
3：在后台的命名空添加using System.Data.OracleClient;另外还得添加命名空间using System.Configuration;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OracleClient;
using System.Configuration;
using System.Data;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ShowData();//调用自定义的函数
}
}
private void ShowData()
{
#region//主要练习用using语句连接oracle数据
string strCon = ConfigurationManager.ConnectionStrings["conStr"].ToString();
try
{
using (OracleConnection con = new OracleConnection(strCon))
{
con.Open();
string sql = "select * from Student";
using (OracleCommand cmd = new OracleCommand(sql, con))
{
using (OracleDataAdapter da = new OracleDataAdapter(cmd))
{
DataTable dt = new DataTable();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
}
}
catch (OracleException ex)
{
Response.Write("<script>alert('数据库出现异常')</script>"+ex.Message);
}
#endregion
}
}
4:调试代码结果
