[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

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

Posted on 2008-01-29
1
Medium Priority
?
148 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?????
0
Comment
Question by:edrz01
1 Comment
 
LVL 7

Accepted Solution

by:
AUmidh earned 750 total points
ID: 20775199
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.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
Suggested Courses

591 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question