While insert the same data it will display already exist Visual studio 2005 with SQL Server

Question

Please help me. While insert the same data it will display already exist Visual studio 2005 with SQL Server. Thanks&Regs Magesh.A

Satyapriya Nayak · Answer

Hi Magesh, Try this... create table employee (eid int primary key identity,ename varchar(50),eaddress varchar(50)) Untitled Page BackColor="#FF99FF" Font-Bold="True" Width="329px" onclick="Button1_Click" /> Width="197px" ForeColor="#FF3300"> ControlToValidate="txtUserName" ErrorMessage="*Name Required"> Width="197px" ForeColor="#FF3300"> ControlToValidate="txtUserAddress" ErrorMessage="*Address Required"> ForeColor="Black"> using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Insert_data_ifnot_exits { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlCommand com; string str = null; protected void Button1_Click(object sender, EventArgs e) { namecheck(); } public void namecheck() { SqlConnection con = new SqlConnection(connStr); con.Open(); str = "select count(*)from employee where ename='" + txtUserName.Text + "'"; com = new SqlCommand(str, con); int count = Convert.ToInt32(com.ExecuteScalar()); con.Close(); if (count > 0) { lblMessage.Text = "Sorry! you can't take this username"; } else { lblMessage.Text = "You can take this username"; con.Open(); str = "insert into employee(ename,eaddress) values('" + txtUserName.Text + "','" + txtUserAddress.Text + "')"; com = new SqlCommand(str, con); com.ExecuteNonQuery(); con.Close(); } } } } Thanks If this post helps you mark it as answer

Pravin Ghadge · Answer

Mangesh, First, Check record is already exist or not . If it exist then show message record already exist, else use insert command. For eg: USe Select command: cmd=new Sqlcommand("Select * from tblname where Customer_ID='"+txtCust.Text+"'") Sqldatareader dr=cmd.ExecuteReader(); if(dr.hasrows) { use insert command } else { MEssbox.show("Record already exist") }

Pravin Ghadge · Answer

Mangesh, Just change ur code: cmd=new Sqlcommand("Select * from tblname where Customer_ID='"+txtCust.Text+"'") Sqldatareader dr=cmd.ExecuteReader(); if(dr.hasrows) { MEssbox.show("Record already exist") } else { }

magesh manavalan · Answer

Hello sir. i try it your code put it shows the errors that error is: Violation of PRIMARY KEY constraint 'PK_employee1'. Cannot insert duplicate key in object 'employee1'. The statement has been terminated.

Pravin Ghadge · Answer

Hi Mangesh, I can't get u. What u want?

While insert the same data it will display already exist Visual studio 2005 with SQL Server

Answers (5)