执行SQL语句，返回新插入的主键值

cmd.CommandText="Insert into User (UserName,Password) output inserted.Id values (@UserName,@Password)"

int i=Convert.ToInt32(cmd.ExecuteSclear());

详细请参阅OutPut into 子句的用法