I am trying to save my file data in sql database.
In order to store the data I have created two tables
Table 1. File_Master which have columns , File Name, FileId
Table 2 PageContent which have column ,Page Number, Page Content ,FileId,
FileId in 2nd table is the primary key from 1st table.
But I am not getting Last inserted Id from File_Master
I have used ExecuteNonQuery and Execute Query.
How Can I get last inserted Id from 1st table.
Thanks in advance.