Make DataGridView Height Automatic

In this post I will be showing you a stepwise procedure to make the DataGridView height automatic i.e. increase with the number of rows added.

Context:

a)Given that multiple of rows are required in DataGridView but you are unknown about how many rows are required.

b)You want your DataGridView height increased automatically when new row(s) are/is added.

Context example: You are to provide user to names of his friends in his classroom with their some detail like age, sex, etc. and etc. Now, the problem is you don’t know how many friends he has in his classroom; maybe 10 or 20 or 30 or 31. Let’s suppose, you want to use DataGridView to show all data the user has entered. There is no problem when you add the data in DataGridView by adding rows in it, but the problem arises when your DataGridView height is not sufficient to show all rows in it; you will see vertical scrollbar in the side of DataGridView afterward. You want to show all rows (whatever the number of rows datagridview has) without scrollbar (i.e. see all rows without scrolling down like a table). Here, you can use my concept.

When DataGridView height is not automated:

Fig 1: Form Design View

Now I am adding 10 sample data programmatically (from coding) and running the program.

Fig 2: Form running view where you can clearly see the scrollbars in side of the DataGridView

Fig 3: Form running view. You can see that when DataGridView size is more than the extra space below the table is shown. Note: Size is changed manually in design view

Fig 4: Form running view after the height is made automatic.

Context solution: Increase DataGridView height automatically when new rows are added.

Here goes the solution for this problem:

11)Create a DataGridView and add columns.

22)Create a new Sub (copy paste below)

Private Sub DataGridView1_RowsAdded(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewRowsAddedEventArgs) Handles DataGridView1.RowsAdded

End Sub

# This Sub handles the event when rows are added in DataGridView1

#Note: You can create this Sub by double clicking the DataGridView and going to coding section of Form and clicking the combo shown below and selecting ‘RowsAdded’. Be careful don’t click anywhere else after double clicking the DataGridView (or jus remain in the sub where double click takes you and then click combo)

Fig 5: Combo location in code view to add the Sub

33)Now, add code below in Sub created in step 2

DataGridView1.Height = DataGridView1.Height + DataGridView1.Rows(DataGridView1.Rows.Count - 1).Height

# It changes the DataGridView height by adding the height of row added.

#Note: this is not sufficient to make dataGridView look like in fig 4.

44)Now, add the below code in form load Sub; just below the declaration of Sub:

DataGridView1.Height = DataGridView1.ColumnHeadersHeight + 24

#like below:

Private Sub test_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

DataGridView1.Height = DataGridView1.ColumnHeadersHeight + 24

End Sub

#24 is added because there will be an extra row to add data in the DataGridView (see row with header *) which size is 22px and 2px extra is for the margin of the DataGridView. If ‘add data’ is not enabled in dataGridView than use 2. Check yourself by changing the value.

Fig 6: when new data is being added in DataGridView from Fig 4.

#Note: 10 data are added programmatically.

If you have any queries than leave in the comment(s).