/// <summary>
/// Searches the database for files and returns the results.
/// </summary>
/// <param name="searchTerm">The search term.</param>
private void searchFiles(string searchTerm)
{
DatabaseFileSystem dfs = new DatabaseFileSystem();
string[] subinfo = new string[5];
listView.Clear();
listView.Columns.Add("Name", 255);
listView.Columns.Add("Path", 300);
listView.Columns.Add("Size", 100);
listView.Columns.Add("Type", 80);
listView.Columns.Add("Date Modified", 150);
FileSystemDataSet.FilesDataTable dataTable = dfs.searchFile(searchTerm);
foreach (DataRow dr in dataTable.Rows)
{
subinfo[0] = dr["filename"].ToString();
subinfo[1] = dr["path"].ToString();
subinfo[2] = dr["size"].ToString();
subinfo[3] = dr["type"].ToString();
subinfo[4] = dr["date_modified"].ToString();
ListViewItem FItems = new ListViewItem(subinfo);
listView.Items.Add(FItems);
}
}
/// <summary>
/// Searches the file in the database.
/// </summary>
/// <param name="searchTerm">The search term.</param>
/// <returns></returns>
public FileSystemDataSet.FilesDataTable searchFile(string searchTerm)
{
searchTerm = string.Format("%{0}%", searchTerm); // Add in wildcard characters on each side
FileSystemDataSet.FilesDataTable dataTable = _tableAdapter.SearchData(searchTerm);
return(dataTable);
}
