Question

急！C#操作Access update语句

C#操作Access update语句执行不报错 也返回了影响行数 但打开Access就是没更新数据 以下是代码：
if (new DbHelp().ExecuteUpdate("Update Fees Set feeTitleId = " + this.cbFeeTitle.SelectedValue.ToString() + " , fee = " + this.tbFee.Text.Trim() + " , feeDetail = '" + this.tbFeeDetail.Text + "' Where feeId=" + this.feeId) == 1)
{
MessageBox.Show("保存成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("保存失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}

DbHelp：
public int ExecuteUpdate(string cmdText)
{
int rows = -1;
this.command = new OleDbCommand();
command.Connection = con;
command.CommandType = CommandType.Text;
command.CommandText = cmdText;

try
{
this.con.Open();
rows=this.command.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (this.con.State != ConnectionState.Closed)
{
this.con.Close();
}
}
return rows;
}

Answer 1

没有任何问题你看错了数据库，数据库在Bin下面