arraylist problem

[gomzi]

i have two arraylists,
say arraylist1 and arraylist2.
now i keep adding items to both arraylists depending on some criteria.

now in some cases, arraylist2 may not have a value at a particular index while arraylist1 may have one.

later on when i add the values in the list to a database, i get an error saying that there is no value at that index for arraylist2 (its trivial that the error should show up).

i would like to know as to how i should check the arraylist2 to see if there is a value at that index or not.

[shweta123]

Hi,

How are you comparing the values of Arraylists before inserting into database?
If Arraylist2 only is containing No values you can check it this way,

for i=0 to arraylist1.count-1
if isDBNull(arraylist1.items(i))=true
''''''do some processing or insert empty string
end if
next

[gomzi]

Hi,

How are you comparing the values of Arraylists before inserting into database?
If Arraylist2 only is containing No values you can check it this way,

for i=0 to arraylist1.count-1
if isDBNull(arraylist1.items(i))=true
''''''do some processing or insert empty string
end if
next

thx a lot..m currently using a try catch statement.
which do you think is better?