日期:2014-05-17  浏览次数:20488 次

利用参数化SQL语句,向Oracle数据库插入DateTime类型数据时该如何设置???
现在要向Oracle数据库中的某个表插入一条数据,该数据表中有一个字段为DateTime类型。。。


if (!string.IsNullOrEmpty(birthday))
{
    prams = new OracleParameter[] { 
                                    new OracleParameter(":userName", userName), 
                                    new OracleParameter(":pwd", pwd), 
                                    new OracleParameter(":sex", sex), 
                                    new OracleParameter(":mobile", mobileNo), 
                                    new OracleParameter(":cretType", GetLicType(cretType)), 
                                    new OracleParameter(":cretNo", cretNo),                                            
                                    new OracleParameter(":fixedPhone", fixedPhone), 
                                    new OracleParameter(":mail", email), 
                                    new OracleParameter(":postCode", postCode), 
                                    new OracleParameter(":address", contactAdd),