📄 frmadmin.vb
字号:
Option Strict Off
Option Explicit On
Friend Class frmAdmin
Inherits System.Windows.Forms.Form
#Region "Windows 窗体设计器生成的代码"
Public Sub New()
MyBase.New()
If m_vb6FormDefInstance Is Nothing Then
If m_InitializingDefInstance Then
m_vb6FormDefInstance = Me
Else
Try
'对于启动窗体,所创建的第一个实例为默认实例。
If System.Reflection.Assembly.GetExecutingAssembly.EntryPoint.DeclaringType Is Me.GetType Then
m_vb6FormDefInstance = Me
End If
Catch
End Try
End If
End If
'此调用是 Windows 窗体设计器所必需的。
InitializeComponent()
End Sub
'窗体重写处置,以清理组件列表。
Protected Overloads Overrides Sub Dispose(ByVal Disposing As Boolean)
If Disposing Then
If Not components Is Nothing Then
components.Dispose()
End If
End If
MyBase.Dispose(Disposing)
End Sub
'Windows 窗体设计器所必需的
Private components As System.ComponentModel.IContainer
Public ToolTip1 As System.Windows.Forms.ToolTip
Public WithEvents CmdOk As System.Windows.Forms.Button
Public WithEvents ComboUser As System.Windows.Forms.ComboBox
Public WithEvents FrameOpts As System.Windows.Forms.GroupBox
Public WithEvents DataUsers As AxMSDataGridLib.AxDataGrid
'注意: 以下过程是 Windows 窗体设计器所必需的
'可以使用 Windows 窗体设计器来修改它。
'不要使用代码编辑器修改它。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(frmAdmin))
Me.components = New System.ComponentModel.Container()
Me.ToolTip1 = New System.Windows.Forms.ToolTip(components)
Me.ToolTip1.Active = True
Me.FrameOpts = New System.Windows.Forms.GroupBox
Me.CmdOk = New System.Windows.Forms.Button
Me.ComboUser = New System.Windows.Forms.ComboBox
Me.DataUsers = New AxMSDataGridLib.AxDataGrid
CType(Me.DataUsers, System.ComponentModel.ISupportInitialize).BeginInit()
Me.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None
Me.Text = "Form1"
Me.ClientSize = New System.Drawing.Size(384, 329)
Me.Location = New System.Drawing.Point(0, 0)
Me.ShowInTaskbar = False
Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.BackColor = System.Drawing.SystemColors.Control
Me.ControlBox = True
Me.Enabled = True
Me.KeyPreview = False
Me.MaximizeBox = True
Me.MinimizeBox = True
Me.Cursor = System.Windows.Forms.Cursors.Default
Me.RightToLeft = System.Windows.Forms.RightToLeft.No
Me.HelpButton = False
Me.WindowState = System.Windows.Forms.FormWindowState.Normal
Me.Name = "frmAdmin"
Me.FrameOpts.Size = New System.Drawing.Size(369, 65)
Me.FrameOpts.Location = New System.Drawing.Point(8, 256)
Me.FrameOpts.TabIndex = 1
Me.FrameOpts.BackColor = System.Drawing.SystemColors.Control
Me.FrameOpts.Enabled = True
Me.FrameOpts.ForeColor = System.Drawing.SystemColors.ControlText
Me.FrameOpts.RightToLeft = System.Windows.Forms.RightToLeft.No
Me.FrameOpts.Visible = True
Me.FrameOpts.Name = "FrameOpts"
Me.CmdOk.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
Me.CmdOk.Text = "OK"
Me.CmdOk.Size = New System.Drawing.Size(89, 25)
Me.CmdOk.Location = New System.Drawing.Point(272, 24)
Me.CmdOk.TabIndex = 3
Me.CmdOk.BackColor = System.Drawing.SystemColors.Control
Me.CmdOk.CausesValidation = True
Me.CmdOk.Enabled = True
Me.CmdOk.ForeColor = System.Drawing.SystemColors.ControlText
Me.CmdOk.Cursor = System.Windows.Forms.Cursors.Default
Me.CmdOk.RightToLeft = System.Windows.Forms.RightToLeft.No
Me.CmdOk.TabStop = True
Me.CmdOk.Name = "CmdOk"
Me.ComboUser.Size = New System.Drawing.Size(113, 21)
Me.ComboUser.Location = New System.Drawing.Point(8, 24)
Me.ComboUser.Items.AddRange(New Object(){"管理员", "学生", "教师"})
Me.ComboUser.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList
Me.ComboUser.TabIndex = 2
Me.ComboUser.BackColor = System.Drawing.SystemColors.Window
Me.ComboUser.CausesValidation = True
Me.ComboUser.Enabled = True
Me.ComboUser.ForeColor = System.Drawing.SystemColors.WindowText
Me.ComboUser.IntegralHeight = True
Me.ComboUser.Cursor = System.Windows.Forms.Cursors.Default
Me.ComboUser.RightToLeft = System.Windows.Forms.RightToLeft.No
Me.ComboUser.Sorted = False
Me.ComboUser.TabStop = True
Me.ComboUser.Visible = True
Me.ComboUser.Name = "ComboUser"
DataUsers.OcxState = CType(resources.GetObject("DataUsers.OcxState"), System.Windows.Forms.AxHost.State)
Me.DataUsers.Size = New System.Drawing.Size(369, 241)
Me.DataUsers.Location = New System.Drawing.Point(8, 8)
Me.DataUsers.TabIndex = 0
Me.DataUsers.Name = "DataUsers"
Me.Controls.Add(FrameOpts)
Me.Controls.Add(DataUsers)
Me.FrameOpts.Controls.Add(CmdOk)
Me.FrameOpts.Controls.Add(ComboUser)
CType(Me.DataUsers, System.ComponentModel.ISupportInitialize).EndInit()
End Sub
#End Region
#Region "升级支持"
Private Shared m_vb6FormDefInstance As frmAdmin
Private Shared m_InitializingDefInstance As Boolean
Public Shared Property DefInstance() As frmAdmin
Get
If m_vb6FormDefInstance Is Nothing OrElse m_vb6FormDefInstance.IsDisposed Then
m_InitializingDefInstance = True
m_vb6FormDefInstance = New frmAdmin()
m_InitializingDefInstance = False
End If
DefInstance = m_vb6FormDefInstance
End Get
Set
m_vb6FormDefInstance = Value
End Set
End Property
#End Region
Dim dbrs As ADODB.Recordset
Private Sub CmdOk_Click(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles CmdOk.Click
Me.Close()
End Sub
'UPGRADE_WARNING: 初始化窗体时可能激发事件 ComboUser.SelectedIndexChanged。 单击以获得更多信息:“ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?keyword="vbup2075"”
Private Sub ComboUser_SelectedIndexChanged(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles ComboUser.SelectedIndexChanged
dbrs.Close()
Select Case ComboUser.SelectedIndex
Case 0
dbrs = DataEnv.rsAdmTable
Case 1
dbrs = DataEnv.rsStuTable
Case 2
dbrs = DataEnv.rsTchTable
End Select
dbrs.Open()
DataUsers.DataSource = dbrs
DataUsers.CtlRefresh()
End Sub
Private Sub frmAdmin_Load(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase.Load
ComboUser.SelectedIndex = 0
dbrs = DataEnv.rsAdmTable
dbrs.Open()
DataUsers.DataSource = dbrs
DataUsers.CtlRefresh()
End Sub
'UPGRADE_WARNING: Form 事件 frmAdmin.Unload 具有新的行为。 单击以获得更多信息:“ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?keyword="vbup2065"”
Private Sub frmAdmin_Closed(ByVal eventSender As System.Object, ByVal eventArgs As System.EventArgs) Handles MyBase.Closed
dbrs.Close()
'UPGRADE_NOTE: 在对对象 dbrs 进行垃圾回收前,不可以销毁该对象。 单击以获得更多信息:“ms-help://MS.VSCC.2003/commoner/redir/redirect.htm?keyword="vbup1029"”
dbrs = Nothing
End Sub
End Class
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -