I am having a bit of a brain fart on this. I have a table that is returned as a dataset \ datatable.
The table is laid out like this.
Type sysid DESCRIPTION
0 BLANK BLANK
1 OnlineTkt Online Ticket
2 InstantTkt Instant Ticket
4 Discount Discount
5 Merchandise Merchandise
6 PartnerPlay Partner Play
7 DoubleTripler Doubler/Tripler
9 2ndChance Second Chance
I would expect this code to return the value dt.Rows(4)("Description") Discount, but instead return Merchandise. Is there away I can look at this based on the Type Column versus Row number? In other words Select Description where TYPE = x ( which should is 4 )