-
Drop down list box with SQL server
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
-
is this a desktop or webbased application
-
Drop down list box with SQL server
Hi
Thanks for the reply . I am developing a windows application with MS Visual studio 2003.NET ( VB.NET )
Thanks
-
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
Similar Threads
-
By alex in forum Database
Replies: 3
Last Post: 11-03-2005, 05:27 AM
-
By Levi Nkata in forum Database
Replies: 3
Last Post: 04-11-2001, 09:31 AM
-
By David Hay in forum Database
Replies: 2
Last Post: 04-02-2001, 07:11 PM
-
By Richard in forum ASP.NET
Replies: 0
Last Post: 01-12-2001, 11:20 AM
-
By Becky in forum Database
Replies: 1
Last Post: 07-11-2000, 03:27 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|