VB.NET - How To Add And Update Row From DataGridView Using InputBoxes In VB.NET
In This VB.NET Tutorial We Will See How To Add A Row To DataGridView From InputBox, Update A Selected Row Using InputBoxBox In VB.NET Programming Language.
Project Source Code:
Public Class VB_DataGridView_Add_Update_Row_Using_InputBox
Dim table As New DataTable("Table")
' the index of the selected datagridview row
Dim selectedRowIndex As Integer
Private Sub VB_DataGridView_Add_Update_Row_Using_InputBox_Load(sender As Object, e As EventArgs) Handles MyBase.Load
' populate datagridview with some data using datatable
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"))
table.Rows.Add(1, "HJK", "KJH", 34)
table.Rows.Add(3, "CVBN", "NBVC", 22)
table.Rows.Add(7, "AZSDFVB", "VCRTYUXA", 45)
DataGridView1.DataSource = table
End Sub
' button add row
Private Sub BtnAddRow_Click(sender As Object, e As EventArgs) Handles BtnAddRow.Click
' get data from inputBox
Dim id As Integer
id = Integer.Parse(InputBox("Enter The Id", "Enter Data", -1, -1))
Dim fn As String
fn = InputBox("Enter The First Name", "Enter Data", -1, -1)
Dim ln As String
ln = InputBox("Enter The Last Name", "Enter Data", -1, -1)
Dim age As Integer
age = Integer.Parse(InputBox("Enter The Age", "Enter Data", -1, -1))
' insert data into jtable
table.Rows.Add(id, fn, ln, age)
DataGridView1.DataSource = table
End Sub
' DataGridView Cell Click
Private Sub DataGridView1_CellClick(sender As Object, e As DataGridViewCellEventArgs) Handles DataGridView1.CellClick
' get the index of the selected row
selectedRowIndex = e.RowIndex
End Sub
' button update row
Private Sub BtnUpdateRow_Click(sender As Object, e As EventArgs) Handles BtnUpdateRow.Click
Dim row As New DataGridViewRow()
row = DataGridView1.Rows(selectedRowIndex)
' get data from inputBoxes
Dim id As String
id = InputBox("Enter The New Id", "Update Data", row.Cells(0).Value.ToString())
Dim fn As String
fn = InputBox("Enter The New First Name", "Update Data", row.Cells(1).Value.ToString())
Dim ln As String
ln = InputBox("Enter The New Last Name", "Update Data", row.Cells(2).Value.ToString())
Dim age As String
age = InputBox("Enter The New Age", "Update Data", row.Cells(3).Value.ToString())
' insert data into the row
row.Cells(0).Value = Integer.Parse(id)
row.Cells(1).Value = fn
row.Cells(2).Value = ln
row.Cells(3).Value = Integer.Parse(age)
End Sub
End Class
///////////////OUTPUT:
vb.net datagridview add update row |