Rows.contains sometimes return false even though the value is there

abutaher

Hi,
I'm using the following method to find the itemcode in a table.

Expand|Select|Wrap|Line Numbers

 dim ds as new dataset

dim mvItem as object
 
Dim tmpCol(1) As DataColumn

tmpCol(0) = dsPDT.Tables(0).Columns(0)

dsPDT.Tables(0).PrimaryKey = tmpCol
 
mvItem = dsBoss.Tables(0).Rows(i)(0).ToString

If dsPDT.Tables(0).Rows.Contains(mvItem) = False Then

     do something

else

     do something

endif
 
ITEM_CODE                                 NOT NULL VARCHAR2(13)

ITEM_SCAN_CODE                                     VARCHAR2(20)

ITEM_SUPL_CODE                                     VARCHAR2(5)

Here ITEM_CODE is the primary key and ITEM_CODE contains 9 digits and 13 digit.

Sometime the contains retunring false even though the Item is ther in the dataset.

Could anyone help me please to solve this issue ?

Plater

.contains comapres objects types, not just a human readable value.
If your string value is "3456" because the column it looked at was an integer column with that value, doing a .contains on an integer column with a string representation will fail.
You have declared mvItem as an object, but are always assigning it to be a string with that ToString call, I think getting rid of that will help solve your problem?

abutaher

Quote:

Originally Posted by Plater

.contains comapres objects types, not just a human readable value.
If your string value is "3456" because the column it looked at was an integer column with that value, doing a .contains on an integer column with a string representation will fail.
You have declared mvItem as an object, but are always assigning it to be a string with that ToString call, I think getting rid of that will help solve your problem?

Dear,
I've removed ToString from the following line but still it is returning false.

Expand|Select|Wrap|Line Numbers

mvItem = dsBoss.Tables(0).Rows(i)(0).ToString

ITEM_CODE I've declared as string but it contains numeric value only(i.e. 100045020 )

Plater

Does it EVER return true? Its looking for the primary key which you just declared which column was the primary key?

Have you tried setting a break point and stepping through the code, to see what it is being compared to?

Rows.contains sometimes return false even though the value is there

re: Rows.contains sometimes return false even though the value is there

re: Rows.contains sometimes return false even though the value is there

re: Rows.contains sometimes return false even though the value is there

/bytes/development

/bytes/it

/bytes/about