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); }