Click here to Skip to main content
13,551,196 members
Rate this:
Please Sign up or sign in to vote.
See more:

Currently i'm doing Bulk data insert from Excel to SQL database.
My total logic is working fine for inserting. But my question is column name should be unique , now i want to check that.

for ex:

column1 : Title

but client enter the column1 value is "title"

In this case i don't want to insert data i want to display the error message .

How to do this can any one help me to resolve this issue.

Thanks in Advance.....
Posted 16-Jan-13 20:05pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

you can use Regex class for such values.

string originalValue="Title";
string enteredValue="title";
static bool IsValid(string orgValue, string entValue)
    return Regex.IsMatch(orgValue,"^" + entValue + "$"); //Remember, this will check for the whole string

If it returns false, Flag an Error.

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04-2016 | 2.8.180515.1 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2018
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100