Using Drop Down List with Gridview Query

[Bishop]

I have a query similar to this: "Select ProductID, ProductName,
ProductDescript ion where MFGID = @MFGID". I use a Drop Down List populated
with the MFGID's to populate the @MFGID variable. My question is, using
this technique, is there a way to say "Return all Manufactures"? If not,
any suggestions on a good technique for this?

[David Wier]

You might add a 'Select All' item to the top of the dropdownlist (item 0) -
give it a value of -1
Then, make your stored procedure have an if/then, so that if @MFGID is -1,
return all, if not, use your other sql statement

You can do this in code, also, if you're not using Stored Procedures
(however, doing so would probably be a good idea)

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Bishop" <no****@nospam. comwrote in message
news:ei******** *****@TK2MSFTNG P06.phx.gbl...

I have a query similar to this: "Select ProductID, ProductName,
ProductDescript ion where MFGID = @MFGID". I use a Drop Down List

populated

with the MFGID's to populate the @MFGID variable. My question is, using
this technique, is there a way to say "Return all Manufactures"? If not,
any suggestions on a good technique for this?

[Bishop]

The query is bound to the gridview and I'm trying to avoid changing it with
my VB Code. Can I use If/Then in my SQL query without it being a stored
procedure?

"David Wier" <da********@noS pamhotmail.comw rote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..

You might add a 'Select All' item to the top of the dropdownlist (item
0) -
give it a value of -1
Then, make your stored procedure have an if/then, so that if @MFGID is -1,
return all, if not, use your other sql statement

You can do this in code, also, if you're not using Stored Procedures
(however, doing so would probably be a good idea)

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Bishop" <no****@nospam. comwrote in message
news:ei******** *****@TK2MSFTNG P06.phx.gbl...

>I have a query similar to this: "Select ProductID, ProductName,
ProductDescrip tion where MFGID = @MFGID". I use a Drop Down List

populated

>with the MFGID's to populate the @MFGID variable. My question is, using
this technique, is there a way to say "Return all Manufactures"? If not,
any suggestions on a good technique for this?

[David Wier]

You'd just need to add an if/then in your code, where you are implementing
your Select statement:
if (whatever) then
mySQLTExt="Sele ct.....
else
mySQLTExt="Sele ct...something else"
end if

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Bishop" <no****@nospam. comwrote in message
news:u6******** ******@TK2MSFTN GP02.phx.gbl...

The query is bound to the gridview and I'm trying to avoid changing it

with

my VB Code. Can I use If/Then in my SQL query without it being a stored
procedure?

"David Wier" <da********@noS pamhotmail.comw rote in message
news:%2******** ********@TK2MSF TNGP02.phx.gbl. ..

You might add a 'Select All' item to the top of the dropdownlist (item
0) -
give it a value of -1
Then, make your stored procedure have an if/then, so that if @MFGID

is -1,

return all, if not, use your other sql statement

You can do this in code, also, if you're not using Stored Procedures
(however, doing so would probably be a good idea)

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Bishop" <no****@nospam. comwrote in message
news:ei******** *****@TK2MSFTNG P06.phx.gbl...

I have a query similar to this: "Select ProductID, ProductName,
ProductDescript ion where MFGID = @MFGID". I use a Drop Down List

populated

with the MFGID's to populate the @MFGID variable. My question is,

using

this technique, is there a way to say "Return all Manufactures"? If

not,

any suggestions on a good technique for this?

[Bishop]

OK, Thanks for the info!

"David Wier" <da********@noS pamhotmail.comw rote in message
news:us******** ******@TK2MSFTN GP04.phx.gbl...

You'd just need to add an if/then in your code, where you are implementing
your Select statement:
if (whatever) then
mySQLTExt="Sele ct.....
else
mySQLTExt="Sele ct...something else"
end if

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Bishop" <no****@nospam. comwrote in message
news:u6******** ******@TK2MSFTN GP02.phx.gbl...

>The query is bound to the gridview and I'm trying to avoid changing it

with

>my VB Code. Can I use If/Then in my SQL query without it being a stored
procedure?

"David Wier" <da********@noS pamhotmail.comw rote in message
news:%2******* *********@TK2MS FTNGP02.phx.gbl ...

You might add a 'Select All' item to the top of the dropdownlist (item
0) -
give it a value of -1
Then, make your stored procedure have an if/then, so that if @MFGID

is -1,

return all, if not, use your other sql statement

You can do this in code, also, if you're not using Stored Procedures
(however, doing so would probably be a good idea)

--
David Wier
MVP/ASPInsider
http://aspnet101.com
http://aspexpress.com
"Bishop" <no****@nospam. comwrote in message
news:ei******** *****@TK2MSFTNG P06.phx.gbl...
I have a query similar to this: "Select ProductID, ProductName,
ProductDescrip tion where MFGID = @MFGID". I use a Drop Down List
populated
with the MFGID's to populate the @MFGID variable. My question is,

using

>this technique, is there a way to say "Return all Manufactures"? If

not,

>any suggestions on a good technique for this?