in

System.Data.SQLite

An open source ADO.NET provider for the SQLite database engine
System.Data.SQLite » SQLite ADO.NET Provider » How To » How to retrieve the last autoincremented ID from a table when using a typed dataset?

How to retrieve the last autoincremented ID from a table when using a typed dataset?

Last post 01-26-2010 10:07 AM by aner. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 01-25-2010 3:58 AM

    • aner
    • Not Ranked
    • Joined on 01-16-2010
    • Posts 2

    How to retrieve the last autoincremented ID from a table when using a typed dataset?

    Reply Contact

    [Noob alert!]

    I constructed a typed dataset inside VS 2008. I am using the prefabricated datadapters to fill and update its tables. How can I retrieve the last autoincremented ID from a table? I understand that in SQL it is:Select last_insert_rowid(). But how do I call this SQL from C# ADO.Net?

    Thanks a lot!

     

     

  • 01-26-2010 10:07 AM In reply to

    • aner
    • Not Ranked
    • Joined on 01-16-2010
    • Posts 2

    Re: How to retrieve the last autoincremented ID from a table when using a typed dataset?

    Reply Contact

    I got the anwer at stackoverflow
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems