Drop down list box with SQL server

[software_develo]

Hi

I am developing a application with VB.NEt where I have a drop down list box with values coming from the SQL server database . I want the system administrator will able to change the drop down list box values from the VB.net form and the change will take place in the database table . Next time when a user will use the drop down list box he /She will see the changed value . How do I do that .

Thanks

[bassam]

is this a desktop or webbased application

[software_develo]

Hi

Thanks for the reply . I am developing a windows application with MS Visual studio 2003.NET ( VB.NET )

Thanks

[bassam]

ok , this is a primary function so it can be done in many ways, I will mention here only one which I belive is the easiest, you will add data adabter to your window , this data adabter based on the table you need to modify, use this data adabter to genrate a dataset and make sure you add it to the formyou are working on, bing your combo to the dataset (set dataset as the combo datasource), on the form load use the adabter to fill the dataset (adabter.fill(dataset)), after the user finishs the editing and you decide to save use the adabter to update the dataset (adabter.update(dataset)), this should de the trick