Question

我为其他数据库找到了很多关于这个问题的答案, 但是没有找到任何关于微软访问的答案。

I have a table that has the following columns : ID A B C the id is auto number , how do i get the ID of a row i just inserted.

btw : i m 使用 C#

感谢谢谢

Answer 1

见"http://msdn.microsoft.com/en-us/library/ks9f57t0.aspx>>>MSDN 文章。在MS Access中,您希望在插入记录的声明范围内 SELECT ÁIDENTION 。

Answer 2

You can get it with the oldes method. Insert your record and do a select for the last id inserted:

INSERT INTO table(column1, column2, ...) VALUES(value1, value2)

SELECT TOP 1 id FROM table ORDER BY id DESC

当然它不是最好的,但它确实有效。

Answer 3

//C#
string query = "Insert Into Categories (CategoryName) Values (?)";
string query2 = "Select @@Identity";
int ID;
string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Northwind.mdb";
using (OleDbConnection conn = new OleDbConnection(connect))
{
  using (OleDbCommand cmd = new OleDbCommand(query, conn))
  {
    cmd.Parameters.AddWithValue("", Category.Text);
    conn.Open();
    cmd.ExecuteNonQuery();
    cmd.CommandText = query2;
    ID = (int)cmd.ExecuteScalar();
  }
}

友情链接