How do you allow edit of a field that is linked to a ddllist

Question

Dear experts,

 

I am now stuck at this part where I have this dropdownlist which is linked to my database.

So, when user select the dropdownlist, the other fields like supplier name, email etc will be populated.  But, the catch is that the populated fields will not be populated if later the user go and select the radio button is not a supplier.  Furthermore, they can also overwrite the populated field to something else.  For example, the supplier email is changed.  So, the user can go and changed the populated field and updated accordingly.

 

I have to use Store Procedure for this case.

 

I have the connection constant set up in a helper page already.

 

And I have to use ADO.net method.

Hope someone can advise me how to cos I am more used to entity framework.

Tks.