if statement on sql c# asp.net

Question

I have 2 sql tables

 items with the desgin:
 minBuy (int number)



 purchase with the desgin:
id

At items i have column "minBuy" - as long as purchase id not >= to minBuy, i want to show img that display "X". when it's >= i want to display img that shown "V". i'm using sql with c#.

i have the two img's .... v.png and x.png.

how can i do that at c# with

  if(purchaseid >= minBuy)

   v.visble = true;

i heard somthing about to do fetch, what is it and how that can help me here?

are you returning purchase ID , min buy and i from db?

Mahesh KP
– Mahesh KP

2011-06-01 11:51:45 +00:00
Commented Jun 1, 2011 at 11:51 — Mahesh KP
– Mahesh KP, Commented Jun 1, 2011 at 11:51

Leons · Accepted Answer · 2011-06-01 11:50:14Z

2

You can do that with a case statement. For example:

CASE WHEN purchaseid >= minBuy THEN 1 ELSE 0 END as MinBuyInd

Now you can use the MinBuyInd column to determine which image to display.

answered Jun 1, 2011 at 11:50

Leons

2,6741 gold badge23 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mithir · Accepted Answer · 2011-06-01 11:54:48Z

0

if you have an asp:Image ID="img" tag.

than you can just set the source

 if(purchaseid >= minBuy)
   img.ImageUrl = "url of V";
else
   img.ImageUrl = "url of X";

answered Jun 1, 2011 at 11:54

Mithir

2,4413 gold badges27 silver badges40 bronze badges

3 Comments

Oshrib Over a year ago

the if statement is the easy part, but how i do it to sql tables.

Mithir Over a year ago

I think you need to elaborate a little bit...when I look at the names of the variables, it looks like you are comparing an ID number to a price... so maybe explain what is what.

Oshrib Over a year ago

ok, what i need to do is - i have page.aspx , i have label that shown what is the minimum number (from item table) to open the auoction ... i.e the minimum number is 5... after i got 5 bids (table: purchase) - the auoction start and at other lablel shown img: V.

Collectives™ on Stack Overflow

if statement on sql c# asp.net

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related