FillWeight Layout DataGridView Columns using VB.Net
In this tutorial, you will learn the purpose of FillWeight in your DataGridView Edit Columns properties.
First, create your Visual Basic project and add a DataGridView on your Form1 designer.

Sample DataGridView in a Form1 designer.
Next, go to the DataGridView’s property tab and set the AutoSizeColumnsMode from None to Fill.

AutoSizeColumnsMode from None to Fill.
Then, we are going to add columns to the blank DataGridView. To add new columns, go again to the properties tab and click the Column collection.

Columns Collection Property.
Then, we will add ID, Name and Address Columns to our DataGridView. After adding the three columns, you will notice that the columns width are distributed evenly.

Output from added columns.
Now, if you want to make a column reduce its width, all you have to do is to adjust its FillWeight property located at the columns collection property then on the Unbound Column Properties.

Unbound Column Property – FillWeight property location.
So, we are going to adjust the fillweight of the ID column so that it wouldn’t look inappropriate or occupy space because like for example your ID consists of 4 numbers. I adjust the fillweight of the ID column from 100 to 50 and here’s the output.

Expected output when the ID’s fillweight has been modified.
This is much better compared to the recent width of the ID column. Let’s try to add values on our DataGridView by applying this line of code on our Form Load event.
Public Class Form1
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
DataGridView1.Rows.Add("1234", "Ian Lavapiez", "Iloilo City")
DataGridView1.Rows.Add("1235", "Juan de la Cruz", "Bacolod")
DataGridView1.Rows.Add("1236", "Pedro Penduko", "Antique")
DataGridView1.Rows.Add("1237", "Hero Lacataria", "Capiz")
End Sub
End ClassHere’s the expected output when we applied the line of code to our project.

This is the end of our tutorial FillWeight Layout DataGridView Columns using VB.Net.
For questions or any other concerns or thesis/capstone creation with documentation, you can contact me through the following:
E-Mail: [email protected]
Facebook: facebook.com/kirk.lavapiez
Contact No.: +639771069640
Ian Hero L. Lavapiez
BSIT Graduate, soon to be MIT.
System Analyst and Developer
Related topic(s) that you may like:
- VB.Net Project Application Setting Store and Retrieve Information
- Limiting Data Selection Query in mySQL using VB.Net
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.
