Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Basics
|
ASP.NET 2.0 Basics If you are new to ASP or ASP.NET programming with version 2.0, this is the forum to begin asking questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old March 17th, 2007, 10:34 AM
GS GS is offline
Authorized User
 
Join Date: Sep 2003
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default Updating a table from a dropdown

Using ASP .net 2.0

Hi all,

I have a grid view with a dropdown list.

When configuring the datasource for the GridView, I am using the wizard to create an update statement.

Trying to use the query builder how would I be able to do the following:

My dropdownlist is populated using a lookup table (TABLE2)
TABLE2 contains ID and description (description is what is populated in the dropdown).

TABLE1 contains the ID from TABLE1

I want to update and ID in TABLE1 taking the dropdown value.

Sorry if this sounds stupid !
 
Old March 18th, 2007, 03:33 AM
Authorized User
 
Join Date: Apr 2006
Posts: 79
Thanks: 1
Thanked 0 Times in 0 Posts
Send a message via AIM to anujrathi Send a message via MSN to anujrathi Send a message via Yahoo to anujrathi
Default

ur question is not clear..
Pls post ur code also..
 
Old March 18th, 2007, 07:22 AM
GS GS is offline
Authorized User
 
Join Date: Sep 2003
Posts: 30
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Apologies for being vague.

I have resolved this now as I didn't realise when configuring the datasource I can actually get the wizard to generate insert and update statements. This seems to have worked.





Similar Threads
Thread Thread Starter Forum Replies Last Post
2 table fields into 1 dropdown selectbox sdagger Classic ASP Basics 2 September 23rd, 2008 03:42 PM
Updating one table with data from another table dirtdog22 Access VBA 1 January 21st, 2008 04:41 PM
Updating table from dropdown list GS ASP.NET 2.0 Professional 2 March 18th, 2007 07:22 AM
Updating a textbox from DropDown selection kjord ASP.NET 1.0 and 1.1 Professional 4 November 7th, 2006 04:04 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.