Skip to main content

Add New Row in DataGridView Programmatically

In some cases, you want to add new rows to the DataGridView programmatically. If you are using a data-bound DataGridView control, you cannot easily use the cells properties of the DataGridView control.

All you need to do is use the dataset where the DataGridView control is connected. Say you want to get the record from employees table and put it in DataGridView.

Here’s how to do it:

  1. Dim strSQL As String
  3. strSQL = "SELECT * FROM Employees"
  5. Dim cmd As OleDbCommand = New OleDbCommand(strSQL, conn)
  6. 'create data reader
  7. Dim rdr As OleDbDataReader = cmd.ExecuteReader
  9. While rdr.Read
  10. Dim newRow As PayrollDataSet.PayrollRow = PayrollDataSet.Payroll.NewPayrollRow
  12. newRow.EmployeeID = rdr("EmployeeID")
  13. newRow.MonthlySalary = rdr("MonthlySalary")
  14. newRow.SSSCont = rdr("SSSCont")
  15. newRow.SalaryLoan = rdr("SalaryLoan")
  16. newRow.NetIncome = rdr("MonthlySalary") - rdr("SSSCont") - rdr("SalaryLoan")
  18. PayrollDataSet.Payroll.Rows.Add(newRow)
  19. End While

Download the VB.NET Project on Adding Rows to Data-Bound DataGridView.

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.


1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Add new comment

This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.