Fetch file name from databse to a variable.

Hi,

Try to code like this below:

var records = dbcon.Table<databaseprograms>().Where(temp =>temp.ProgramChapter ==pageTitle.Text );
foreach (var sd in records ) 
{
string filename=sd.filename;//filename is the records property
}

And I suggest you can see this sample about how to use SQLite in windows 8:

http://code.msdn.microsoft.com/windowsapps/Sqlite-For-Windows-8-Metro-2ec7a882/view/SourceCode#content

Best Wishes!

---

<THE CONTENT IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, WHETHER EXPRESS OR IMPLIED>

Thanks

MSDN Community Support



Please remember to "Mark as Answer" the responses that resolved your issue. It is a common way to recognize those who have helped you, and makes it easier for other visitors to find the resolution later.