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 identityename 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(enameeaddress) 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?