Display data data from an ID in the table in a textBox - C #

I need to make a select in the database to capture the id of the last product registration, I will make an increment and show it in textbox in my registration form. My intention is to show the user what will be the next id of product that will be registered.

How can I transform this information from select to display it in textBox ?