>pKcno = myReader.Item("kcno") <--it will return error when the field "kcno" doesn't exist
>
>any method to check the field exist or not first , if not exist, I want to skip the above statement.
>
>Thanks
I don't have the IDE handy, but can you do something like so:
If myReader.Item("kcno") IsNot Nothing Then
pKcno = myReader.Item("kcno")
EndIf
This is assuming myReader.Item("kcno") = Nothing if the field does not exist.