Sabtu, 27 Februari 2016

VB.NET - How To Get Selected Row Values From DataGridView Into TextBox In VB.NET

VB.NET - How To Display Data From The Selected DataGridView Row IntoTextBoxes Using VB.NET 

                                                                                                                         

In This VB.NET Tutorial We Will See How To Displaying The Selected DataGridView Row Values To TextBox Using VB.NET Programming Language.


Project Source Code:

Imports System.Data.DataTable

Public Class Selected_Row_From_DataGridView_To_TextBoxes
   ' Create a new datatable
Dim table As New DataTable("Table") Private Sub Selected_Row_From_DataGridView_To_TextBoxes_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        ' Add columns to your datatable, 
' with the name of the columns and their type
table.Columns.Add("Id", Type.GetType("System.Int32")) table.Columns.Add("First Name", Type.GetType("System.String")) table.Columns.Add("Last Name", Type.GetType("System.String")) table.Columns.Add("Age", Type.GetType("System.Int32"))

        ' Add rows to the datatable with some data
table.Rows.Add(1, "XXXX", "YYYYY", 21) table.Rows.Add(2, "SSDD", "hGSQ", 33) table.Rows.Add(3, "fgfgd", "jgfdd", 53) table.Rows.Add(4, "cvfghyghj", "sdrgtyh", 19) table.Rows.Add(5, "hghfd", "ghjgdf", 36) table.Rows.Add(6, "cvvdfgh", "juyrfdvc", 63)
        ' load datatable data to datagridview
DataGridView1.DataSource = table

End Sub
    ' datagridview cell click event
Private Sub DataGridView1_CellClick(sender As Object, e As DataGridViewCellEventArgs) Handles DataGridView1.CellClick

Dim index As Integer

       ' get the index of the selected datagridview row
index = e.RowIndex

Dim selectedRow As DataGridViewRow
selectedRow = DataGridView1.Rows(index)

        ' now show data from the selected row to textboxes
TextBoxID.Text = selectedRow.Cells(0).Value.ToString()
TextBoxFN.Text = selectedRow.Cells(1).Value.ToString()
TextBoxLN.Text = selectedRow.Cells(2).Value.ToString()
TextBoxAGE.Text = selectedRow.Cells(3).Value.ToString()

End Sub

End Class

///////////////OUTPUT:

Display Selected Row Values From DataGridView Into TextBoxes In VB.NET
Selected Row From DataGridView To TextBoxes Using VB.NET

Bagikan

Jangan lewatkan

VB.NET - How To Get Selected Row Values From DataGridView Into TextBox In VB.NET
4/ 5
Oleh

Subscribe via email

Suka dengan artikel di atas? Tambahkan email Anda untuk berlangganan.