conn.Open(); senddate = Convert.ToDateTime(msg.Fields["MailDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
subject = msg.Subject.ToString();
priority = msg.Priority.ToString();
importance = msg.Fields["MailImportance"].ToString();
attachmentname = msg.Fields["MailAttachment"].ToString();
mailfrom = msg.From.ToString();
mailto = msg.To.ToString();
mailcc = msg.Cc.ToString();
mailbcc = msg.Bcc.ToString();
createdate = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); try
{
System.Data.OleDb.OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@senddate",OleDbType.DBTimeStamp),
new OleDbParameter("@subject",OleDbType.VarChar),
new OleDbParameter("@priority",OleDbType.VarChar),
new OleDbParameter("@importance",OleDbType.VarChar),
new OleDbParameter("@attachmentname",OleDbType.VarChar),
new OleDbParameter("@mailfrom",OleDbType.VarChar),
new OleDbParameter("@mailto",OleDbType.VarChar),
new OleDbParameter("@mailcc",OleDbType.VarChar),
new OleDbParameter("@mailbcc",OleDbType.VarChar),
new OleDbParameter("@createdate",OleDbType.DBTimeStamp)
};
param[0].Value = senddate;
param[1].Value = subject;
param[2].Value = priority;
param[3].Value = importance;
param[4].Value = attachmentname;
param[5].Value = mailfrom;
param[6].Value = mailto;
param[7].Value = mailcc;
param[8].Value = mailbcc;
param[9].Value = createdate; sqlscript = "insert into mailmonitor(senddate,subject,priority,importance,attachmentname,mailfrom,mailto,mailcc,mailbcc,createdate) " +
"values(@senddate,@subject,@priority,@importance,@attachmentname,@mailfrom,@mailto,@mailcc,@mailbcc,@createdate)"; cmd = new OleDbCommand(sqlscript, conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
//
}
finally
{
conn.Close();
}针对Oracle DB的Insert Parameter的操作,请问错误在那啊?急
subject = msg.Subject.ToString();
priority = msg.Priority.ToString();
importance = msg.Fields["MailImportance"].ToString();
attachmentname = msg.Fields["MailAttachment"].ToString();
mailfrom = msg.From.ToString();
mailto = msg.To.ToString();
mailcc = msg.Cc.ToString();
mailbcc = msg.Bcc.ToString();
createdate = System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); try
{
System.Data.OleDb.OleDbParameter[] param = new OleDbParameter[] { new OleDbParameter("@senddate",OleDbType.DBTimeStamp),
new OleDbParameter("@subject",OleDbType.VarChar),
new OleDbParameter("@priority",OleDbType.VarChar),
new OleDbParameter("@importance",OleDbType.VarChar),
new OleDbParameter("@attachmentname",OleDbType.VarChar),
new OleDbParameter("@mailfrom",OleDbType.VarChar),
new OleDbParameter("@mailto",OleDbType.VarChar),
new OleDbParameter("@mailcc",OleDbType.VarChar),
new OleDbParameter("@mailbcc",OleDbType.VarChar),
new OleDbParameter("@createdate",OleDbType.DBTimeStamp)
};
param[0].Value = senddate;
param[1].Value = subject;
param[2].Value = priority;
param[3].Value = importance;
param[4].Value = attachmentname;
param[5].Value = mailfrom;
param[6].Value = mailto;
param[7].Value = mailcc;
param[8].Value = mailbcc;
param[9].Value = createdate; sqlscript = "insert into mailmonitor(senddate,subject,priority,importance,attachmentname,mailfrom,mailto,mailcc,mailbcc,createdate) " +
"values(@senddate,@subject,@priority,@importance,@attachmentname,@mailfrom,@mailto,@mailcc,@mailbcc,@createdate)"; cmd = new OleDbCommand(sqlscript, conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
//
}
finally
{
conn.Close();
}针对Oracle DB的Insert Parameter的操作,请问错误在那啊?急
解决方案 »
- 一个已编译 发布过的.net 项目 现在要把web.config 里面的数据库连接字符串 在使用的时候 进行解密
- 求一正则表达式
- 寻求帮助:asp.net C#网站 5000人在线 CPU经常莫名其妙的高涨,导致网站缓慢
- ajax 框架 的问题
- js文件中如何調用服務器端方法
- 请教:触发CheckBoxList事件后如何获取当前选择个数呢?
- 高分!如何对QueryString进行加密解密!
- 用treeview动态显示树
- 发布一个开源,漂亮的日期控件 Version 2.0.2004.0928〔有源码,演示〕
- 紧急求救!
- .net在线打开文件!
- !!!!!!!!!!!!!动态页面转化成静态页面,提高工作效率,急需!!!!!!!!!!!求解!!!!!!!!!!!!!!!!!!!!
cmd.Paramters.add(param[0])
param[1].Value = subject;不是吧
这些应该可以代替:
cmd.Paramters.add(param[0])的吧
既然用到Parameters,那肯定得add
cmd.Parameters.Add("@subject",OleDbType.VarChar);
cmd.Parameters["@subject"].Value = subject;
cmd.ExecuteNonQuery();这一种吗?
要特别注意的是,在 OleDbParameter[] parameters = {}数组里面参数的顺序一定要和Update语句里面的参数的顺序一致。
public void Update(ZPY.Model.News model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update News set ");
strSql.Append("NewsTitle=@NewsTitle,");
strSql.Append("NewsContent=@NewsContent,");
strSql.Append("NewsFrom=@NewsFrom,");
strSql.Append("NewsTime=@NewsTime,");
strSql.Append("DefaultPic=@DefaultPic,");
strSql.Append("BigClassID=@BigClassID,");
strSql.Append("SmallClassID=@SmallClassID,");
strSql.Append("Hits=@Hits,");
strSql.Append("IsTop=@IsTop,");
strSql.Append("IsPass=@IsPass,");
strSql.Append("AddMan=@AddMan");
strSql.Append(" where ID=@ID ");
OleDbParameter[] parameters = {
// 注意里面参数的顺利一定要和Update语句里面参数是顺序一致,比如Update语句里面第一个参数// 是@NewTitle,这里也是,Update语句里面最后一个参数是@ID,这样最后一个参数一定要是@ID
new OleDbParameter("@NewsTitle", OleDbType.VarChar,100),
new OleDbParameter("@NewsContent", OleDbType.VarChar,0),
new OleDbParameter("@NewsFrom", OleDbType.VarChar,50),
new OleDbParameter("@NewsTime", OleDbType.Date),
new OleDbParameter("@DefaultPic", OleDbType.VarChar,100),
new OleDbParameter("@BigClassID", OleDbType.Integer,4),
new OleDbParameter("@SmallClassID", OleDbType.Integer,4),
new OleDbParameter("@Hits", OleDbType.Integer,4),
new OleDbParameter("@IsTop", OleDbType.Boolean,2),
new OleDbParameter("@IsPass", OleDbType.Boolean,2),
new OleDbParameter("@AddMan", OleDbType.VarChar,50),
new OleDbParameter("@ID", OleDbType.Integer,4),
};parameters[0].Value = model.NewsTitle;
parameters[1].Value = model.NewsContent;
parameters[2].Value = model.NewsFrom;
parameters[3].Value = model.NewsTime;
parameters[4].Value = model.DefaultPic;
parameters[5].Value = model.BigClassID;
parameters[6].Value = model.SmallClassID;
parameters[7].Value = model.Hits;
parameters[8].Value = model.IsTop;
parameters[9].Value = model.IsPass;
parameters[10].Value = model.AddMan;
parameters[11].Value = model.ID;DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
}
"values(@senddate,@subject,@priority,@importance,@attachmentname,@mailfrom,@mailto,@mailcc,@mailbcc,@createdate)";
问题就会一目了然!
大家都没有把问题说到点子上去,我上面的代码没有问题。在问题在于:我是对Oracle DB进行操作的,不是Sql Server。Oracle的表示符是:?
其他也稍有不同不过还是谢谢各位的帮忙。