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






Share this

Related Posts

Previous
Next Post »

3 comments

comments
26 novembre 2016 à 17:27 delete

I'm from Brazil, very much with your code. **

Reply
avatar
24 janvier 2017 à 18:48 delete

Very helpful. Thank you!

Reply
avatar