I want to add user details in database but if there same email it will not add.i cannot understand why my database is adding the user with same mail id.please help me by suggesting the solution.I...

Question

0.00/5 (No votes)

See more:

protected void txtsub_Click(object sender, EventArgs e)
   {

       User_reg ob1 = new User_reg();

       var res = (from test in ob.User_reg select test).ToList();
       foreach (var row in res)
       {
           if (row.email != txtmail.Text)
           {

               ob1.name = txtname.Text;
               ob1.address = txtadd.Text;
               ob1.phone_num = txtphn.Text;
               ob1.stream = txtstrm.Text;
               ob1.qualification = txtqlf.Text;
               ob1.email = txtmail.Text;
               ob1.password = txtpass.Text;

                ob.User_reg.AddObject(ob1);
              }

           else
           {
               lbl.Text = "Email Id already exists";

           }

   }

           ob.SaveChanges();

           }

Posted 7-Jan-14 18:07pm

Member 10488678

Updated 7-Jan-14 18:20pm

Peter Leow

v2

Add a Solution

3 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)

Ron Beyer · Answer 1 · 2014-01-07T18:27:00

Should be something like:

C#

bool found = false;
foreach (var row in res)
{
    if (row.email != txtmail.Text)
    {
        found=true;
    }

}

if (!found)
{
    ob1.name = txtname.Text;
    ob1.address = txtadd.Text;
    ob1.phone_num = txtphn.Text;
    ob1.stream = txtstrm.Text;
    ob1.qualification = txtqlf.Text;
    ob1.email = txtmail.Text;
    ob1.password = txtpass.Text;

    ob.User_reg.AddObject(ob1);
    ob.SaveChanges();
}
else
    lbl.Text = "Email Id already exists";

Otherwise you are checking every row and adding one entry for each row that doesn't match. Remember, foreach is a loop, you need to check all the rows for a duplicate and then after you've verified that there are no matches, THEN you an add it.

BTW, the loop is probably not necessary for finding if there is a duplicate email. You can use Linq for this in your select statement at the beginning, but I leave that as an exercise for you.

Aydin Homay · Answer 2 · 2014-01-07T18:25:00

Hi
First at all you should tell me what is your DBMS because making primary key or unique key has a different solutions at each DBMS but as a general you should set unique flag for your mail field if you want repel inserting users detail with same emails. But if you want repel inserting at UI(application layer validation) your code has not true functionality you can use Linq Query for checking exist records with same email really easily.

C#

var result =  ob.User_reg.Find(u=>u.Email.ToString() == txtmail.Text);
if(result == null)
{
    //TODo: write your insert code
}
else
 lbl.Text = "Email Id already exists";

Best Regards

Reshma Babu · Answer 3 · 2014-01-07T18:27:00

Solution 3

Use trim() function to trim off extra spaces, because even white space counts. And since email id is string, it is better to use string compare functions.

Posted 7-Jan-14 18:27pm

Reshma Babu

I want to add user details in database but if there same email it will not add.i cannot understand why my database is adding the user with same mail id.please help me by suggesting the solution.I...

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0