We help IT Professionals succeed at work.

Want to update a SQL field based upon source select from dropdown box

Medium Priority
156 Views
Last Modified: 2013-11-26
This should (and probably is) be easy...
I have a drop down box I use to pull a list of devices from SQL. When the user selects one of these devices it populates a DetailsView with a Notes field. What I want it to do is when the user selects a device from the drop down I want it to retrieve the Notes field but then be editable so they can update any information.

This is VB Studio 2005 web

Thoughts, ideas?????
Comment
Watch Question

Commented:
fetch your all data into a dataset.datatable and bind it with controls on the form.
capture the drop down change event.. and just move your binding source current to that particular record. the detail view will be automatically populated.... edit it and then save it.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.