I am using vb.net2003.
Trying to load a datset and then compare a value. If conditions are satisfied do some thing
here is the code

mySearchString = "Select animalID,Status, Type from tblInventory where animalID=" & txtanimalID.Text
            DsInventory1.Clear()
            daInventory.SelectCommand.CommandText = mySearchString
            daInventory.Fill(DsInventory1)

"Data set is loading successfully No problem. I have put a message.box.show(DsInventory1.tblInventory(0).Type )for testing purposes which shows inventory item is CAT type) "


if DsInventory1.tblInventory(0).Type="CAT" then

subCat()
elseif DsInventory1.tblInventory(0).Type="DOG" then

subDog()

else messagebox.show("no pets in stock")


program zips thru and messagebox no pets in stock comes up

why my conditon is not matching. VB GURUs please help me quick.

Raj






rSd

Have you stepped thru the code to see what the actual values for .Type are? Can you find some that *should* match but aren't?

-Peter

Yes I am geeting .type = CAT

   mySearchString = "Select animalID,Status, Type from tblInventory where animalID=" & txtanimalID.Text
            DsInventory1.Clear()
            daInventory.SelectCommand.CommandText = mySearchString
            daInventory.Fill(DsInventory1)

aType = DsInventory1.tblInventory(0).Type
Messagebox.show(aType)
it gives me output of CAT
if DsInventory1.tblInventory(0).Type="CAT" then

subCat()
elseif DsInventory1.tblInventory(0).Type="DOG" then

subDog()

else messagebox.show("no pets in stock")


program zips thru and messagebox no pets in stock comes up

why my conditon is not matching. VB GURUs please help me quick.

Raj


rSd

How is your table defined? Is it possible that the type field is a char field that is more than 3 characters? Thus the actual value coming back is something like:
   "CAT_____" ( _ character represents a space)
which is not equal to
   "CAT"

Maybe you need to trim the database value before you compare.

Better still... "Type" type db fields are better suited as integers that relate to a lookup table. Then you run into fewer problems trying to compare them.

-Peter

You hit right on the nail. your suggestion worked.

First 2 record had problem
and i was testing by first 2 records ID.
Once I deleted first 2 records program started working.


Thank you very much

rSd