winform.pas.~1~

《Delphi 2005程序设计及其应用开发》源代码

unit WinForm;

interface

uses
  System.Drawing, System.Collections, System.ComponentModel,
  System.Windows.Forms, System.Data, Borland.Data.Provider, Borland.Data.Common, 
  DataSet1Unit, System.Globalization;

type
  TWinForm = class(System.Windows.Forms.Form)
  {$REGION 'Designer Managed Code'}
  strict private
    /// <summary>
    /// Required designer variable.
    /// </summary>
    Components: System.ComponentModel.Container;
    BdpConnection1: Borland.Data.Provider.BdpConnection;
    bdpSelectCommand1: Borland.Data.Provider.BdpCommand;
    bdpInsertCommand1: Borland.Data.Provider.BdpCommand;
    bdpUpdateCommand1: Borland.Data.Provider.BdpCommand;
    bdpDeleteCommand1: Borland.Data.Provider.BdpCommand;
    bdpSelectCommand2: Borland.Data.Provider.BdpCommand;
    bdpInsertCommand2: Borland.Data.Provider.BdpCommand;
    bdpUpdateCommand2: Borland.Data.Provider.BdpCommand;
    bdpDeleteCommand2: Borland.Data.Provider.BdpCommand;
    DataGrid1: System.Windows.Forms.DataGrid;
    DataGrid2: System.Windows.Forms.DataGrid;
    CategoryAdapter: Borland.Data.Provider.BdpDataAdapter;
    ProductAdapter: Borland.Data.Provider.BdpDataAdapter;
    DataSet11: DataSet1Unit.DataSet1;
    /// <summary>
    /// Required method for Designer support - do not modify
    /// the contents of this method with the code editor.
    /// </summary>
    procedure InitializeComponent;
    procedure TWinForm_Load(sender: System.Object; e: System.EventArgs);
  {$ENDREGION}
  strict protected
    /// <summary>
    /// Clean up any resources being used.
    /// </summary>
    procedure Dispose(Disposing: Boolean); override;
  private
    { Private Declarations }
  public
    constructor Create;
  end;

  [assembly: RuntimeRequiredAttribute(TypeOf(TWinForm))]

implementation

