winform1.pas.~5~

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

unit WinForm1;

interface

uses
  System.Drawing, System.Collections, System.ComponentModel,
  System.Windows.Forms, System.Data, System.Data.SqlClient, DataSet1Unit, 
  System.Globalization;

type
  TWinForm1 = class(System.Windows.Forms.Form)
  {$REGION 'Designer Managed Code'}
  strict private
    /// <summary>
    /// Required designer variable.
    /// </summary>
    Components: System.ComponentModel.Container;
    SqlConnection1: System.Data.SqlClient.SqlConnection;
    sqlSelectCommand1: System.Data.SqlClient.SqlCommand;
    sqlInsertCommand1: System.Data.SqlClient.SqlCommand;
    sqlUpdateCommand1: System.Data.SqlClient.SqlCommand;
    sqlDeleteCommand1: System.Data.SqlClient.SqlCommand;
    SqlDataAdapter1: System.Data.SqlClient.SqlDataAdapter;
    DataGrid1: System.Windows.Forms.DataGrid;
    Button1: System.Windows.Forms.Button;
    Button2: System.Windows.Forms.Button;
    Button3: System.Windows.Forms.Button;
    /// <summary>
    /// Required method for Designer support - do not modify
    /// the contents of this method with the code editor.
    /// </summary>
    procedure InitializeComponent;
    procedure TWinForm1_Load(sender: System.Object; e: System.EventArgs);
    procedure SqlDataAdapter1_RowUpdated(sender: System.Object; e: System.Data.SqlClient.SqlRowUpdatedEventArgs);
    procedure Button1_Click(sender: System.Object; e: System.EventArgs);
    procedure DataGrid1_Navigate(sender: System.Object; ne: System.Windows.Forms.NavigateEventArgs);
    procedure Button2_Click(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(TWinForm1))]

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 TWinForm1.InitializeComponent;
begin
  Self.SqlConnection1 := System.Data.SqlClient.SqlConnection.Create;
  Self.sqlSelectCommand1 := System.Data.SqlClient.SqlCommand.Create;
  Self.sqlInsertCommand1 := System.Data.SqlClient.SqlCommand.Create;
  Self.sqlUpdateCommand1 := System.Data.SqlClient.SqlCommand.Create;
  Self.sqlDeleteCommand1 := System.Data.SqlClient.SqlCommand.Create;
  Self.SqlDataAdapter1 := System.Data.SqlClient.SqlDataAdapter.Create;
  Self.DataGrid1 := System.Windows.Forms.DataGrid.Create;
  Self.Button1 := System.Windows.Forms.Button.Create;
  Self.Button2 := System.Windows.Forms.Button.Create;
  Self.Button3 := System.Windows.Forms.Button.Create;
  (System.ComponentModel.ISupportInitialize(Self.DataGrid1)).BeginInit;
  Self.SuspendLayout;
  // 
  // SqlConnection1
  // 
  Self.SqlConnection1.ConnectionString := 'integrated security=SSPI;data sou' +
  'rce="ECON-IBM-T40-G7";persist security info=False;initial catalog=Northwi' +
  'nd';
  // 
  // sqlSelectCommand1
  // 
  Self.sqlSelectCommand1.CommandText := 'Select EmployeeID, LastName, FirstN' +
  'ame, Address, HomePhone  from Employees';
  Self.sqlSelectCommand1.Connection := Self.SqlConnection1;
  // 
  // sqlInsertCommand1
  // 
  Self.sqlInsertCommand1.CommandText := 'Insert Into Employees(FirstName,Las' +
  'tName, Address, HomePhone) Values (@FirstName ,@LastName, @Address, @Home' +
  'Phone)';
  Self.sqlInsertCommand1.Connection := Self.SqlConnection1;
  Self.sqlInsertCommand1.Parameters.Add(System.Data.SqlClient.SqlParameter.Create('@' +
      'FirstName', System.Data.SqlDbType.NVarChar, 20));
  Self.sqlInsertCommand1.Parameters.Add(System.Data.SqlClient.SqlParameter.Create('@' +
      'LastName', System.Data.SqlDbType.NVarChar, 10));
  Self.sqlInsertCommand1.Parameters.Add(System.Data.SqlClient.SqlParameter.Create('@' +
      'Address', System.Data.SqlDbType.NVarChar, 60));
  Self.sqlInsertCommand1.Parameters.Add(System.Data.SqlClient.SqlParameter.Create('@' +
      'HomePhone', System.Data.SqlDbType.NVarChar));
  // 
  // SqlDataAdapter1
  // 
  Self.SqlDataAdapter1.DeleteCommand := Self.sqlDeleteCommand1;
  Self.SqlDataAdapter1.InsertCommand := Self.sqlInsertCommand1;
  Self.SqlDataAdapter1.SelectCommand := Self.sqlSelectCommand1;
  Self.SqlDataAdapter1.UpdateCommand := Self.sqlUpdateCommand1;
  Include(Self.SqlDataAdapter1.RowUpdated, Self.SqlDataAdapter1_RowUpdated);
  // 
  // DataGrid1
  // 
  Self.DataGrid1.DataMember := '';
  Self.DataGrid1.Dock := System.Windows.Forms.DockStyle.Top;
  Self.DataGrid1.HeaderForeColor := System.Drawing.SystemColors.ControlText;
  Self.DataGrid1.Location := System.Drawing.Point.Create(0, 0);
  Self.DataGrid1.Name := 'DataGrid1';
  Self.DataGrid1.ReadOnly := True;
  Self.DataGrid1.Size := System.Drawing.Size.Create(359, 245);
  Self.DataGrid1.TabIndex := 0;
  Include(Self.DataGrid1.Navigate, Self.DataGrid1_Navigate);
  // 
  // Button1
  // 
  Self.Button1.Location := System.Drawing.Point.Create(27, 267);
  Self.Button1.Name := 'Button1';
  Self.Button1.Size := System.Drawing.Size.Create(62, 22);
  Self.Button1.TabIndex := 1;
  Self.Button1.Text := '插入';
  Include(Self.Button1.Click, Self.Button1_Click);
  // 
  // Button2
  // 
  Self.Button2.Location := System.Drawing.Point.Create(133, 267);
  Self.Button2.Name := 'Button2';
  Self.Button2.Size := System.Drawing.Size.Create(63, 22);
  Self.Button2.TabIndex := 2;
  Self.Button2.Text := '更新';
  Include(Self.Button2.Click, Self.Button2_Click);
  // 
  // Button3
  // 
  Self.Button3.Location := System.Drawing.Point.Create(240, 267);
  Self.Button3.Name := 'Button3';
  Self.Button3.Size := System.Drawing.Size.Create(62, 22);
  Self.Button3.TabIndex := 3;
  Self.Button3.Text := '关闭';
  // 
  // TWinForm1
  // 
  Self.AutoScaleBaseSize := System.Drawing.Size.Create(5, 13);
  Self.ClientSize := System.Drawing.Size.Create(359, 309);
  Self.Controls.Add(Self.Button3);
  Self.Controls.Add(Self.Button2);
  Self.Controls.Add(Self.Button1);
  Self.Controls.Add(Self.DataGrid1);
  Self.Name := 'TWinForm1';
  Self.Text := 'WinForm1';
  Include(Self.Load, Self.TWinForm1_Load);
  (System.ComponentModel.ISupportInitialize(Self.DataGrid1)).EndInit;
  Self.ResumeLayout(False);
end;
{$ENDREGION}

procedure TWinForm1.Dispose(Disposing: Boolean);
begin
  if Disposing then
  begin
    if Components <> nil then
      Components.Dispose();
  end;
  inherited Dispose(Disposing);
end;

constructor TWinForm1.Create;
begin
  inherited Create;
  //
  // Required for Windows Form Designer support
  //
  InitializeComponent;
  //
  // TODO: Add any constructor code after InitializeComponent call
  //
end;

procedure TWinForm1.Button2_Click(sender: System.Object; e: System.EventArgs);
begin
   SqlDataAdapter1.Update(Dataset11.Tables[0]);
end;

procedure TWinForm1.DataGrid1_Navigate(sender: System.Object; ne: System.Windows.Forms.NavigateEventArgs);
begin

end;

procedure TWinForm1.Button1_Click(sender: System.Object; e: System.EventArgs);
var NewRow: DataRow;
begin
     NewRow:= DataSet11.Tables[0].NewRow;
     NewRow['FirstName'] := 'Lee';
     NewRow['LastName'] := 'Herbert';
     NewRow['Address'] := '18-3-601';
     NewRow['HomePhone'] := '80798461';
     DataSet11.Tables[0].Rows.Add(NewRow);
     SqlInsertCommand1.Parameters[0].Value := NewRow['FirstName'];
     SqlInsertCommand1.Parameters[1].Value := NewRow['LastName'];
     SqlInsertCommand1.Parameters[2].Value := NewRow['Address'];
     SqlInsertCommand1.Parameters[3].Value := NewRow['HomePhone'];
end;

procedure TWinForm1.SqlDataAdapter1_RowUpdated(sender: System.Object; e: System.Data.SqlClient.SqlRowUpdatedEventArgs);
begin

end;

procedure TWinForm1.TWinForm1_Load(sender: System.Object; e: System.EventArgs);
begin
    SqlDataAdapter1.Fill(DataSet11.Tables[0]);
end;

end.