Vista - visible=true evaluation

asp.net 2.0 and language is c#

I need to add a single checkbox on an aspx page based on evaluating
two aspects of the items the customer has placed in the shopping
cart.


The price must be $100 or more and the brand must be a specific
brand.
There may be multiple items in the cart but there can be only one
checkbox. I wrote some code on the codebehind, but it only evaluates
the last item in the cart. How can I evaluate all o the items?


Thanks in advance for any help.

That highly depends on two factors:

-Do you want to do this client side or server side?
-How is your data organized?

"duncfair" <duncfair@xxxxxx> wrote in message
news:2c30ce99-395d-43f9-b0dd-a714047c6ed7@xxxxxx

Server side solution.

Data is MS SQL server and all datasets, etc. are accessed via stored
procedures.

On Apr 9, 11:59*am, "Michel Racicot" <mraci...@xxxxxx> wrote:

In that case, maybe the problem resides in the browsing of all item in the
cart.

Paste your stored procedure / SQL Code that must evaluate all items in the
cart and the code that handles the checkbox and maybe we can help you.


"duncfair" <duncfair@xxxxxx> wrote in message
news:236b2ede-ac1c-4fa7-9ed2-8446cdac1c54@xxxxxx
Server side solution.

Data is MS SQL server and all datasets, etc. are accessed via stored
procedures.

On Apr 9, 11:59 am, "Michel Racicot" <mraci...@xxxxxx> wrote:

The stored procedure is fine; SQL programming is my comfort zone.

Here is the code:

-------------------------------------------------------

Dansko_chkbx.Visible = false;
ProductDetailTableAdapter productadp = new
ProductDetailTableAdapter();
DataTable productdatatable =
productadp.GetDanskoProductDetailById(Convert.ToInt32(Orderid.ToString()));
foreach (DataRow ProductDataRow in productdatatable.Rows)
{
DanskoPrice =
Convert.ToDecimal(ProductDataRow["Price"].ToString());
Danskobrandname =
ProductDataRow["BrandName"].ToString();

if ((Danskobrandname.Contains("Dansko")) &&
(DanskoPrice > 100))
{
Dansko_chkbx.Visible = true;
}
else
{
Dansko_chkbx.Visible = false;
}
}

----------------------------------------------

On Apr 10, 6:24*am, "Michel Racicot" <mraci...@xxxxxx> wrote:

This is the problem ...

You keep changing the visibility of your checkbox at every row because
Dansko_chkbx.Visible is set inside the foreach statement!!! (and it will be
set for every row, so the value it will get at the end will indeed be for
the last iteration of your foreach)





"duncfair" <duncfair@xxxxxx> wrote in message
news:b75bdad2-e7bc-4b36-b5f1-e4ddc8179bac@xxxxxx
The stored procedure is fine; SQL programming is my comfort zone.

Here is the code:

-------------------------------------------------------

Dansko_chkbx.Visible = false;
ProductDetailTableAdapter productadp = new
ProductDetailTableAdapter();
DataTable productdatatable =
productadp.GetDanskoProductDetailById(Convert.ToInt32(Orderid.ToString()));
foreach (DataRow ProductDataRow in productdatatable.Rows)
{
DanskoPrice =
Convert.ToDecimal(ProductDataRow["Price"].ToString());
Danskobrandname =
ProductDataRow["BrandName"].ToString();

if ((Danskobrandname.Contains("Dansko")) &&
(DanskoPrice > 100))
{
Dansko_chkbx.Visible = true;
}
else
{
Dansko_chkbx.Visible = false;
}
}

----------------------------------------------

On Apr 10, 6:24 am, "Michel Racicot" <mraci...@xxxxxx> wrote:

OK. So how do I evaluate if any of the rows meet the criteria?

On Apr 11, 12:55*pm, "Michel Racicot" <mraci...@xxxxxx> wrote:

Sorry to tell you that but this is beginner's stuff... I highly suggest that
you try to understand what you're doing a little better before.

There is several way to achieve the result.

Since it can be for a school project and I don't want to give the answer
crudely, here comes a hint for one possible solution:

You can use a variable.

Another hint for another possible solution:

When if ((Danskobrandname.Contains("Dansko")) && (DanskoPrice > 100)) is
true, you don't even have to evaluate the reminder items. It saves some
iterations...

Good luck.


"duncfair" <duncfair@xxxxxx> wrote in message
news:78faa082-29d4-4442-b24f-09a560357341@xxxxxx
OK. So how do I evaluate if any of the rows meet the criteria?

On Apr 11, 12:55 pm, "Michel Racicot" <mraci...@xxxxxx> wrote:

Thanks! I will end the loop when I get a 'true'.

Unfortunately, it's not a school project. I am a sql db programmer
struggling through web development tasks.

On Apr 14, 6:56*am, "Michel Racicot" <mraci...@xxxxxx> wrote: