duplicate name not allow

Question

0.00/5 (No votes)

See more:

i have 'user' table:
fields are:

name
emailid
address
ph.no
password

when i insert new data from textbox,it will check whether name is allready exsist or not .if not exsist then allow to enter name in textbox.
how to do this?

more discription of my problem:
when i enter name in textbox ,it will check weather name is exsist or not.if name exsist, then it will not allow to enter name.

Posted 11-Jan-13 21:34pm

Member 9511889

Updated 11-Jan-13 22:39pm

v3

Add a Solution

Comments

OriginalGriff 12-Jan-13 3:37am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Use the "Improve question" widget to edit your question and provide better information.

2 solutions

Solution 2

You can check using

C#

string sql = string.format(" select count(*) from table name where name='{0}'", txtname.text);

if it exitst it gives 1 else 0
then u can allow to enter.

Posted 11-Jan-13 22:52pm

Lakshmimsridhar

Updated 11-Jan-13 23:20pm

v2

Comments

fjdiewornncalwe 23-Feb-13 11:25am

No vote from me, but a suggestion. Many of your answers are SQL injection nightmares. So that people learn how to do things properly, ALL answers like this one that build sql queries should use paramaterized queries, not concatenation.

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shubh Agrahari · Accepted Answer · 2013-01-11T22:47:00

Hi Friend..

on insertion button click event just do this...

con.Open();
 MySqlCommand cmd = new MySqlCommand("select * from Your_tableUser where name='"+txtboxName.text+"'", con);
        MySqlDataReader dr = cmd.ExecuteReader();
     if (dr.Read())
        {

            Lblmsg.text="Duplicate Entry Found..."; //label that show your error massage 

        }
else
{
Here Do You Insert Code....
}
        con.Close();

I think it will be helpful for you...

duplicate name not allow

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

duplicate name not allow

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us