Click here to Skip to main content
12,957,071 members (61,978 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
Hi,


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
 
good
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.
  Permalink  

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
OriginalGriff 6,924
CHill60 3,550
Maciej Los 3,312
ppolymorphe 2,120
Jochen Arndt 1,973


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 17 Jan 2013
Copyright © CodeProject, 1999-2017
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