| 网站首页 | 行业资讯 | 操作系统 | 网络技术 | 网页设计 | 平面设计 | 媒体制作 | 编程开发 | 
 | 办公软件 | 网络安全 | 电脑技术 | 数 据 库 | 课程在线 | 成功案例 | 项目合作 | 团队简介 | 
蓝色极速感谢大家的支持!站长:干戈 QQ:495979847     IAS网上答疑系统V1.0发布  [Sunpeople  2007年9月15日]        
  您现在的位置: 蓝色极速 >> 网络技术 >> ASP.NET >> 教程正文
 

首页所应该达到的几个…

          ★★★ 
通过c#连结oracle数据库(一)
作者:佚名    教程来源:编程学习    点击数:    更新时间:2007-5-10    

所用的工具:vs.net beta2 ,orcale8

 

步骤

     1 在数据库中建一个Emp表,然后在其中加入EmpNo, EName, Sal, DeptNo四个字段。

     2 打开vs.net beta2 创建一个c#工程-àwindows应用程序。对照以下代码:

using System;

using System.Drawing;

using System.Collections;

using System.ComponentModel;

using System.Windows.Forms;

using System.Data;

using System.Data.OleDb;

namespace Employee

{

/// <summary>

/// Summary description for Form1.

/// </summary>

public class FrmEmp : System.Windows.Forms.Form

{

private System.Windows.Forms.Label label1;

private System.Windows.Forms.Label label2;

private System.Windows.Forms.Label label3;

private System.Windows.Forms.Label label4;

private System.Windows.Forms.TextBox TxtEmpNo;

private System.Windows.Forms.TextBox TxtEName;

private System.Windows.Forms.TextBox TxtESal;

private System.Windows.Forms.TextBox TxtDeptNo;

private System.Windows.Forms.Button BtnAddNew;

private System.Windows.Forms.Button BtnSave;

private System.Windows.Forms.Button BtnDelete;

private System.Windows.Forms.Button BtnExit;

private System.Data.OleDb.OleDbConnection Conn;

private System.Data.OleDb.OleDbCommand Comm;

private System.Data.OleDb.OleDbDataAdapter DataAdpt;

private System.Data.OleDb.OleDbCommandBuilder CBuild;

private System.Data.OleDb.OleDbDataReader DtRead;

private System.Data.DataSet DataSet1;

private System.Data.DataRow DataRow1;

private System.Data.DataTable DataTable1;

private string ConnStr;

private bool blnEdit;

private System.Windows.Forms.Button BtnEdit;

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.Container components = null;

public FrmEmp()

{

//

// Required for Windows Form Designer support

//

InitializeComponent();

ConnStr = "Provider=MSDAORA;DSN=oracle;User ID=system;Password=manager";

Conn = new OleDbConnection(ConnStr);

Conn.Open();

 

DataAdpt = new OleDbDataAdapter("Select * from Emp",Conn);

CBuild = new OleDbCommandBuilder(DataAdpt);

DataSet1 = new DataSet("Emp");

DataTable1 = new DataTable("Emp");

DataAdpt.Fill(DataSet1,"Emp");

//

// TODO: Add any constructor code after InitializeComponent call

//

}

/// <summary>

/// Clean up any resources being used.

/// </summary>

protected override void Dispose( bool disposing )

{

if( disposing )

{

if (components != null)

{

components.Dispose();

}

}

base.Dispose( disposing );

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

教程录入:Sunpeople    责任编辑:Sunpeople  
  • 上一个教程:

  • 下一个教程: 没有了

  •      
    点击申请点击申请点击申请点击申请点击申请点击申请点击申请
    | 设为首页 | 加入收藏 | 联系站长 | 友情链接 | 版权申明 |

    Copyright(C)2006-2009 Exploit Team All Rights Reserved
    QQ:495979847 网络备案号:陇ICP备07001585号