How to remove characters in database with c# code behind?

Question

4.00/5 (2 votes)

See more:

there is a database table it has lesson codes some people insert wrong lessoncodes

same lessons has different alots of codes MATH103 MATH-103 MATH 103 MATH_103 These are same lesson

I will get this lessons from database to gridview like one lesson(I will use distinct) but I will not remove from database this control must be c# code behind

how to remove these characters

I dont know these lesson codes has which characters ? - / _ " " etc.

Posted 12-Mar-13 3:05am

Member-2338430

Add a Solution

Comments

[no name] 12-Mar-13 9:12am

Not able to understand question correctly. Do you have problem of duplicate code or with invalid (restricted) symbols.

joshrduncan2012 12-Mar-13 9:16am

If I understand this correctly, I think the OP needs to know how to parse strings and look for individual characters to replace.

Nandakishore G N 12-Mar-13 9:18am

use regex, match it and remove that characters.

2 solutions

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)

Abhinav S · Answer 1 · 2013-03-12T03:15:00

Solution 1

Quite easy to do if you use LINQ.

If you have loaded all the records in a collection, you can simply run Distinct on it.
For e.g. IEnumerable<string> code = codesDistinct();</string>

Here[^] is an example.
Another example[^].

Posted 12-Mar-13 3:15am

Abhinav S

Comments

Member-2338430 12-Mar-13 9:23am

I will take data from mysql database it has a lesson code column I will take database to gridview but these column has diffrent lesson codes but same lessons MATH 103 MATH-103 I will take one lesson like MAHT any character I dont know which character remove 103
from database to gridview

Member-2338430 12-Mar-13 9:25am

so MATH 103 MATH-103 MATH_103 MATH?103 MATH--103 WİLL BE MATH103 but I must do in c# code behind

CHill60 · Answer 2 · 2013-03-12T06:47:00

The following uses Regex to construct the lesson code from various formats. I've also expanded the solution to cater for other lessons e.g. HIST for History, ENGL for English and also to cater for non-upper case entries.
I've used a string array for my checking

C#

private void button2_Click(object sender, EventArgs e)
{
    // various possible entries on the database...
    string[] lessons = {"....", "hist=101", "MATH103","MATH-103", "MATH 103", "MATH_103", "MATH--101", "engl   100"};

    foreach (string singleLesson in lessons)
    {
        // m will contain the lesson number 103, 101, 100 etc
        Match m = Regex.Match(singleLesson, @"\d+", RegexOptions.IgnoreCase);
        // n will contain the lesson type MATH, ENGL, HIST etc etc
        Match n = Regex.Match(singleLesson, @"\b[A-Z|a-z]*", RegexOptions.IgnoreCase);

        // if we have both a lesson type and a lesson number ...
        if (m.Success && n.Success )
        {
            string lesson = n.ToString().ToUpper() + m.ToString();
            Debug.Print(lesson);
        }
        else
            Debug.Print("Invalid Entry");


}

Output:

Invalid Entry<br />
HIST101<br />
MATH103<br />
MATH103<br />
MATH103<br />
MATH103<br />
MATH101<br />
ENGL100<br />