Its properties (get accessors) will be used to display the values on the screen. You can use an object collection, such as a List(Of String), in your DataGridView using the Visual Basic language. However: You will often want the CellClick, SelectionChanged, CellDoubleClick, and KeyPress events, depending on your requirements. DataGridView has many events, and this article doesn't describe them all. This allows you to manipulate the events on the control. When using the DataGridView control in Windows Forms, you should use the lightning bolt panel. This is an efficient way to populate DataGridView. It allows the DataGridView to read in the DataTable and display all its contents on the screen in grid form.

The Form1_Load sub calls into the GetDataTable function, which would return a DataTable from your database in SQL Server.Īssigning the DataSource property on DataGridView copies no data. This event handler is executed when the program starts up and when the DataGridView control is displayed. ' This Function needs to build the data table. Private Function GetDataTable() As DataTable ' DataGridView1.DataSource = GetDataTable() Private Sub Form1_Load(ByVal sender As System.Object, _īyVal e As System.EventArgs) Handles MyBase.Load Here: We use an empty DataTable on the DataGridView control. Load: You can create the Load event on the Form's event pane in Visual Studio. After you add the control, you can add the Load event on the form. First, you should add a DataGridView control to your Windows Forms application by double-clicking on the control name in the Visual Studio designer panel. Data edited in the DataGridView can then be persisted in the database.Įxample. It is an excellent way to display and allow editing for your data. They show event handlers and properties.ĭataGridView provides a visual interface to data. These VB.NET examples use DataGridView from Windows Forms.

Vb.net datagridview .sln