Click here to Skip to main content
11,584,040 members (62,987 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: ASP.NET C#4.0

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
0 OriginalGriff 480
1 Sergey Alexandrovich Kryukov 285
2 virusstorm 268
3 Dave Kreskowiak 230
4 Richard Deeming 220
0 OriginalGriff 1,523
1 Sergey Alexandrovich Kryukov 995
2 Abhinav S 696
3 Dave Kreskowiak 621
4 Suvendu Shekhar Giri 568

Advertise | Privacy | Mobile
Web04 | 2.8.150603.1 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2015
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