错误 CS0029: 无法将类型“int”隐式转换为“System.Data.OleDb.OleDbDataReader

[ft284800]

string name = Request.Form["ccc"];
string id=Request.Form["id"];
string path = ConfigurationManager.AppSettings["path"];
string provider = ConfigurationManager.ConnectionStrings["provider"].ConnectionString;
OleDbConnection Connection = new OleDbConnection(provider + Server.MapPath(path));
Connection.Open();
string sql = "update essay set content = "+name+" where id ="+id;
OleDbCommand cmd = new OleDbCommand(sql, Connection);
OleDbDataReader objDataReader=cmd.ExecuteNonQuery();


以上是代码，好像没什么问题，网上教程都这么写的，有人说最后句可以直接cmd.ExecuteNonQuery();式了也不行，会变成说是UPDATE语法错误。请指教。

[redria]

你都ExecuteNonQuery，返回的是int，干啥用Reader去接？

[redria]

UPDATE语法错误是你的sql文写得有问题，和C#无关

[jack20080808]

想不通你的update语句还用OleDbDataReader去接干嘛

[jiang_jiajia10]

OleDbDataReader objDataReader=cmd.ExecuteNonQuery();
这句有问题吧
int i=cmd.ExecuteNonQuery();
然后判断
if(i>0)
{
成功
}else
{
失败
}

[winner2050]

string sql = "update essay set content = "+name+" where id ="+id;
==================================
一看就知道错误.

content 看字面意思就知道是文本型
应该string sql = "update essay set content = '"+name+"' where id ="+id;

[winner2050]

string sql = "update essay set content = '"+name+"' where id ="+id;

[haonanzhao]

string sql = "update essay set content = "+name+" where id ="+id;
修改为
string sql = "update essay set content = '"+name+"' where id ="+id;

[lijin84100]

string sql = "update essay set content = '"+name+"' where id ="+id;