Wrox Programmer Forums
|
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 July 15th, 2010, 01:41 PM
Registered User
 
Join Date: Jul 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default placeholder in query

Guys,

I need your help; In the query I am trying to pass the input from drop down box as

sqlcmd="select * from abc where xyz='dropdownlist1.selecteditem'"

but I am sure that, in this case "dropdownlist1.selecteditem" will be considered as plain string, so wanted to pass it in placeholder.

How can I achive this? Please help.

Thanks.
 
Old July 22nd, 2010, 08:30 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 996
Thanks: 2
Thanked 11 Times in 11 Posts
Send a message via Yahoo to melvik
Default

My friend:
First it depend what u r displaying & what u r valuing ur combo & also ur table
Code:
abc
well, simply u can use - text of ur drop down as:
Code:
sqlcmd="select * from abc where xyz='dropdownlist1.SelectedText'"
& value of ur drop down as:
Code:
sqlcmd="select * from abc where xyz='dropdownlist1.SelectedValue'"
u may convert ur selected value as below if ur using not string for value
Code:
Convert.ToInt32(comboBoxOffice.SelectedValue)
__________________
Always,
Hovik Melkomian.
 
Old August 13th, 2010, 06:35 AM
Authorized User
 
Join Date: May 2010
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi sir_com,
Do the fallowing change in sqlcmd
sqlcmd="select * from abc where xyz=’”+dropdownlist1.selecteditem.ToString()+”'"

Thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
Placeholder grstad ASP.NET 2.0 Basics 6 May 23rd, 2008 09:03 AM
Navigate away from a Content Placeholder slbibs SharePoint Development 0 September 4th, 2007 03:28 PM
placeholder controls rocksbhavesh ASP.NET 1.0 and 1.1 Professional 3 May 17th, 2007 08:11 AM
placeholder controls -- pulling data Fubar ASP.NET 1.0 and 1.1 Professional 6 September 8th, 2005 09:08 AM
Problems with placeholder and textboxes sean ASP.NET 1.0 and 1.1 Professional 0 January 13th, 2004 11:49 AM





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