I have one table like this ...
Pk EmployeeiD Date Time
1 Emp1001 5/8/2012 00:03:02
2 Emp1001 5/9/201200:03:02
3 Emp1001 5/10/201200:00:49
the above values are inserted successfully.....in their respective dates....
If i 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)....
I didnt use Constraints in my table... I didnt know about constraints...am a Beginner
Anil KumarPosted May 15, 2012, 6:15 AM
I didn't get you, please clear
Kunal VaishyaPosted May 15, 2012, 5:19 AM
Anil KumarPosted May 15, 2012, 5:18 AM
Jiteendra SampathiraoPosted May 15, 2012, 3:04 AM
Below link is good one
http://www.dotnetfunda.com/forums/thread6442-check-if-an-username-already-exists-in-the-database.aspx
http://www.daniweb.com/software-development/csharp/threads/177604/check-whether-username-alraedy-exists-in-database
Modify these code to your requirement..
Hope it help you..