private DataTable GetFilesRecords()
{
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] {
new DataColumn("File Name", typeof(string)),
new DataColumn("File Size", typeof(int)),
new DataColumn("User Name", typeof(string))
});
var dsUsers = new DataSetUsersTableAdapters.UsersTableAdapter();
foreach (var u in dsUsers.GetAllActiveUsers())
{
var dsFiles = new DataSetUsersTableAdapters.FilesTableAdapter();
foreach (var f in dsFiles.GetFilesByUsername(u.Username))
{
dt.Rows.Add(f.Name as string, f.Size as int?, u.Username as string);
}
//DirectoryInfo d = new DirectoryInfo(@u.File_Path);
//try
//{
// FileInfo[] Files = d.GetFiles();
// foreach (var f in Files)
// {
// dt.Rows.Add(f.Name as string, u.Username as string);
// }
//}
//catch { }
}
return(dt);
}
