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