How can I get the log sequence number on C#?

Hi! I would like to get the log sequence number from the database backup so
that I can let the users select the restored time. Can I do this with the
SMO?
Thanks!One way would be to use methods such as the Database.ExecuteWithResults method to execute your
RESTORE HEADERONLY command and loop the result (DataTable in the DataSet) from that method.
Or, you should be able to use BackupDevice.ReadBackupHeader method and read the returned DataTable.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Cheryl" <justtosayhi@.excite.com> wrote in message
news:FBB10E85-25FF-49B7-96D4-97ADE7552575@.microsoft.com...
> Hi! I would like to get the log sequence number from the database backup so that I can let the
> users select the restored time. Can I do this with the SMO?
> Thanks!