Try with giving it a Product ID, that must be unique to the each product in your database.
In you code while inserting new Product, catch the exception as follows
try
{
}
catch(SqlException ex)
{
if (ex.Number == 2627)
{
MessageBox.Show("Productis already there!");
}
}
Error Number 2627 for MS-SQL server is for the violation of Unique-Key
Constraint.
-KR