===VB+SQL问题:将数据类型转换为datetime出错?在线等===

Question

CREATE PROCEDURE updateAll
(
         ...
@birthday datetime,
         ...
)
 AS
update test
         set
              ...
     birthday = @birthday,
              ...
where 
              ...GO
------------------------------...
cmd.Parameters.Append cmd.CreateParameter("@birthday", adDate)
...
cmd.Parameters("@birthday").Value = dtpBirthday.Value
...
cmd.execute其它调试过均无错, 运行cmd.execute时提示出错:
runtime error '-2147217931(80040e07)'
将数据类型转换为datetime出错HELP! 在线等待...

Answer 1

FT, 原来添加
cmd.Parameters("@birthday").Value = dtpBirthday.Value
要与SP的顺序一样...唉, 升级到VB.NET多爽