如何避免相同的日期？ [英] How to avoid Same Date?

问题描述

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

我在C＃.net中使用Dynamic GridView我输入了9行一个日期

这9行只更新了一个日期，如果我输入相同的日期然后它显示日期费率已经存在..我怎么能这样做...请帮助我..

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

推荐答案

你好，

修改

Hello ,
modify

@date datetime

to

to

@date date

因为它是日期时间需要不同的日期和时间
谢谢

as it is Datetime takes different date and time
thanks

这篇关于如何避免相同的日期？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！