Thanks for reply, Ken.
I would like not use the Try Catch, because it seems be a bit slow (the
first time is called, at least).
I've changed everything to a ArrayList collection and stored others arrays
in each item of the arraylist (and concatened that two IDs into one string).
The performance now turn terrific faster, but I don't know if is the best
form yet.
[]s
Cesar
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:Os****************@TK2MSFTNGP12.phx.gbl...
Hi,
When you add a primary key to a datatable you can specify more
than one column. If you use the 2 columns for the primary key you will get
an error when trying to add a duplicate row. Add the row in a try catch
block. If you get an error you are trying to add a duplicate.
http://msdn.microsoft.com/library/de...rykeytopic.asp
Ken
--------------------
"Cesar Ronchese" <ronchese*smlinfo.com.br> wrote in message
news:us**************@TK2MSFTNGP11.phx.gbl...
Hey guys.
I'm using a DataView to store a lot (amoung 2000 lines) of configuration
and
objects and this DataView is indexed by two columns.
That 2000 lines are created in a loop, with the DataView already indexed
to
improve search, because I need to check if the record already exists
before
create a new. The problem I noticed is this is too low to store new data,
perhaps because the index engine is not optimized for that kind of use.
My questions are:
1. is DataView really not good for that?
2. What the best collection or something I can use to do that job?
Cesar