在Access中将记录插入数据库后如何获取最后的记录号 [英] how to get the last record number after inserting record to database in access

问题描述

我正在访问具有自动增加字段(ID)的数据库.

i have database in access with auto increase field (ID).

我这样插入记录(在C#中)

i insert record like this (in C#)

SQL = "insert into TermNumTbl (DeviceID,IP) values ('" + DeviceID + "','" + DeviceIP + "') ";
OleDbCommand Cmd = new OleDbCommand(SQL, Conn);
Cmd.ExecuteNonQuery();
Cmd.Dispose();
Conn.Close();

如何获取最后一个插入号码?

how to get the last inserting number ?

我不想运行新查询，我知道在sql中有类似SELECT @@IDENTITY

i dont want to run new query i know that in sql there is something like SELECT @@IDENTITY

但我不知道如何使用

预先感谢

推荐答案

有关此的更多信息:获取最近添加的记录的身份

Jet 4.0提供程序支持@@Identity

The Jet 4.0 provider supports @@Identity

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();
  }
}

这篇关于在Access中将记录插入数据库后如何获取最后的记录号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！