ado.net,怎么把我刚刚插入的行返回????我的代码如下:
khler 2007-05-21 01:35:31 OleDbConnection cn = IConnection.Open();
string sql = "insert into tbUser([Name],[NickName],[Password],[Sex]) values(";
sql += "'"+ user.Name + "','" + user.NickName + "','" + user.Password + "'," + user.Sex + ")";
OleDbCommand cmd = new OleDbCommand(sql, cn);
cmd.ExecuteNonQuery();
User u = cmd.ExecuteScalar() as User;
if (u == null)
{
return -1;
}
else
{
return u.Id;
}
但是User u = cmd.ExecuteScalar() as User;没有返回任何东西。
需要关闭后重新打开吗?