public static Image GetCurrentImage(string project, string guid) { try { string projectsPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location); string currentPicture = ""; using (SQLiteConnection Conn = new SQLiteConnection()) { Conn.ConnectionString = "Data Source=" + projectsPath + @"\\Projects\\" + project + ".db;Version=3;New=False;Compress=True;Synchronous=Off"; Conn.Open(); SQLiteParameter sqlGuid = new SQLiteParameter("@guid", DbType.String) { Value = guid }; SQLiteCommand cmd = new SQLiteCommand(); cmd = Conn.CreateCommand(); cmd.Parameters.Add(sqlGuid); cmd.CommandText = "SELECT image_base64 FROM images WHERE guid_images = @guid"; using (SQLiteDataReader sqReader = cmd.ExecuteReader()) { if (sqReader.Read()) { currentPicture = sqReader.GetString(0); } } if (currentPicture == "") { ResourceManager resources = new ResourceManager("CameratrapManager_db.Resources.Images", System.Reflection.Assembly.GetExecutingAssembly()); return((System.Drawing.Bitmap)(resources.GetObject("no-photo-available"))); } else { return(ConversionUtilities.Base64ToImage(currentPicture)); } } } catch (Exception ex) { throw ex; } }