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

Question

1.00/5 (1 vote)

See more:

.NET4.5

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

What I have tried:

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

Posted 28-Jan-17 12:18pm

ahmed_sa

Updated 4-Feb-17 11:12am

Add a Solution

Comments

[no name] 28-Jan-17 20:02pm

If your query returns a result, then the information already exists.

Richard MacCutchan 29-Jan-17 3:57am

Obviously you need to look up the name first to see if it already exists in the worksheet.

CHill60 30-Jan-17 8:13am

Where is the code you have already tried and where are you stuck?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 12829420 · Answer 1 · 2017-02-04T11:12:00

So you should do a Vlookup on the column with the userID in it (I assume you're using SQL to check), then return the next column information, if it returns information, then that UserID is already in use. No need to show the information, just notify the windows form to try again.

As you are using a UserID, I'm assuming that you are trying to create a list of users for access validation. If you are trying to validate users, you need to rethink the columns and the way it's used.

Give us some more information on why you are doing this, because it may be possible to help you find a better method.