Sample

BaseDataGridView

ColumnHeadersHeightSizeModeをEnableResizingにしないと ColumnHeaderの高さを変更しても反映されないが、 なぜかここで設定した値が使用先で反映されない。 使用先で手動にてColumnHeadersHeightSizeModeをEnableResizing に変更する必要がある。 Imports …

TListClass(TList)

Imports System.ComponentModelImports System.Data.SqlClientImports System.Reflection Public Class TData(Of T As New) Implements IDisposable Public Property DTable() As DataTable Public Property DList() As List(Of T) Public Sub New() Me.DLis…

TClass(T〇〇)

Public Class TUserInfo Implements ITData Public Property UserId As String Public Property UserName As String Public Property UserPassword As String Public Property UserGrant As Integer Public Property GrantText As String Public Property Us…

UpdateClass(TDUpd〇〇)

Imports System.Data.SqlClientImports System.TextPublic Class TDUpdUserInfo Inherits BaseDAO Private Const TABLE_NAME As String = "UserInfo" Private ReadOnly _tCls As TUserInfo Sub New(ByVal tCls As TUserInfo) MyBase.New _tCls = tCls End Su…

InsertClass(TDIns〇〇)

Imports System.Data.SqlClientImports System.Text Public Class TDInsUserInfo Inherits BaseDAO Private Const TABLE_NAME As String = "UserInfo" Private ReadOnly _tCls As TUserInfo Sub New(ByVal tCls As TUserInfo) MyBase.New _tCls = tCls End S…

SelectClass(TD〇〇)

Imports System.Data.SqlClientImports System.Text Public Class TDControlNoManager Inherits BaseDAO Private Const TABLE_NAME As String = "ControlNoManager" Public Property TData As TControlNoManager Public Property DataList As TData(Of TCont…

DAO

Imports System.Data.SqlClientImports System.Runtime.CompilerServices Public MustInherit Class BaseDAO Private connection As SqlConnection Public Sub Execute() Me.connection = New SqlConnection(GetConfigParameters.GetMSSQLConnectString) Usi…