unit1.dfm

EXCEL表格数据导入数据库的例子

object Form1: TForm1
  Left = 223
  Top = 192
  Width = 696
  Height = 480
  Caption = 'Form1'
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'MS Sans Serif'
  Font.Style = []
  OldCreateOrder = False
  PixelsPerInch = 96
  TextHeight = 13
  object wwDBGrid1: TwwDBGrid
    Left = 0
    Top = 0
    Width = 448
    Height = 446
    Selected.Strings = (
      #21345#21495#9'255'#9#21345#21495#9#9
      #24037#21495#9'255'#9#24037#21495#9#9
      #22995#21517#9'255'#9#22995#21517#9#9
      #24615#21035#9'255'#9#24615#21035#9#9
      #23130#23035#29366#20917#9'255'#9#23130#23035#29366#20917#9#9
      #36523#20221#35777#9'255'#9#36523#20221#35777#9#9
      #20986#29983#26085#26399#9'255'#9#20986#29983#26085#26399#9#9
      #31821#36143#9'255'#9#31821#36143#9#9
      #23478#24237#20303#22336#9'255'#9#23478#24237#20303#22336#9#9
      #20837#21378#26085#26399#9'255'#9#20837#21378#26085#26399#9#9
      #37096#38376#9'255'#9#37096#38376#9#9
      #32844#21153#9'255'#9#32844#21153#9#9
      #25163#26426#21495#9'255'#9#25163#26426#21495#9#9
      #20303#23429#21495#30721#9'255'#9#20303#23429#21495#30721#9#9
      #31038#20445#20195#30721#9'255'#9#31038#20445#20195#30721#9#9
      #21512#21516#36215#22987#26085#26399#9'255'#9#21512#21516#36215#22987#26085#26399#9#9
      #21512#21516#25130#27490#26085#26399#9'255'#9#21512#21516#25130#27490#26085#26399#9#9
      #35797#29992#24037#36164#9'255'#9#35797#29992#24037#36164#9#9
      #36716#27491#24037#36164#9'255'#9#36716#27491#24037#36164#9#9
      #30446#21069#24037#36164#9'255'#9#30446#21069#24037#36164#9#9
      #38134#34892#32534#21495#9'255'#9#38134#34892#32534#21495#9#9
      #38134#34892#21345#21495#9'255'#9#38134#34892#21345#21495#9#9
      #29616#22312#20303#22336#9'255'#9#29616#22312#20303#22336#9#9
      #25143#21475#25152#22312#22320#9'255'#9#25143#21475#25152#22312#22320#9#9
      #23646#30456#9'255'#9#23646#30456#9#9
      'POSITION'#9'255'#9'POSITION'#9#9
      'English'#9'255'#9'English'#9#9)
    IniAttributes.Delimiter = ';;'
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    Align = alClient
    DataSource = ds2
    Options = [dgEditing, dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgConfirmDelete, dgCancelOnExit, dgWordWrap, dgDblClickColSizing]
    TabOrder = 0
    TitleAlignment = taLeftJustify
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'MS Sans Serif'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = False
  end
  object pnl1: TPanel
    Left = 448
    Top = 0
    Width = 240
    Height = 446
    Align = alRight
    BevelOuter = bvLowered
    Font.Charset = GB2312_CHARSET
    Font.Color = clWindowText
    Font.Height = -12
    Font.Name = #23435#20307
    Font.Style = []
    ParentFont = False
    TabOrder = 1
    object Label1: TLabel
      Left = 10
      Top = 16
      Width = 84
      Height = 12
      Caption = #25968#25454#24211'IP'#22320#22336#65306
    end
    object Label2: TLabel
      Left = 8
      Top = 48
      Width = 84
      Height = 12
      Caption = #25968#25454#24211#29992#25143#21517#65306
    end
    object Label3: TLabel
      Left = 56
      Top = 80
      Width = 36
      Height = 12
      Caption = #21475#20196#65306
    end
    object Label4: TLabel
      Left = 32
      Top = 112
      Width = 60
      Height = 12
      Caption = #25968#25454#24211#21517#65306
    end
    object btn2: TButton
      Left = 85
      Top = 152
      Width = 108
      Height = 25
      Caption = #36830#25509#25968#25454#24211
      TabOrder = 0
      OnClick = btn2Click
    end
    object btn3: TButton
      Left = 85
      Top = 200
      Width = 108
      Height = 25
      Caption = #25171#24320'EXCEL'#25991#20214
      TabOrder = 1
      OnClick = btn3Click
    end
    object btn4: TButton
      Left = 85
      Top = 248
      Width = 108
      Height = 25
      Caption = #23548#20837#25968#25454
      TabOrder = 2
      OnClick = btn4Click
    end
    object edt1: TEdit
      Left = 95
      Top = 12
      Width = 121
      Height = 20
      TabOrder = 3
      Text = '127.0.0.1'
    end
    object edt2: TEdit
      Left = 95
      Top = 44
      Width = 121
      Height = 20
      TabOrder = 4
      Text = 'sa'
    end
    object edt3: TEdit
      Left = 95
      Top = 76
      Width = 121
      Height = 20
      PasswordChar = '&'
      TabOrder = 5
    end
    object edt4: TEdit
      Left = 95
      Top = 108
      Width = 121
      Height = 20
      TabOrder = 6
      Text = 'hoyida'
    end
    object Button1: TButton
      Left = 85
      Top = 296
      Width = 108
      Height = 25
      Caption = #20851#38381
      TabOrder = 7
      OnClick = Button1Click
    end
    object stat1: TStatusBar
      Left = 1
      Top = 426
      Width = 238
      Height = 19
      Panels = <>
    end
  end
  object con1: TADOConnection
    LoginPrompt = False
    Left = 80
    Top = 392
  end
  object ds1: TADODataSet
    Connection = con1
    CursorType = ctStatic
    Parameters = <>
    Left = 112
    Top = 392
  end
  object ds2: TDataSource
    DataSet = ds1
    Left = 144
    Top = 392
  end
  object dlgOpen1: TOpenDialog
    Filter = 'Excel'#25991#20214'|*.xls'
    Left = 472
    Top = 336
  end
  object con2: TADOConnection
    ConnectionString = 
      'Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initia' +
      'l Catalog=hoyida;Data Source=MS-7EB589093D4F'
    LoginPrompt = False
    Provider = 'SQLOLEDB.1'
    Left = 464
    Top = 152
  end
  object ds3: TADODataSet
    Connection = con2
    CursorType = ctStatic
    CommandText = 'select * from Department'
    Parameters = <>
    Left = 264
    Top = 48
  end
  object ds4: TADODataSet
    Connection = con2
    CommandText = 'select * from empItemTable'
    Parameters = <>
    Left = 264
    Top = 80
  end
  object ds5: TADODataSet
    Connection = con2
    CommandText = 'select * from employee where 1=0'
    Parameters = <>
    Left = 264
    Top = 120
  end
  object ds6: TADODataSet
    Connection = con2
    CommandText = 'select * from EmployeeAddin where 1=0'
    Parameters = <>
    Left = 264
    Top = 160
  end
end