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