concurrency issue when two users inserting some values.

Question

When two users trying to inser for same record at same time then two rows are generating instead of updating other one.

But same scenario is working fine in case of update.but we can not use locks.

If there is any other any way then please advise in vb.net (sql)