Add/Remove Rows and validating each cells in DataGridView Control
This project Add/Remove Rows and validating each cells in DataGridView Control is an advanced VB.Net (2010) code but it is a base implementation in every project.
Intended for input data in “One to Many” relationship, such as in sales products etc., by writing all Run Time code. Because of the flexibility to control the program for work as we want. This will make users feel to “Friendly used”.
It consists of locking the keyboard in each cell of the DataGridView. In case of an integer, it can only be numbered from 0 to 9. In case of a double value, it will be from 0 to 9 and the dot (.), but can only be pressed once.
Also, I’ve added a way to add and remove rows from a DataGridView. For each of you to study and apply together comfortably.
Data Grid employs the methods of a data source specified to the DataSource property to add and remove rows. Only if your data source supports such an API may you and your end-users add and remove Data Grid rows.
The ExcelDataSource, for example, is a read-only data source, so data editing in a grid tied to it is not possible.
If a Data Grid is bound to a data source that implements the IBindingList interface, the availability of row actions is determined by the boolean AllowNew and AllowRemove settings.
Lists with simple type objects (e.g., Liststring>) are not supported; instead, you must define a class with one simple type attribute. A default constructor for this class must be empty.
This is open source code Add/Remove Rows and validating each cells in DataGridView Control under @CopyLeft by Thongkorn Tubtimkrob. You can feel free to modify and/or distribute without to inform the developer.
DOWNLOAD SOURCE CODE VB.NET (2010)
Related topic(s) that you may like:
I hope this sample application will help you.
Thank You.
Thongkorn Tubtimkrob
For outside from Thailand can be contact me at My Facebook
Frequently Asked Questions
How does this VB.NET DataGridView example work?
Demonstrates binding a DataGridView to a DataTable or SQL Server source via ADO.NET. Common patterns: filter rows, edit cells with validation, export to Excel via interop, custom column formatting, search.
What Visual Studio and SQL Server versions does this VB.NET project require?
Most projects use VB.NET WinForms on .NET Framework 4.5+ with SQL Server 2012 Express or higher. To run: install Visual Studio 2019 / 2022 (Community is free) with the ‘Desktop development with .NET’ workload, install SQL Server Express + SSMS, open the .sln file, build, run.
How do I set up the database for this VB.NET project?
Open SQL Server Management Studio (SSMS) and connect to your SQL Server (e.g. localhost\SQLEXPRESS). Right-click Databases, choose Restore Database OR New Database then import the included .sql script. Update the connection string in App.config (or in code-behind Module) with your server name + credentials. Rebuild and run.
Can I use this VB.NET project for a BSIT capstone or thesis?
Yes, VB.NET is one of the most accepted languages by Philippine BSIT panels. Extend it: add role-based access (admin/staff/customer login redirect), Crystal Reports or RDLC reports, dashboards with Chart control, audit log, multi-branch support. Pair with Chapter 1-5 documentation matching your panel’s rubric.
Why am I getting ‘connection error’ or ‘cannot find SQL Server’?
Three common VB.NET issues: (1) Connection error: SQL Server isn’t running. Open SQL Server Configuration Manager and verify SQL Server (SQLEXPRESS) service is started. (2) Wrong server name in connection string. Try .\SQLEXPRESS, (local)\SQLEXPRESS, or your machine name. (3) Login failed: SQL Server is set to ‘Windows-only’ authentication. Switch to Mixed Mode in SSMS Server Properties, Security.
Where can I find more VB.NET projects with source code?
Browse the VB.NET Projects hub for the full library. For C# WinForms alternatives see C# Projects. For ASP.NET web alternatives see ASP.NET Projects. For BSIT capstone idea lists see 150 Best Capstone Project Ideas.