通过c#连结oracle数据库(一)

** 所用的工具 ** : 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

{

///

1<summary>
2
3///  Summary description for Form1. 
4
5///  </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;

///

1<summary>
2
3///  Required designer variable. 
4
5///  </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

//

}

///

1<summary>
2
3///  Clean up any resources being used. 
4
5///  </summary>

protected override void Dispose( bool disposing )

{

if ( disposing )

{

if (components != null )

{

components.Dispose();

}

}

base .Dispose( disposing );

}

#region Windows Form Designer generated code

///

1<summary>
2
3///  Required method for Designer support - do not modify 
4
5///  the contents of this method with the code editor.</summary>
Published At
Categories with Web编程
Tagged with
comments powered by Disqus