if you are using SQL Server, trystring sql = "insert into tbl01 (c1) values('a'); Select @@Identity as 'ID'";
OleDbCommand cmd = new OleDbCommand(sql,Ole_Con);
Ole_Con.Open();
int i = Convert.ToInt32(cmd.ExecuteScalar());
OleDbCommand cmd = new OleDbCommand(sql,Ole_Con);
Ole_Con.Open();
int i = Convert.ToInt32(cmd.ExecuteScalar());
{
if(e.StatementType==StatementType.Insert)
{
OleDbCommand comm=new OleDbCommand("SELECT @@IDENTITY",conn);
e.Row["nnoid"]=(int)comm.ExecuteScalar();
}
}
所以得到最近插入的編號的方法也不同。