如何在C＃中更新访问表（一列有自动编号）？ [英] How to update an access table(one column have autonumber) in C#?

问题描述

您好，我有一个MS ACCESS表，其中有两列名为item_nm（text）和item_id（此列是自动编号）。每当我试图更新表时，它都会出现错误（条件表达式中的数据类型不匹配）。请解决此问题。谢谢!!!!

Hello, I have an MS ACCESS table with two columns named item_nm(text) and item_id(This column is autonumber). Whenever I"m trying to update table it''s getting an error("Data type mismatch in criteria expression"). Please solve this quest. Thanks!!!!

private void button2_Click(object sender, EventArgs e)
        {
                cn.Open();
                OleDbCommand cm = new OleDbCommand("update tbl_purchaseitementry set item_nm='@item_nm' where item_id='@item_id'", cn);
                cm.Parameters.AddWithValue("@item_nm",txt_itemname.Text);
                cm.Parameters.AddWithValue("@item_id",txt_itemid.Text);
                OleDbDataAdapter da = new OleDbDataAdapter(cm);
                cm.ExecuteNonQuery();
                cn.Close();
        }

推荐答案

取消报价：

Take off the quotes:

OleDbCommand cm = new OleDbCommand("update tbl_purchaseitementry set item_nm='@item_nm' where item_id='@item_id'", cn);

成为：

Becomes:

OleDbCommand cm = new OleDbCommand("update tbl_purchaseitementry set item_nm=@item_nm where item_id=@item_id", cn);

OleDbCommand cm = new OleDbCommand("update tbl_purchaseitementry set item_nm=@item_nm where item_id=@item_id", cn);

不要在单引号之间包含变量（@item_nm和@item_id）;你不需要。

Don''t enclose your variables (@item_nm and @item_id) between single quotes ; you don''t need to.

这篇关于如何在C＃中更新访问表（一列有自动编号）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！