Windows Form กับ ListView แสดงข้อมูลบน ListView ในรูปแบบ Table/Grid (VB.Net,C#)

   Public Class EmpProfiles
        Public Property EMP_ID() As String
            Get
                Return m_EMP_ID
            End Get
            Set
                m_EMP_ID = Value
            End Set
        End Property
        Private m_EMP_ID As String
        Public Property EMP_NAME() As String
            Get
                Return m_EMP_NAME
            End Get
            Set
                m_EMP_NAME = Value
            End Set
        End Property
        Private m_EMP_NAME As String
        Public Property EMP_SALARY() As Decimal
            Get
                Return m_EMP_SALARY
            End Get
            Set
                m_EMP_SALARY = Value
            End Set
        End Property
        Private m_EMP_SALARY As Decimal
    End Class

    Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        '*** List<T>
        Dim ls = New List(Of EmpProfiles)()
        ls.Add(New EmpProfiles() With {
            .EMP_ID = "E001",
            .EMP_NAME = "Wipa Nukitram",
            .EMP_SALARY = 10000
        })
        ls.Add(New EmpProfiles() With {
            .EMP_ID = "E002",
            .EMP_NAME = "Thitapat Nukitram",
            .EMP_SALARY = 20000
        })
        ls.Add(New EmpProfiles() With {
            .EMP_ID = "E003",
            .EMP_NAME = "Wisarut Nukitram",
            .EMP_SALARY = 30000
        })

        '*** ListView Header
        Me.myListView.Clear()
        myListView.Columns.Clear()
        myListView.HideSelection = False
        myListView.Columns.Add("Emp ID", 50, HorizontalAlignment.Center)
        myListView.Columns.Add("Emp Name", 225, HorizontalAlignment.Left)
        myListView.Columns.Add("Emp Salary", 150, HorizontalAlignment.Right)
        myListView.FullRowSelect = True
        myListView.View = View.Details

        '*** ListView Row
        For Each item In ls
            Dim lvi = New ListViewItem(item.EMP_ID)
            lvi.SubItems.Add(item.EMP_NAME)
            lvi.SubItems.Add(item.EMP_SALARY.ToString())
            Me.myListView.Items.Add(lvi)
        Next

    End Sub

        public class EmpProfiles
        {
            public string EMP_ID { get; set; }
            public string EMP_NAME { get; set; }
            public decimal EMP_SALARY { get; set; }
        }

        private void frmMain_Load(object sender, EventArgs e)
        {

            //*** List<T>
            var ls = new List<EmpProfiles>();
            ls.Add(new EmpProfiles { EMP_ID = "E001", EMP_NAME = "Wipa Nukitram", EMP_SALARY = 10000 });
            ls.Add(new EmpProfiles { EMP_ID = "E002", EMP_NAME = "Thitapat Nukitram", EMP_SALARY = 20000 });
            ls.Add(new EmpProfiles { EMP_ID = "E003", EMP_NAME = "Wisarut Nukitram", EMP_SALARY = 30000 });


            //*** ListView Header
            this.myListView.Clear();
            myListView.Columns.Clear();
            myListView.HideSelection = false;
            myListView.Columns.Add("Emp ID", 50, HorizontalAlignment.Center);
            myListView.Columns.Add("Emp Name", 225, HorizontalAlignment.Left);
            myListView.Columns.Add("Emp Salary", 150, HorizontalAlignment.Right);
            myListView.FullRowSelect = true;
            myListView.View = View.Details;

            //*** ListView Row
            foreach(var item  in ls)
            {
                var lvi = new ListViewItem(item.EMP_ID);
                lvi.SubItems.Add(item.EMP_NAME);
                lvi.SubItems.Add(item.EMP_SALARY.ToString());
                this.myListView.Items.Add(lvi);
            }
           
        }

    Private Sub myListView_SelectedIndexChanged(sender As Object, e As EventArgs) Handles myListView.SelectedIndexChanged
        If Me.myListView.SelectedItems.Count > 0 Then
            Dim selData As String = Me.myListView.SelectedItems(0).Text
            MessageBox.Show(selData)
        End If
    End Sub

        private void myListView_SelectedIndexChanged(object sender, EventArgs e)
        {
            if(this.myListView.SelectedItems.Count > 0)
            {
                String selData = this.myListView.SelectedItems[0].Text;
                MessageBox.Show(selData);
            }
        }

    Private Sub btnSelect_Click(sender As Object, e As EventArgs) Handles btnSelect.Click
        If Me.myListView.SelectedItems.Count > 0 Then
            For Each item As ListViewItem In Me.myListView.SelectedItems
                Dim selData As String = item.SubItems(0).Text
                MessageBox.Show(selData)
            Next
        End If
    End Sub

        private void btnSelect_Click(object sender, EventArgs e)
        {
            if (this.myListView.SelectedItems.Count > 0)
            {
                foreach (ListViewItem item in this.myListView.SelectedItems)
                {
                    String selData = item.SubItems[0].Text;
                    MessageBox.Show(selData);
                }
            }
        }

 Private Sub frmMain_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        '*** Connect Database
        Dim strConnString As String = "Server=localhost;UID=sa;PASSWORD=;database=mydatabase;"
        Dim objConn = New SqlConnection(strConnString)
        objConn.Open()

        Dim strSQL As String = "SELECT * FROM mytable"
        Dim objCmd = New SqlCommand(strSQL, objConn)
        Dim dtReader = objCmd.ExecuteReader()

        '*** ListView Header
        Me.myListView.Clear()
        myListView.Columns.Clear()
        myListView.HideSelection = False
        myListView.Columns.Add("Emp ID", 50, HorizontalAlignment.Center)
        myListView.Columns.Add("Emp Name", 225, HorizontalAlignment.Left)
        myListView.Columns.Add("Emp Salary", 150, HorizontalAlignment.Right)
        myListView.FullRowSelect = True
        myListView.View = View.Details

        '*** ListView Row
        While dtReader.Read()
            Dim lvi = New ListViewItem(dtReader("EmpID").ToString())
            lvi.SubItems.Add(dtReader("EmpName").ToString())
            lvi.SubItems.Add(dtReader("EmpSalary").ToString())
            Me.myListView.Items.Add(lvi)
        End While

        '*** Close Database
        dtReader.Close()
        dtReader = Nothing
        objConn.Close()

    End Sub

        private void frmMain_Load(object sender, EventArgs e)
        {

            //*** Connect Database
            string strConnString = "Server=localhostSQL2014;UID=sa;PASSWORD=;database=mydatabase;";
            var objConn = new SqlConnection(strConnString);
            objConn.Open();

            string strSQL = "SELECT * FROM mytable";
            var objCmd = new SqlCommand(strSQL, objConn);
            var dtReader = objCmd.ExecuteReader();

            //*** ListView Header
            this.myListView.Clear();
            myListView.Columns.Clear();
            myListView.HideSelection = false;
            myListView.Columns.Add("Emp ID", 50, HorizontalAlignment.Center);
            myListView.Columns.Add("Emp Name", 225, HorizontalAlignment.Left);
            myListView.Columns.Add("Emp Salary", 150, HorizontalAlignment.Right);
            myListView.FullRowSelect = true;
            myListView.View = View.Details;

            //*** ListView Row
            while(dtReader.Read())
            { 
                var lvi = new ListViewItem(dtReader["EmpID"].ToString());
                lvi.SubItems.Add(dtReader["EmpName"].ToString());
                lvi.SubItems.Add(dtReader["EmpSalary"].ToString());
                this.myListView.Items.Add(lvi);
            }

            //*** Close Database
            dtReader.Close();
            dtReader = null;
            objConn.Close();

        }