存储过程中datetime类型的参数为空时asp.net中怎么调用

Question

CREATE proc UpInsertApply
(
  @cardid int,
  @boxid varchar(50),
  @userid varchar(50),
  @person varchar(50),
  @reason varchar(50),
  @booktime datetime=null,
  @borrowstate varchar(50),
  @applytime varchar(50)
)
as
begin
  begin tran
  if @booktime is null
  begin
    insert into Apply(CardId,BoxId,UserId,Person,Reason,BorrowState,ApplyTime,IsExamine,IsDestory)values(@cardid,@boxid,@userid,@person,@reason,@borrowstate,@applytime,'未审核','未销毁')
    if @@error=0
      commit tran
    else
      rollback tran
  end
  else
  begin
    insert into Apply(CardId,BoxId,UserId,Person,Reason,BookTime,BorrowState,ApplyTime,IsExamine,IsDestory)values(@cardid,@boxid,@userid,@person,@reason,@booktime,@borrowstate,@applytime,'未审核','未销毁')
    if @@error=0
      commit tran
    else
      rollback tran
  end
end
关键是如果@booktime为空时，asp.net中应该怎么写啊？
SqlParameter p6 = new SqlParameter("@booktime", apply.BookTime);

Answer 1

关键是如果@booktime为空时，asp.net中应该怎么写啊？
SqlParameter p6 = new SqlParameter("@booktime", apply.BookTime);我也遇到这样的问题了、怎么解决的啊？
applyBookTime=DBNull.Value;报错

Answer 2

你的apply.BookTime的类型是不是Datetime类型，如果是的话，改为Datetime?类型,就不会报错了