Repeat Data Should Not Store Again

Question

User-807418713 posted

Hello

As I Have One Table Name Is "Master_Color"

Now In aspx page i have one textbox and one asp.net button

Now In Master_Color Table has following Data

Black
Tan
Red
Blue

Now User Enter in Textbox1 as any one of the below
Bllack 
BBllack
Blackspace
spaceBlack

Whatever he write we can find and show them alert because Black Already Exist  

How to do using c# code behind on button click

Thanking You

Answer 1

User-1780421697 posted

static void Main(string[] args)
    {

        int f = 0;
        Console.WriteLine("enter the string");
        string s = Console.ReadLine();
        Console.WriteLine("enter the word to be searched");
        string a = Console.ReadLine();
        int l = s.Length;
        int c = a.Length;

        for (int i = 0; i < l; i++)
        {
            if (s[i] == a[0])
            {
                for (int K = i + 1, j = 1; j < c; j++, K++)
                {
                    if (s[K] == a[j])
                    {
                        f++;
                    }
                }
            }
        }
        if (f == c - 1)
        {
            Console.WriteLine("matching");
        }
        else
        {
            Console.WriteLine("not found");
        }
        Console.ReadLine();
    }

Answer 2

User288213138 posted

Hi Gopi.MCA,

Now User Enter in Textbox1 as any one of the below
Bllack 
BBllack
Blackspace
spaceBlack

According to your description, i made demo for you.

I use a nested loop to compare 2 strings.

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
            <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />


 protected void Button1_Click(object sender, EventArgs e)
        {
            string query = "SELECT color FROM Test62";
            string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand(query))
                {
                    cmd.Connection = con;
                    con.Open();
                    using (SqlDataReader sdr = cmd.ExecuteReader())
                    {
                        while (sdr.Read())
                        {
                            int j = 0;
                            int alert = 0;
                            string search = TextBox1.Text;
                            string data = sdr["color"].ToString();
                            for (int i = 0; i < data.Length; i++)
                            {
                                while (j < search.Length)
                                {
                                    if (data[i] == search[j])
                                    {
                                        j++;
                                        alert++;
                                        break;
                                        
                                    }
                                    else
                                    {
                                        j++;
                                    }
                                }
                            }
                            if (alert == data.Length)
                            {
                                ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Black Already Exist');", true);
                            }                          
                        }
                    }
                    con.Close();
                }

            }

The result:

Best regards,

sam

Answer 3

User-807418713 posted

Hello

Thanks

Some time user will type space then he is writing Black that time as well i want to show alert

Answer 4

User288213138 posted

Hi Gopi.MCA,

My code above can still meet your requirement.

The result:

Best regards,

Sam

Answer 5

User-807418713 posted

Hello

If I Type Red Then also its showing alert message

How to solve this

Thanking You

Answer 6

User288213138 posted

Hi Gopi.MCA,

Gopi.MCA

If I Type Red Then also its showing alert message

My code above can still meet your requirement.

protected void Button1_Click(object sender, EventArgs e)
        {
            string query = "SELECT color FROM Test62";
            string constr = ConfigurationManager.ConnectionStrings["constr1"].ConnectionString;
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand(query))
                {
                    cmd.Connection = con;
                    con.Open();
                    using (SqlDataReader sdr = cmd.ExecuteReader())
                    {
                        while (sdr.Read())
                        {
                            int j = 0;
                            int alert = 0;
                            string search = TextBox1.Text;
                            string data = sdr["color"].ToString();
                            for (int i = 0; i < data.Length; i++)
                            {
                                while (j < search.Length)
                                {
                                    if (data[i] == search[j])
                                    {
                                        j++;
                                        alert++;
                                        break;

                                    }
                                    else
                                    {
                                        j++;
                                    }
                                }
                            }
                            if (alert == data.Length)
                            {
                                string s = TextBox1.Text + " Already Exist";

                                ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + s + "');", true);
                            }
                        }
                    }
                    con.Close();
                }

            }
        }

The result:

Best regards,

Sam

Answer 7

User-807418713 posted

Hello

Thank You For Your New Code

1) If I user type Blackkk it has to show alerady exist coz black is in database

2) If user enter space then type Black have to show already exists alert.

3) If user put something Black,Tan then alert will not show

How to do so...

Thanking You

Answer 8

User288213138 posted

Hi Gopi.MCA,

1) If I user type Blackkk it has to show alerady exist coz black is in database

2) If user enter space then type Black have to show already exists alert.

Do you want to have different alert based on different input values?

3) If user put something Black,Tan then alert will not show

I don't understand what you mean, can you describe it in detail?

Best regards,

Sam

Answer 9

User-807418713 posted

Hello

Let's Assume This my sql query "Select ColorName from Colors"

Now It shows Result Set Like This

Black

Red

Now in aspx page I have One Textbox and one button

1) Now user enter Black in textbox and press button i want to show "Data Already Exist"

2) User Is typing spaceBlack then also I want to show "Data Already Exist"

3) User Is typing Blackspace then also I want to show "Data Already Exist"

3) User Is typing Bllack then also I want to show "Data Already Exist"

