How to prevent adding item to excel 2007 if it found before

Question

I work in c# 2015 windows form

I have excel file 2007 name book 1 and sheet inside it name sheet 1

sheet 1 have two column

UserID

UserName

I need when insert new record from windows form c#

to check if the value of User Name found before show to client message tell him that Username exist before

UserID UserName

1 michel

2 marten

IF user enter in textbox value of marten then click button insert

give me message that this name exist before

using c# windows form

How to do that by c# if possible using oledb

Mani Kandan · Answer

Hi Yes Of course... Did you try this process? Before adding a user you have to check if the user exist or not. 1) A user enter a name inside textbox after 2) You have write query: string uname = select username from Tble_user where username=+ 'txtusername.text' +  ; 3) Then check if condition: if uname is exist do a message like user is exist else do your save action. Thanks Abhilash.J.A