How filter dropdownlist data

[Cirene]

I have a dropdownlist that is bound to a query.

Is it possible to further filter the items after the fact?

The dropdownlist is inside a
createuserwizard/createuserstep/contenttemplatecontainer.

Thanks.

[Eliyahu Goldin]

If the query populates a DataTable, you can run Select method with a filter
condition to produce a filtered array of rows.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>I have a dropdownlist that is bound to a query.

Is it possible to further filter the items after the fact?

The dropdownlist is inside a
createuserwizard/createuserstep/contenttemplatecontainer.

Thanks.

[Cirene]

I already have it bound to a sqldatasource and it's getting data. That's no
problem.

There are certain conditions where I want to PREVENT some selected items
from appearing in the drop down list. Any ideas on how to do this?

Thanks!
"Eliyahu Goldin" <RE**************************@mMvVpPsS.orgwrote in
message news:ej***************@TK2MSFTNGP06.phx.gbl...

If the query populates a DataTable, you can run Select method with a
filter condition to produce a filtered array of rows.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>>I have a dropdownlist that is bound to a query.

Is it possible to further filter the items after the fact?

The dropdownlist is inside a
createuserwizard/createuserstep/contenttemplatecontainer.

Thanks.

[Eliyahu Goldin]

You can handle ddl's DataBound or PreRender or Page.PreRender event to
remove items from the ddl's Items collection.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:ug**************@TK2MSFTNGP03.phx.gbl...

>I already have it bound to a sqldatasource and it's getting data. That's
no problem.

There are certain conditions where I want to PREVENT some selected items
from appearing in the drop down list. Any ideas on how to do this?

Thanks!
"Eliyahu Goldin" <RE**************************@mMvVpPsS.orgwrote in
message news:ej***************@TK2MSFTNGP06.phx.gbl...

>If the query populates a DataTable, you can run Select method with a
filter condition to produce a filtered array of rows.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>>>I have a dropdownlist that is bound to a query.

Is it possible to further filter the items after the fact?

The dropdownlist is inside a
createuserwizard/createuserstep/contenttemplatecontainer.

Thanks.

[George Ter-Saakov]

How about not bounding it
just populate the dropdown manually...

something like (in pseducode):

DataTable dt = GetData("SELECT...");
foreach(DataRow r in dt.Rows)
{
ListItem it = new ListItem((string)r[0], (string)r[1]);
cmbMyDropDown.Items.Add(it);
}
George.
"Cirene" <ci****@nowhere.comwrote in message
news:ug**************@TK2MSFTNGP03.phx.gbl...

>I already have it bound to a sqldatasource and it's getting data. That's
no problem.

There are certain conditions where I want to PREVENT some selected items
from appearing in the drop down list. Any ideas on how to do this?

Thanks!
"Eliyahu Goldin" <RE**************************@mMvVpPsS.orgwrote in
message news:ej***************@TK2MSFTNGP06.phx.gbl...

>If the query populates a DataTable, you can run Select method with a
filter condition to produce a filtered array of rows.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>>>I have a dropdownlist that is bound to a query.

Is it possible to further filter the items after the fact?

The dropdownlist is inside a
createuserwizard/createuserstep/contenttemplatecontainer.

Thanks.

[Cirene]

i'll give it try - thanks everyone

"Eliyahu Goldin" <RE**************************@mMvVpPsS.orgwrote in
message news:er**************@TK2MSFTNGP04.phx.gbl...

You can handle ddl's DataBound or PreRender or Page.PreRender event to
remove items from the ddl's Items collection.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:ug**************@TK2MSFTNGP03.phx.gbl...

>>I already have it bound to a sqldatasource and it's getting data. That's
no problem.

There are certain conditions where I want to PREVENT some selected items
from appearing in the drop down list. Any ideas on how to do this?

Thanks!
"Eliyahu Goldin" <RE**************************@mMvVpPsS.orgwrote in
message news:ej***************@TK2MSFTNGP06.phx.gbl...

>>If the query populates a DataTable, you can run Select method with a
filter condition to produce a filtered array of rows.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl.. .
I have a dropdownlist that is bound to a query.

Is it possible to further filter the items after the fact?

The dropdownlist is inside a
createuserwizard/createuserstep/contenttemplatecontainer.

Thanks.

[=?Utf-8?B?TWlsb3N6IFNrYWxlY2tpIFtNQ0FEXQ==?=]

Howdy,

You can also use sqldatasource.FilterExpression and FilterParameters to
filter out results fetched from the database.

HTH
--
Milosz
"Cirene" wrote:

I already have it bound to a sqldatasource and it's getting data. That's no
problem.

There are certain conditions where I want to PREVENT some selected items
from appearing in the drop down list. Any ideas on how to do this?

Thanks!
"Eliyahu Goldin" <RE**************************@mMvVpPsS.orgwrote in
message news:ej***************@TK2MSFTNGP06.phx.gbl...

If the query populates a DataTable, you can run Select method with a
filter condition to produce a filtered array of rows.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...

>I have a dropdownlist that is bound to a query.

Is it possible to further filter the items after the fact?

The dropdownlist is inside a
createuserwizard/createuserstep/contenttemplatecontainer.

Thanks.

[Cirene]

Does the dropdown have a similar property? Thanks!!

"Milosz Skalecki [MCAD]" <mi*****@DONTLIKESPAMwp.plwrote in message
news:8B**********************************@microsof t.com...

Howdy,

You can also use sqldatasource.FilterExpression and FilterParameters to
filter out results fetched from the database.

HTH
--
Milosz
"Cirene" wrote:

>I already have it bound to a sqldatasource and it's getting data. That's
no
problem.

There are certain conditions where I want to PREVENT some selected items
from appearing in the drop down list. Any ideas on how to do this?

Thanks!
"Eliyahu Goldin" <RE**************************@mMvVpPsS.orgwrote in
message news:ej***************@TK2MSFTNGP06.phx.gbl...

If the query populates a DataTable, you can run Select method with a
filter condition to produce a filtered array of rows.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
I have a dropdownlist that is bound to a query.

Is it possible to further filter the items after the fact?

The dropdownlist is inside a
createuserwizard/createuserstep/contenttemplatecontainer.

Thanks.

[=?Utf-8?B?TWlsb3N6IFNrYWxlY2tpIFtNQ0FEXQ==?=]

Cirene,

No it doesn't as the SqlDataSource is responsible for providing the data
(one of the possible "data set" providers.

regards
--
Milosz
"Cirene" wrote:

Does the dropdown have a similar property? Thanks!!

"Milosz Skalecki [MCAD]" <mi*****@DONTLIKESPAMwp.plwrote in message
news:8B**********************************@microsof t.com...

Howdy,

You can also use sqldatasource.FilterExpression and FilterParameters to
filter out results fetched from the database.

HTH
--
Milosz
"Cirene" wrote:

I already have it bound to a sqldatasource and it's getting data. That's
no
problem.

There are certain conditions where I want to PREVENT some selected items
from appearing in the drop down list. Any ideas on how to do this?

Thanks!
"Eliyahu Goldin" <RE**************************@mMvVpPsS.orgwrote in
message news:ej***************@TK2MSFTNGP06.phx.gbl...
If the query populates a DataTable, you can run Select method with a
filter condition to produce a filtered array of rows.

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Cirene" <ci****@nowhere.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
I have a dropdownlist that is bound to a query.

Is it possible to further filter the items after the fact?

The dropdownlist is inside a
createuserwizard/createuserstep/contenttemplatecontainer.

Thanks.