4) User Is typing Blacck then also I want to show "Data Already Exist"

) User Is typing Bl ack then also I want to show "Data Already Exist"

5) User Is typing Black,Red then I dont want to show alert because its a different  color name

*Note : space is user sometimes pressing space button before typing that i want to check 

Hope This is clear

Thanking You

Answer 10

User288213138 posted

Hi Gopi.MCA,

1) Now user enter Black in textbox and press button i want to show "Data Already Exist"

2) User Is typing spaceBlack then also I want to show "Data Already Exist"

3) User Is typing Blackspace then also I want to show "Data Already Exist"

3) User Is typing Bllack then also I want to show "Data Already Exist"

4) User Is typing Blacck then also I want to show "Data Already Exist"

) User Is typing Bl ack then also I want to show "Data Already Exist"

My code above meets these conditions.

5) User Is typing Black,Red then I dont want to show alert because its a different  color name

If you want to enter two colors and not alert, you can try the following code.

protected void Button1_Click(object sender, EventArgs e)
        {
            string query = "SELECT color FROM Test62";
            string constr = ConfigurationManager.ConnectionStrings["constr1"].ConnectionString;
            using (SqlConnection con = new SqlConnection(constr))
            {
                using (SqlCommand cmd = new SqlCommand(query))
                {
                    cmd.Connection = con;
                    con.Open();
                    using (SqlDataReader sdr = cmd.ExecuteReader())
                    {
                        while (sdr.Read())
                        {
                            int j = 0;
                            int alert = 0;
                            string search = TextBox1.Text;
                            string data = sdr["color"].ToString();
                            for (int i = 0; i < data.Length; i++)
                            {
                                while (j < search.Length)
                                {
                                    if (data[i] == search[j])
                                    {
                                        j++;
                                        alert++;
                                        break;

                                    }
                                    else
                                    {
                                        j++;
                                    }
                                }
                            }
                            if (alert == data.Length)
                            {
                                string s = TextBox1.Text + " Already Exist";
                                if (search.Contains(","))
                                {
                                    return;
                                }
                                else
                                {
                                    ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + s + "');", true);
                                }
                                
                            }
                        }
                    }
                    con.Close();
                }

            }
        }

Best regards,

sam

Answer 11

User753101303 posted

Hi,

If you need further help a higher level requirement could be usefull. For now it seems you want to prevent an entry which includes a word found in a list.

But what about colors such as "Blue", "PaleBlue", "LightBlue" etc... ?

It is also a bit harder to process mispelled values such as "Bllack" ie at which difference level do you consider this to be the same? At some point you have to trust users (a user could enter "abcd" as a color name if he wants).

Depending on what you are trying to I would enter all allowed color names in a table and would let the user to pick one. A trusted admin level user could enrich this table.

Edit: or this is homework ?

Answer 12

User-807418713 posted
Hello
Thanks for your reply

Simply task not allow user to enter the same color again if he enter anything space color name or color name spelling mistake

Then alert simple and that's it.

Thanking You

Answer 13

User475983607 posted

Gopi.MCA

Simply task not allow user to enter the same color again if he enter anything space color name or color name spelling mistake

Then alert simple and that's it.

One very simple and common solution is displaying a list of colors and letting the user select a color from the list.  

This is not a simple requirement if the user enters free formed text.  If you think there is a an easy solution, then, IMHO, you have not put in enough effort to solve this requirement.   

I see the solution as two steps.  The first step is spell checking.  Find a dictionary or a service that checks the user's spelling.  Provide user feedback to correct any misspelled words.  The next step is adding a unique constraint to the table column or writing a basic query to check if the color name exists.

Lastly, share your code.   Most of your posts do not include source code.  This infers you are not trying to learn and only want free code.

Answer 14

User-807418713 posted

Hello

My Requirment Is Very Simple

database table has color Black

Sometimes user enter Bllack or Bl ack or spaceblack so its getting repeated again

for that i want to block user not to enter again same name

Thanking You

Answer 15

User475983607 posted

My Requirment Is Very Simple

database table has color Black

Sometimes user enter Bllack or Bl ack or spaceblack so its getting repeated again

for that i want to block user not to enter again same name

The response indicates you put no effort into designing a solution otherwise you would understand the complexity.  

Answer 16

User409696431 posted

The requirement to avoid spaces before and/or after the user entry is very simple. Don't use TextBox1.Text, use TextBox1.Text.Trim().  That will cause " Black", " Black   ", "Black  ", and so on to become "Black".

You also have to consider that "Black" doesn't equal "black", which a user could enter.  You could make all the colors always be lowercase by using TextBox1.Trim().ToLower(), or always be uppercase by using TextBox1.Text.Trim().ToUpper() .

The requirement to correct spelling mistakes is NOT simple.  You'd have to know if words were incorrectly spelled - and that wouldn't prevent a user from entering a correctly spelled word that was not a color ("back" instead of "black" for example).   If you want to constrain inputs to a list of properly spelled colors, you should generate a list of allowed colors and then it would be easy to compare the inputs to that list and reject any inputs that don't match an allowed color.  Of course, in that case, why not just use a dropdownlist of the allowed color choices and make it simple for the user to enter an acceptable entry?