Drop down list box with SQL server


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Drop down list box with SQL server

  1. #1
    Join Date
    Oct 2005
    Posts
    95

    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

  2. #2
    Join Date
    Feb 2006
    Posts
    4
    is this a desktop or webbased application

  3. #3
    Join Date
    Oct 2005
    Posts
    95

    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

  4. #4
    Join Date
    Feb 2006
    Posts
    4
    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

  1. SQL Mail Problem
    By alex in forum Database
    Replies: 3
    Last Post: 11-03-2005, 06:27 AM
  2. Changing Server Name
    By Levi Nkata in forum Database
    Replies: 3
    Last Post: 04-11-2001, 10:31 AM
  3. SQL Server Agent wont auto start
    By David Hay in forum Database
    Replies: 2
    Last Post: 04-02-2001, 08:11 PM
  4. Replies: 0
    Last Post: 01-12-2001, 12:20 PM
  5. SQL server administrative knowledge
    By Becky in forum Database
    Replies: 1
    Last Post: 07-11-2000, 04: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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center