Values Already Exists

Question

I have one table like this ...
Pk EmployeeiD Date Time

1	Emp1001	5/8/2012	00:03:02
2	Emp1001	5/9/2012	00:03:02
3	Emp1001	5/10/2012	00:00:49

the above values are inserted successfully.....in their respective dates....

If a insert the above values again in the same table means

(ie..)Employeeid Date Time
Emp1001 5/9/2012 00:03:02

it will show some message like (Date Already Exists)....

Kunal Vaishya · Answer

Dear have you checked you set Primary key Is Proper or Not

V S N Raju Kanumuri · Answer

Hi Mohan write following code in insert button click SqlConnection con = new SqlConnection(connection string); SqlDataAdapter da = new SqlDataAdapter(select * from employee where EmployeeId=' + txtempid.Text + ' and date=' + date + ' and time=' + time + ' con); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count == 0) { // insert ur values } else { // write message Values already exist }

Anil Kumar · Answer

Why duplicate thread http://www.c-sharpcorner.com/Forums/Thread/172373/values-already-exists-in-the-table.aspx P lease wait for answers

MohanRaj C · Answer

No..There is no Constraints in my table... I didnt know about constraints...am a Beginner

Muralidharan Deenathayalan · Answer

What are the constraints are present in the table? Do you have unique constraints on date column or combination of date and empid columns?