{$REGION 'Windows Form Designer generated code'}
/// <summary>
/// Required method for Designer support -- do not modify
/// the contents of this method with the code editor.
/// </summary>
procedure TWinForm.InitializeComponent;
begin
  Self.DataGrid1 := System.Windows.Forms.DataGrid.Create;
  Self.DataGrid2 := System.Windows.Forms.DataGrid.Create;
  Self.DataSet11 := DataSet1Unit.DataSet1.Create;
  Self.BdpConnection1 := Borland.Data.Provider.BdpConnection.Create;
  Self.CategoryAdapter := Borland.Data.Provider.BdpDataAdapter.Create;
  Self.bdpDeleteCommand1 := Borland.Data.Provider.BdpCommand.Create;
  Self.bdpInsertCommand1 := Borland.Data.Provider.BdpCommand.Create;
  Self.bdpSelectCommand1 := Borland.Data.Provider.BdpCommand.Create;
  Self.bdpUpdateCommand1 := Borland.Data.Provider.BdpCommand.Create;
  Self.ProductAdapter := Borland.Data.Provider.BdpDataAdapter.Create;
  Self.bdpDeleteCommand2 := Borland.Data.Provider.BdpCommand.Create;
  Self.bdpInsertCommand2 := Borland.Data.Provider.BdpCommand.Create;
  Self.bdpSelectCommand2 := Borland.Data.Provider.BdpCommand.Create;
  Self.bdpUpdateCommand2 := Borland.Data.Provider.BdpCommand.Create;
  (System.ComponentModel.ISupportInitialize(Self.DataGrid1)).BeginInit;
  (System.ComponentModel.ISupportInitialize(Self.DataGrid2)).BeginInit;
  (System.ComponentModel.ISupportInitialize(Self.DataSet11)).BeginInit;
  (System.ComponentModel.ISupportInitialize(Self.CategoryAdapter)).BeginInit;
  (System.ComponentModel.ISupportInitialize(Self.ProductAdapter)).BeginInit;
  Self.SuspendLayout;
  // 
  // DataGrid1
  // 
  Self.DataGrid1.CaptionText := 'Customers';
  Self.DataGrid1.DataMember := '';
  Self.DataGrid1.HeaderForeColor := System.Drawing.SystemColors.ControlText;
  Self.DataGrid1.Location := System.Drawing.Point.Create(8, 8);
  Self.DataGrid1.Name := 'DataGrid1';
  Self.DataGrid1.Size := System.Drawing.Size.Create(448, 184);
  Self.DataGrid1.TabIndex := 0;
  // 
  // DataGrid2
  // 
  Self.DataGrid2.CaptionText := 'Ouders';
  Self.DataGrid2.DataMember := '';
  Self.DataGrid2.HeaderForeColor := System.Drawing.SystemColors.ControlText;
  Self.DataGrid2.Location := System.Drawing.Point.Create(8, 200);
  Self.DataGrid2.Name := 'DataGrid2';
  Self.DataGrid2.Size := System.Drawing.Size.Create(448, 168);
  Self.DataGrid2.TabIndex := 1;
  // 
  // DataSet11
  // 
  Self.DataSet11.DataSetName := 'DataSet1';
  Self.DataSet11.Locale := System.Globalization.CultureInfo.Create('zh-CN');
  Self.DataSet11.Namespace := 'http://www.changeme.now/DataSet1.xsd';
  // 
  // BdpConnection1
  // 
  Self.BdpConnection1.ConnectionOptions := 'transaction isolation=ReadCommitted;blob size=1024';
  Self.BdpConnection1.ConnectionString := 'assembly=Borland.Data.Mssql, Version=1.5.0.0, Culture=neutral, PublicKeyToken=9'+ 
  '1d62ebb5b0d1b1b;vendorclient=sqloledb.dll;database=NorthWind;username=sa;hostn'+ 
  'ame=localhost;password=;provider=MSSQL';
  // 
  // CategoryAdapter
  // 
  Self.CategoryAdapter.Active := False;
  Self.CategoryAdapter.DataSet := nil;
  Self.CategoryAdapter.DataTable := nil;
  Self.CategoryAdapter.DeleteCommand := Self.bdpDeleteCommand1;
  Self.CategoryAdapter.InsertCommand := Self.bdpInsertCommand1;
  Self.CategoryAdapter.SelectCommand := Self.bdpSelectCommand1;
  Self.CategoryAdapter.StartRecord := 0;
  Self.CategoryAdapter.UpdateCommand := Self.bdpUpdateCommand1;
  // 
  // bdpDeleteCommand1
  // 
  Self.bdpDeleteCommand1.CommandOptions := nil;
  Self.bdpDeleteCommand1.CommandText := 'DELETE FROM dbo.Categories WHERE CategoryID = ? AND CategoryName = ?';
  Self.bdpDeleteCommand1.CommandType := System.Data.CommandType.Text;
  Self.bdpDeleteCommand1.Connection := Self.BdpConnection1;
  Self.bdpDeleteCommand1.ParameterCount := (SmallInt(2));
  Self.bdpDeleteCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('CategoryIDOriginal', 
        Borland.Data.Common.BdpType.Int32, Borland.Data.Common.BdpType.Unknown, 
        0, System.Data.ParameterDirection.Input, False, (Byte(10)), (Byte(0)), 
        10, 'CategoryID', System.Data.DataRowVersion.Original, nil));
  Self.bdpDeleteCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('CategoryNameOriginal', 
        Borland.Data.Common.BdpType.&String, Borland.Data.Common.BdpType.Unknown, 
        30, System.Data.ParameterDirection.Input, False, (Byte(0)), (Byte(0)), 
        0, 'CategoryName', System.Data.DataRowVersion.Original, nil));
  Self.bdpDeleteCommand1.SchemaName := nil;
  Self.bdpDeleteCommand1.Transaction := nil;
  Self.bdpDeleteCommand1.UpdatedRowSource := System.Data.UpdateRowSource.None;
  // 
  // bdpInsertCommand1
  // 
  Self.bdpInsertCommand1.CommandOptions := nil;
  Self.bdpInsertCommand1.CommandText := 'INSERT INTO dbo.Categories (CategoryID, CategoryName, Description, Picture ) VA'+ 
  'LUES ( ?, ?, ?, ?)';
  Self.bdpInsertCommand1.CommandType := System.Data.CommandType.Text;
  Self.bdpInsertCommand1.Connection := Self.BdpConnection1;
  Self.bdpInsertCommand1.ParameterCount := (SmallInt(4));
  Self.bdpInsertCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('CategoryID', 
        Borland.Data.Common.BdpType.Int32, Borland.Data.Common.BdpType.Unknown, 
        0, System.Data.ParameterDirection.Input, False, (Byte(10)), (Byte(0)), 
        10, 'CategoryID', System.Data.DataRowVersion.Current, nil));
  Self.bdpInsertCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('CategoryName', 
        Borland.Data.Common.BdpType.&String, Borland.Data.Common.BdpType.Unknown, 
        30, System.Data.ParameterDirection.Input, False, (Byte(0)), (Byte(0)), 
        0, 'CategoryName', System.Data.DataRowVersion.Current, nil));
  Self.bdpInsertCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('Description', 
        Borland.Data.Common.BdpType.Blob, Borland.Data.Common.BdpType.stMemo, 
        -2, System.Data.ParameterDirection.Input, False, (Byte(0)), (Byte(0)), 
        0, 'Description', System.Data.DataRowVersion.Current, nil));
  Self.bdpInsertCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('Picture', 
        Borland.Data.Common.BdpType.Blob, Borland.Data.Common.BdpType.stBinary, 
        -1, System.Data.ParameterDirection.Input, False, (Byte(0)), (Byte(0)), 
        0, 'Picture', System.Data.DataRowVersion.Current, nil));
  Self.bdpInsertCommand1.SchemaName := nil;
  Self.bdpInsertCommand1.Transaction := nil;
  Self.bdpInsertCommand1.UpdatedRowSource := System.Data.UpdateRowSource.None;
  // 
  // bdpSelectCommand1
  // 
  Self.bdpSelectCommand1.CommandOptions := nil;
  Self.bdpSelectCommand1.CommandText := 'SELECT * FROM dbo.Categories';
  Self.bdpSelectCommand1.CommandType := System.Data.CommandType.Text;
  Self.bdpSelectCommand1.Connection := Self.BdpConnection1;
  Self.bdpSelectCommand1.ParameterCount := (SmallInt(0));
  Self.bdpSelectCommand1.SchemaName := nil;
  Self.bdpSelectCommand1.Transaction := nil;
  Self.bdpSelectCommand1.UpdatedRowSource := System.Data.UpdateRowSource.None;
  // 
  // bdpUpdateCommand1
  // 
  Self.bdpUpdateCommand1.CommandOptions := nil;
  Self.bdpUpdateCommand1.CommandText := 'UPDATE dbo.Categories SET CategoryID = ?, CategoryName = ?, Description = ?, Pi'+ 
  'cture = ? WHERE CategoryID = ? AND CategoryName = ?';
  Self.bdpUpdateCommand1.CommandType := System.Data.CommandType.Text;
  Self.bdpUpdateCommand1.Connection := Self.BdpConnection1;
  Self.bdpUpdateCommand1.ParameterCount := (SmallInt(6));
  Self.bdpUpdateCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('CategoryID', 
        Borland.Data.Common.BdpType.Int32, Borland.Data.Common.BdpType.Unknown, 
        0, System.Data.ParameterDirection.Input, False, (Byte(10)), (Byte(0)), 
        10, 'CategoryID', System.Data.DataRowVersion.Current, nil));
  Self.bdpUpdateCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('CategoryName', 
        Borland.Data.Common.BdpType.&String, Borland.Data.Common.BdpType.Unknown, 
        30, System.Data.ParameterDirection.Input, False, (Byte(0)), (Byte(0)), 
        0, 'CategoryName', System.Data.DataRowVersion.Current, nil));
  Self.bdpUpdateCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('Description', 
        Borland.Data.Common.BdpType.Blob, Borland.Data.Common.BdpType.stMemo, 
        -2, System.Data.ParameterDirection.Input, False, (Byte(0)), (Byte(0)), 
        0, 'Description', System.Data.DataRowVersion.Current, nil));
  Self.bdpUpdateCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('Picture', 
        Borland.Data.Common.BdpType.Blob, Borland.Data.Common.BdpType.stBinary, 
        -1, System.Data.ParameterDirection.Input, False, (Byte(0)), (Byte(0)), 
        0, 'Picture', System.Data.DataRowVersion.Current, nil));
  Self.bdpUpdateCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('CategoryIDOriginal', 
        Borland.Data.Common.BdpType.Int32, Borland.Data.Common.BdpType.Unknown, 
        0, System.Data.ParameterDirection.Input, False, (Byte(10)), (Byte(0)), 
        10, 'CategoryID', System.Data.DataRowVersion.Original, nil));
  Self.bdpUpdateCommand1.Parameters.Add(Borland.Data.Common.BdpParameter.Create('CategoryNameOriginal', 
        Borland.Data.Common.BdpType.&String, Borland.Data.Common.BdpType.Unknown, 
        30, System.Data.ParameterDirection.Input, False, (Byte(0)), (Byte(0)), 
        0, 'CategoryName', System.Data.DataRowVersion.Original, nil));
  Self.bdpUpdateCommand1.SchemaName := nil;
  Self.bdpUpdateCommand1.Transaction := nil;
  Self.bdpUpdateCommand1.UpdatedRowSource := System.Data.UpdateRowSource.None;
  // 
  // ProductAdapter
  // 
  Self.ProductAdapter.Active := False;
  Self.ProductAdapter.DataSet := nil;
  Self.ProductAdapter.DataTable := nil;
  Self.ProductAdapter.DeleteCommand := Self.bdpDeleteCommand2;
  Self.ProductAdapter.InsertCommand := Self.bdpInsertCommand2;
  Self.ProductAdapter.SelectCommand := Self.bdpSelectCommand2;
  Self.ProductAdapter.StartRecord := 0;
  Self.ProductAdapter.UpdateCommand := Self.bdpUpdateCommand2;
  // 
  // bdpDeleteCommand2
  // 
  Self.bdpDeleteCommand2.CommandOptions := nil;
  Self.bdpDeleteCommand2.CommandText := 'DELETE FROM dbo.Products WHERE ProductID = ? AND ProductName = ? AND SupplierID'+ 
  ' = ? AND CategoryID = ? AND QuantityPerUnit = ? AND UnitPrice = ? AND UnitsInS'+ 
  'tock = ? AND UnitsOnOrder = ? AND ReorderLevel = ? AND Discontinued = ?';
  Self.bdpDeleteCommand2.CommandType := System.Data.CommandType.Text;
  Self.bdpDeleteCommand2.Connection := Self.BdpConnection1;
  Self.bdpDeleteCommand2.ParameterCount := (SmallInt(10));
  Self.bdpDeleteCommand2.Parameters.Add(Borland.Data.Common.BdpParameter.Create('ProductIDOriginal', 
        Borland.Data.Common.BdpType.Int32, Borland.Data.Common.BdpType.Unknown, 
        0, System.Data.ParameterDirection.Input, False, (Byte(10)), (Byte(0)), 
        10, 'ProductID', System.Data.DataRowVersion.Original, nil));
  Self.bdpDeleteCommand2.Parameters.Add(Borland.Data.Common.BdpParameter.Create('ProductNameOriginal', 
        Borland.Data.Common.BdpType.&String, Borland.Data.Common.BdpType.Unknown, 
        80, System.Data.ParameterDirection.Input, False, (Byte(0)), (Byte(0)), 
        0, 'ProductName', System.Data.DataRowVersion.Original, nil));
  Self.bdpDeleteCommand2.Parameters.Add(Borland.Data.Common.BdpParameter.Create('SupplierIDOriginal', 
        Borland.Data.Common.BdpType.Int32, Borland.Data.Common.BdpType.Unknown, 
        0, System.Data.ParameterDirection.Input, False, (Byte(10)), (Byte(0)), 
        10, 'SupplierID', System.Data.DataRowVersion.Original, nil));
  Self.bdpDeleteCommand2.Parameters.Add(Borland.Data.Common.BdpParameter.Create('CategoryIDOriginal',