ACCESS 怎样获得刚插入数据的ID

[loves0215cc]

           
 sql = string.Format(" insert into neirong(lindex,title,contents,creattime,readcount,Tag)values('{0}','{1}','{2}','{3}',{4},'{5}') ", lindex, title, contents, DateTime.Now.ToString("yyyy-MM-dd"), 0, tag);
            ret = ExcuteSQL(sql);
            return ret;[code=C#]

[/code]


怎样获刚插入数据的ID

[若-相惜]

public int add()
{
sql = string.Format(" insert into neirong(lindex,title,contents,creattime,readcount,Tag)values('{0}','{1}','{2}','{3}',{4},'{5}');select @@IDENTITY", lindex, title, contents, DateTime.Now.ToString("yyyy-MM-dd"), 0, tag);
object obj = DbHelperSQL.GetSingle(strSql.ToString(),parameters);
			if (obj == null)
			{
				return 0;
			}
			else
			{
				return Convert.ToInt32(obj);
			}

}

   /// <summary>
        /// 执行一条计算查询结果语句，返回查询结果（object）。
        /// </summary>
        /// <param name="SQLString">计算查询结果语句</param>
        /// <returns>查询结果（object）</returns>
        public static object GetSingle(string SQLString)
        {
            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                using (SqlCommand cmd = new SqlCommand(SQLString, connection))
                {
                    try
                    {
                        connection.Open();
                        object obj = cmd.ExecuteScalar();
                        if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
                        {
                            return null;
                        }
                        else
                        {
                            return obj;
                        }
                    }
                    catch (System.Data.SqlClient.SqlException e)
                    {
                        connection.Close();
                        throw e;
                    }
                }
            }
        }

[人生无悔]

select @@identity

[loves0215cc]

[Quote=引用 1 楼 的回复:]

C# code

public int add()
{
sql = string.Format(" insert into neirong(lindex,title,contents,creattime,readcount,Tag)values('{0}','{1}','{2}','{3}',{4},'{5}');select @@IDENTITY", lindex, title, conte……
[/Quote]

你的意思是Return刚插入的ID吗

[loves0215cc]

[Quote=引用 2 楼 的回复:]

SQL code

select @@identity
[/Quote]

access 不能用@@identity

[孟子E章]

你可以这样

/C#

string query = "Insert Into neirong(xx,xx) 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("", xxx.Text);
    cmd.Parameters.AddWithValue("", xxx.Text);
    conn.Open();

    cmd.ExecuteNonQuery();

    cmd.CommandText = query2;

    ID = (int)cmd.ExecuteScalar();

  }

}

注意这里的conn 不能关闭

[jiongxiaotao]

如果ID自增的话，肯定刚插入的那条的ID是最大的。用select max（id）from。。。。
代码如下

public CheckRecentId(string sql_Table){
try
            {
                SqlCommand cmd = new SqlCommand("select Max(id)from "+sql_Table, cn);
                cn.Open();
                int id = -1;
                //返回查询结果中的第一行第一列，是个object对象
                id = Convert.ToInt32(cmd.ExecuteScalar());

                if (count < 1)
                    return false;
                return true;
            }
            catch (Exception ex)
            {
                return false;
            }

[孟子E章]

select max（id），，多人操作就错误了