checking duplicate

[shahid]

hi,

i m developing a mobile application for pda.. with sqlserverce.
i want to check duplicate thru

mydataadapter.hasrows

it's give error that this is not suported with it
how can i check duplicate

[shahid]

hello...........
no one knows about it?

[Strider]

why are you using .HasRows() to check for a duplicate?

why not use and executeScalar statement, or catch the duplicate key exception when you try and insert

[Shaggy Hiker]

I agree with Strider. Perhaps you could post a bit more code around this. Using a data adapter (which I gather from your variable name) would be slow, if possible.

[shahid]

i got a solution...i m using
if dataadapter.read() then
''have some rows
else
''now rows..
end if