How to avoid Same Date?

See more:

SQL-Server-2005

C#

SQL

SQL-Server

, +

ALTER PROCEDURE [dbo].[K_FS_InsertMrpDetails]
   @date datetime,
   @feedtype varchar(50),
   @rateperkg float,
   @rateper50kg float,
   @updatedby varchar(50)
AS
BEGIN   

 if exists(select * from K_FS_GenerateDcno where date = @date)
 begin 
 select '1' as status
 end
 else
 begin

insert into K_FS_FeedMrpDetails([date],feedtype,rateperkg,rateper50kg,
updatedby,updatedon) values (@date,@feedtype,@rateperkg,@rateper50kg,
@updatedby,getdate())

select '2' as status

END

I am using Dynamic GridView in C#.net..I enteredd 9 Rows of one date
these 9 rows were updated by only one "DATE" if i enter same Date Then it shows "Date Rates Already Exists".. How can i Do this..Please Help Me..