How to display data from database into numericalupdown

Question

Hello guys  I'm new member & I glad to join with you  forgive me if I made a mistake because it's a first time to post I need your help please  I have a database with three columns as shown below : Column1 PL UL Ali 22 24 Ahmed 33 25 I have two numericalupdown & one combobox  I made a connect between combobox & column1 now when I chose item from comobox let's suppose I chose Ali I need to display his PL value (22) in first numericalupdown and UL value (24) in second numericalupdown Thank you.

Arindam Nayak · Answer

I guess you are using windows form. Based on above assumption you can do a DB query with table and get values corresponding data . Following above example for Ali  i will get PL = 22 UL = 24. Use following code to set their values. Say  numericUpDown1 - is the first numericupdown ID. numericUpDown1.Value = PL_Value numericUpDown1.Maximum = PL_MAX numericUpDown1.Minimum = PL_MIN Similarly do for other.