C#+ACCESS的问题 求解

[yanlei83]

if(Idstr == null)
{
Response.Write("<script language = javascript>alert('请先选择要回复的问题')</script>");
}
else
{
string connstr = @"Provider = Microsoft.Jet.OLEDB.4.0" + ";Data Source = " + Server.MapPath("../DB/DataBase.mdb");
OleDbConnection OConn = new OleDbConnection(connstr);

string sqlstr = "update QandA set Answer = @Answer,AnswerName = @AnswerName,Time = @Time,QA = @QA where id = @id";

OleDbCommand OCmd = new OleDbCommand(sqlstr,OConn);


OCmd.Parameters.Add(new OleDbParameter("@Answer",OleDbType.VarChar));
OCmd.Parameters["@Answer"].Value = this.Textbox4.Text;

OCmd.Parameters.Add(new OleDbParameter("@AnswerName",OleDbType.VarChar));
OCmd.Parameters["@AnswerName"].Value = this.TextBox1.Text;

OCmd.Parameters.Add(new OleDbParameter("@Time",OleDbType.DBTimeStamp));
OCmd.Parameters["@Time"].Value = DateTime.Now.ToString();

OCmd.Parameters.Add(new OleDbParameter("@QA",OleDbType.VarChar));
OCmd.Parameters["@QA"].Value = true;



OCmd.Parameters.Add(new OleDbParameter("@id",OleDbType.Integer));
OCmd.Parameters["@id"].Value = Idstr;

[copico]

什么问题呀，别光帖代码啊

[yanlei83]

呃 晕 忘了
我的 VS2003 说我的 UPDate语句有错

[GXY2005]

好象還少語句，沒有貼完嗎？
OCmd.Connection=OConn;
OCmd.ExecuteScalar();??

[yanlei83]

下面的还要贴吗?

编译器只是说我UPDATE语句有错误啊

[yanlei83]

如果我的 UPDATE语句没有问题 那请问可能问题会在哪?

[yanlei83]

OConn.Open();

int i = OCmd.ExecuteNonQuery();

OConn.Close();

if(i > 0)
{
Response.Write("<script language = javascript> alert('修改成功');</script>");
}
else
{
Response.Write("<script language = javascript> alert('数据修改失败');</script>");
}



这是接着的代码

[Knight94]

操作Access数据库，注意避免关键字冲突，在所有表名和字段名加上“[]”标示，例如
string sqlstr = "update [QandA] set [Answer] = @Answer,[AnswerName] = @AnswerName,[Time] = @Time,[QA] = @QA where [id] = @id";

[oolongTea]

你跟踪一下sql语句，估计是类型的问题
例如时间、布尔型

[yanlei83]

Knight94(愚翁)正解