Oracle连接net,.NET 连接oracle

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.OracleClient;

public partial class Default2 : System.Web.UI.Page

{

protected void Page_Load(object sender,EventArgs e)

{

}

protected void add_record_Click(object sender,EventArgs e)

{

string strSTOREROOM_ID = this.STOREROOM_ID.Text.Trim();

string strSTOREROOM_LOCATION = this.STOREROOM_LOCATION.Text.Trim();

string strSTOREROOM_HIGHTEMPERATURE = this.STOREROOM_HIGHTEMPERATURE.Text.Trim();

string strSTOREROOM_LOWTEMPERATURE = this.STOREROOM_LOWTEMPERATURE.Text.Trim();

string strSTOREROOM_HIGHHUMIDITY = this.STOREROOM_HIGHHUMIDITY.Text.Trim();

string strSTOREROOM_LOWHUMIDITY = this.STOREROOM_LOWHUMIDITY.Text.Trim();

string connestr = "Data Source=ORCL;Persist Security Info=True;User ID=EIPAPP;Password=eipapp;Unicode=True";

OracleConnection connection = new OracleConnection(connestr);

OracleCommand command = new OracleCommand();

string insertstr = "insert into T_STOREROOM_STAKEOUT "+

"(STOREROOM_ID,STOREROOM_LOCATION,STOREROOM_HIGHTEMPERATURE,STOREROOM_LOWTEMPERATURE,STOREROOM_HIGHHUMIDITY,STOREROOM_LOWHUMIDITY) "+

"values(" + Convert.ToInt32(strSTOREROOM_ID) + ",'" +

strSTOREROOM_LOCATION.ToString() + "'," +

Convert.ToInt32(strSTOREROOM_HIGHTEMPERATURE) + "," +

Convert.ToInt32(strSTOREROOM_LOWTEMPERATURE) + "," +

Convert.ToInt32(strSTOREROOM_HIGHHUMIDITY) + "," +

Convert.ToInt32(strSTOREROOM_LOWHUMIDITY) + ")";

command.Connection = connection;

command.CommandText = insertstr;

command.Connection.Open();

command.ExecuteNonQuery();

Response.Redirect("Default.aspx");

}

}

总结

以上是编程之家为你收集整理的.NET 连接oracle全部内容，希望文章能够帮你解决.NET 连接oracle所遇到的程序开发问题。

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。