Re: SqlDataTable.Rows.Find(Multiple Primary Keys)

[John Bonds]

Here's some code. I'm getting a "input string was not in a correct format"
error

Dim pFindTheseVals(1) As Object
pFindTheseVals(0) = AddressType
pFindTheseVals(1) = Customer.ID
Dim pDataRow As DataRow = SQLDataTable.Rows.Find(pFindTheseVals)

Thanks

 

[John Bonds]

Ok, still going here.

I think it has to do with the 'order' of the primary keys in the DataTable.
If you get this error, rearrange your Object Array to reflect the proper
ordering of the primary keys in the DataTable.

Is there a better way to do this someone?

Thanks,

John

 

[Ron Allen]

John,
No, you just have to add items tothe object array in the order that the
fields are laid out in the table.

Ron Allen