Values Already Exists

MohanRaj C

14y2.7k.NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kunal Vaishya14y ago
Dear have you checked you set Primary key Is Proper or Not
V S N Raju Kanumuri14y ago
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 Kumar14y ago
Why duplicate thread
http://www.c-sharpcorner.com/Forums/Thread/172373/values-already-exists-in-the-table.aspx

Please wait for answers
MohanRaj C14y ago
No..There is no Constraints in my table... I didnt know about constraints...am a Beginner
14y ago
What are the constraints are present in the table?
Do you have unique constraints on date column or combination of date and empid columns?