教你建立動態 MSSQL 資料庫表 (2) — 按鈕控制項宣告與初始化

本系列第二部分，展示 VB.NET 表單類別中按鈕與 DataGrid 控制項的宣告、實例化與屬性初始化代碼（設計器生成）。

控制項宣告

Friend WithEvents CreateDBBtn As Button
Friend WithEvents CreateTableBtn As Button
Friend WithEvents CreateSPBtn As Button
Friend WithEvents CreateViewBtn As Button
Friend WithEvents btnAlterTable As Button
Friend WithEvents btnCreateOthers As Button
Friend WithEvents btnDropTable As Button
Friend WithEvents btnViewData As Button
Friend WithEvents btnViewSP As Button
Friend WithEvents btnViewView As Button
Friend WithEvents DataGrid1 As DataGrid

InitializeComponent 關鍵初始化片段

Me.CreateDBBtn = New Button()
Me.CreateDBBtn.Location = New Point(19, 9)
Me.CreateDBBtn.Name = "CreateDBBtn"
Me.CreateDBBtn.Size = New Size(104, 23)
Me.CreateDBBtn.TabIndex = 0
Me.CreateDBBtn.Text = "建立資料庫"

Me.CreateTableBtn = New Button()
Me.CreateTableBtn.Location = New Point(139, 9)
Me.CreateTableBtn.Name = "CreateTableBtn"
Me.CreateTableBtn.TabIndex = 1
Me.CreateTableBtn.Text = "建立表"

Me.CreateSPBtn = New Button()
Me.CreateSPBtn.Location = New Point(230, 9)
Me.CreateSPBtn.Name = "CreateSPBtn"
Me.CreateSPBtn.Size = New Size(104, 23)
Me.CreateSPBtn.TabIndex = 2
Me.CreateSPBtn.Text = "建立預存程序"

Me.CreateViewBtn = New Button()
Me.CreateViewBtn.Location = New Point(350, 9)
Me.CreateViewBtn.Name = "CreateViewBtn"
Me.CreateViewBtn.TabIndex = 3
Me.CreateViewBtn.Text = "建立檢視表"

Me.btnAlterTable = New Button()
Me.btnAlterTable.Location = New Point(441, 9)
Me.btnAlterTable.Name = "btnAlterTable"
Me.btnAlterTable.TabIndex = 4
Me.btnAlterTable.Text = "修改表"

其餘按鈕 (btnCreateOthers、btnDropTable、btnViewData、btnViewSP、btnViewView) 初始化邏輯同理。此為設計器自動生成代碼，下一部分將進入表單佈局與 DataGrid 設定。