//ASP.NET操作ORACLE事例
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
namespace OracleTemp
{
    /// <summary>
    /// WebForm1 的摘要说明。
    /// </summary>
    public class WebForm1 : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.DataGrid DataGrid1;
        protected System.Web.UI.WebControls.Button btnAdd;
        protected System.Web.UI.WebControls.Button btnDelete;
        protected System.Web.UI.WebControls.Button btnUpDate;
        protected System.Web.UI.WebControls.Button btnNew;
        protected System.Web.UI.WebControls.Label Label1;
        protected System.Web.UI.WebControls.TextBox txtID;
        protected System.Web.UI.WebControls.Button btnQuery;
        protected System.Web.UI.WebControls.TextBox txtName;
        protected System.Web.UI.WebControls.Label Label2;
        OracleConnection OracleConn;        private void Page_Load(object sender, System.EventArgs e)
        {
            // 在此处放置用户代码以初始化页面
            if(!Page.IsPostBack)
            {
                DisplayEmp();
            }
        }
        private void OpenOracleDataBase()
        {
            string strConn=System.Configuration.ConfigurationSettings.AppSettings["ORACLE_CONNECTIONSTRING"].ToString();
            OracleConn=new OracleConnection(strConn);
            OracleConn.Open();
        }
        private void CloseOracleDataBase()
        {
            OracleConn.Close();
        }
        private void DisplayEmp()
        {
            OpenOracleDataBase();
            string strSql="select empno as 员工编号,ename as 姓名,job as 工作 from emp";
            OracleCommand ocomm=new OracleCommand(strSql,OracleConn);
            DataGrid1.DataSource=ocomm.ExecuteReader();
            DataGrid1.DataBind();
            CloseOracleDataBase();
        }        private void OracleData(string strSql)
        {
            OpenOracleDataBase();
            OracleCommand OracleCmd=new OracleCommand("",OracleConn);
            OracleCmd.CommandText=strSql;
            OracleCmd.ExecuteNonQuery();
            CloseOracleDataBase();
        }        private void btnAdd_Click(object sender, System.EventArgs e)
        {
            string strInset="insert into emp values(7777,'郝东','PG',7789,'23-1月 -82',3500,12,10)";
            OracleData(strInset);
        }        private void btnNew_Click(object sender, System.EventArgs e)
        {
            DisplayEmp();
        }        private void btnDelete_Click(object sender, System.EventArgs e)
        {
            string strDelete="delete emp where empno=7777";
            OracleData(strDelete);
        }        private void btnUpDate_Click(object sender, System.EventArgs e)
        {
            string strUpDate="update emp set ename='郝凌平' where empno=7777";
            OracleData(strUpDate);
        }        private void btnQuery_Click(object sender, System.EventArgs e)
        {
            OracleDataReader odrTemp;
            OpenOracleDataBase();
            OracleCommand ocmdTemp=new OracleCommand("select ename from emp where empno="+Convert.ToInt32(txtID.Text.Trim())+"",OracleConn);
            odrTemp=ocmdTemp.ExecuteReader();
            while(odrTemp.Read())
            {
                txtName.Text=odrTemp.GetString(0);
            }
            CloseOracleDataBase();
        }
    }
}
/////////////////////////////
web.config配置
<configuration>
<appSettings>
<add key="ORACLE_CONNECTIONSTRING" value="Data Source=dlq;User Id=scott;Password=tiger;Max Pool Size = 512;"/>
</appSettings>
代码是连接ORACLE的,跟SQL没多大差别,将主见全改成SQL的就行了