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:
- Dim strSQL As String
- strSQL = "SELECT * FROM Employees"
- Dim cmd As OleDbCommand = New OleDbCommand(strSQL, conn)
- 'create data reader
- Dim rdr As OleDbDataReader = cmd.ExecuteReader
- While rdr.Read
- Dim newRow As PayrollDataSet.PayrollRow = PayrollDataSet.Payroll.NewPayrollRow
- newRow.EmployeeID = rdr("EmployeeID")
- newRow.MonthlySalary = rdr("MonthlySalary")
- newRow.SSSCont = rdr("SSSCont")
- newRow.SalaryLoan = rdr("SalaryLoan")
- newRow.NetIncome = rdr("MonthlySalary") - rdr("SSSCont") - rdr("SalaryLoan")
- 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 SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.
FOR YOUR OWN SAFETY, PLEASE:
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.