Embedding NumericUpDown Controls in a DataGridView using Visual Basic

Question

Embedding NumericUpDown Controls in a DataGridView using Visual Basic

jpcodex153 20

I'm trying to create a DataGridView column that has a NumericUpDown control for each row. However, I want to also control each NumericUpDown properties individually. For example, the numeric control on row one I want the following properties ".DecimalPlaces = 2, .Increment=1.0, .Minimum=-100.0, .Maximum=100.0". On Row two I want the following properties ".DecimalPlaces=3, .Increment=.1, .Minimum=0, .Maximum=10.0". I don't want to hard code the properties either, because I will be reading from a database what these properties and then adjusting the form dynamically. I am using Visual Basic 2022.

Thanks for any help in advance...

Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2023-06-14T01:29:14.26+00:00

Hi @jpcodex153 , welcome to Microsoft Q&A.

I don't want to hard code the properties either, because I will be reading from a database what these properties and then adjusting the form dynamically.

Based on what do you want to set these properties dynamically? Do you save these properties in the database?

Could you please provide some examples?
jpcodex153 20 Reputation points

2023-06-14T16:00:55.5166667+00:00

Here's a rough image of what I was aiming for. I don't need help with any of the database code, if that was what you are asking. However, I was curious on the feasability on adding a numericupdown control to a datagridview, like the one shown above. Also, is there any code examples that might help me along the way? The numericupdown control must have the ability to adjust properties like ".Increment, .Minimum, .Maximum, .Value, .DecimalPlaces" on the fly. I need numericupdown properties to be dynamic because the user will be able to select what test they want or don't want to include in the data record. Each test will have its own limitations on what the minimum, maximum range will be... along with the default starting value, how many decimal places you can use, and the increment used for the up and down buttons.
Mansour_Dalir 2,036 Reputation points

2023-06-15T06:38:58.72+00:00

hi jpcodex153

If the number of rows in the table is small, you can create a user control (about 200 numbers). Otherwise, you should use the example.
jpcodex153 20 Reputation points

2023-06-15T12:47:29.1633333+00:00

Thanks Jiachen... I got the code sample from this website instead since the code link on the micrsoft site doesn't work...

https://web.archive.org/web/20140901083508/download.microsoft.com/download/0/1/6/0165999a-7668-4643-a34b-87d2865da596/DGV_NUPD.exe

Accepted answer

0 additional answers

Your answer

Jiachen Li-MSFT 34,221 Reputation points Microsoft External Staff

2023-06-14T01:29:14.26+00:00

Hi @jpcodex153 , welcome to Microsoft Q&A.

I don't want to hard code the properties either, because I will be reading from a database what these properties and then adjusting the form dynamically.

Based on what do you want to set these properties dynamically? Do you save these properties in the database?

Could you please provide some examples?
jpcodex153 20 Reputation points

2023-06-14T16:00:55.5166667+00:00

Here's a rough image of what I was aiming for. I don't need help with any of the database code, if that was what you are asking. However, I was curious on the feasability on adding a numericupdown control to a datagridview, like the one shown above. Also, is there any code examples that might help me along the way? The numericupdown control must have the ability to adjust properties like ".Increment, .Minimum, .Maximum, .Value, .DecimalPlaces" on the fly. I need numericupdown properties to be dynamic because the user will be able to select what test they want or don't want to include in the data record. Each test will have its own limitations on what the minimum, maximum range will be... along with the default starting value, how many decimal places you can use, and the increment used for the up and down buttons.
Mansour_Dalir 2,036 Reputation points

2023-06-15T06:38:58.72+00:00

hi jpcodex153

If the number of rows in the table is small, you can create a user control (about 200 numbers). Otherwise, you should use the example.
jpcodex153 20 Reputation points

2023-06-15T12:47:29.1633333+00:00

Thanks Jiachen... I got the code sample from this website instead since the code link on the micrsoft site doesn't work...

https://web.archive.org/web/20140901083508/download.microsoft.com/download/0/1/6/0165999a-7668-4643-a34b-87d2865da596/DGV_NUPD.exe

Answer 1

Jiachen Li-MSFT 34,221 Microsoft External Staff

Hi @jpcodex153 ,

You can refer to the document Build a Custom NumericUpDown Cell and Column for the DataGridView Control.

Best Regards.

Jiachen Li

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Mansour_Dalir 2,036

Hi @Jiachen Li-MSFT Hi @jpcodex153

Can this be a practical answer? with the least code.

20230615_113456

    Private Sub DataGridView1_CellMouseClick(sender As Object, e As DataGridViewCellMouseEventArgs) Handles DataGridView1.CellMouseClick
        If e.ColumnIndex = 2 Then
            Dim rec As Rectangle = DataGridView1.GetCellDisplayRectangle(DataGridView1.CurrentCell.ColumnIndex, DataGridView1.CurrentRow.Index, False)
            nud1.Height = rec.Height ' New Size(rec.Width,)
            nud1.Width = rec.Width ' New Size(rec.Width,)
            nud1.Location = rec.Location
            nud1.Value = DataGridView1.CurrentCell.Value
        End If
    End Sub

   Private Sub nud1_ValueChanged(sender As Object, e As EventArgs) Handles nud1.ValueChanged
        DataGridView1.CurrentRow.Cells(2).Value = nud1.Value

    End Sub

    Private Sub DataGridView1_CellFormatting(sender As Object, e As DataGridViewCellFormattingEventArgs) Handles DataGridView1.CellFormatting
        If e.ColumnIndex = 2 Then
            Dim rec As Rectangle = DataGridView1.GetCellDisplayRectangle(e.ColumnIndex, DataGridView1.CurrentRow.Index, False)
            nud1.Height = rec.Height ' New Size(rec.Width,)
            nud1.Width = rec.Width ' New Size(rec.Width,)
            nud1.Location = rec.Location
            nud1.Value = DataGridView1.CurrentRow.Cells(2).Value
        End If
    End Sub

Share via

Embedding NumericUpDown Controls in a DataGridView using Visual Basic

0 additional answers

Your answer