求c#登录的代码，连得是Oracle数据库，编译环境是vs2008

来源：百度知道 编辑：UC知道 时间：2024/05/10 14:57:15
注册地可用，登录部分总是出问题。麻烦各位大侠帮我查查错误，或者提供一段代码也行。
错误提示：找不到类型或命名空间名称“SqlConnection”(是否缺少 using 指令或程序集引用?)————这里应该添加什么引用？

代码如下
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.OracleClient;
//using SqlConnection conn = new SqlConnection();

public partial class 注册登录 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void Button1_Click(object sender, EventArgs e)
{
if (DropDownList1.Text=="作者")
SqlDataSource1.Insert();
if (DropDownList1.Text == "专家")

protected void Button2_Click(object sender, EventArgs e)
{
if (DropDownList1.Text == "作者")
{

OracleConnection conn = new OracleConnection();
conn.ConnectionString = "Data Source=works;User ID=works;Password=password;Unicode=True";
string sql = "select * from [author] where aname='" + TextBoxName.Text + "' and apassword='" + TextBoxPassword.Text + "'";
OracleCommand cmd = new OracleCommand(sql, conn);
OracleDataReader dr = null;
conn.Open();
dr = cmd.ExecuteReader();
if (dr.Read())
{
Session["aname"] = dr["aname"].ToString();
Session["apassword"] = dr["sapassword"].ToString