读书人

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

发布时间: 2012-09-03 09:48:39 作者: rapoo

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

C# code
            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

[解决办法]
你可以这样
C# code
/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();  }} 

读书人网 >asp.net

热点推荐