.NET代码——.NET 连接oracle
来源:互联网 发布:呼格案 知乎 编辑:程序博客网 时间:2024/04/29 18:06
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"); }}
0 0
- .NET代码——.NET 连接oracle
- .Net连接Oracle数据库的实现代码
- .Net连接Oracle数据库的实现代码
- .NET—Spring.NET连接Oracle数据库异常
- .net连接oracle
- ASP.NET连接Oracle
- .NET Oracle连接字符串
- .net连接oracle数据库
- asp.net连接oracle
- .net连接oracle
- .net连接oracle数据库
- .net 连接oracle
- ASP.NET连接ORACLE
- .net 连接 oracle...
- asp.net连接oracle
- .net 连接oracle数据库
- .net连接oracle数据库
- net连接oracle数据库
- HDU 3507 Print Article (斜率优化DP)
- hdu-5313 Bipartite Graph
- 多校 hdu
- PAT (Advanced Level) 1080. Graduate Admission (30) 模拟高考录取,结构体排序
- Oracle GoldenGate快速入门教程:基本概念和配置
- .NET代码——.NET 连接oracle
- visual studio 2005 窗体控件不能拖动解决方案
- 标题栏出现“#”
- Centos7.1 安装Sqlite3
- JS代码——如何区分IE6,IE7,IE8浏览器
- Java正则表达式判断邮箱地址数组,冒泡排序,String的方法
- 诸葛亮《诫子书》
- spoj Goblin Wars(简单bfs)
- STATIC_DRAW, DYNAMIC_DRAW, STREAM_DRAW的区别