//This method fills a list of available filters to show their values in the dropdown lists
public string[,] LoadFiltersData()
{
DataAccess dataFilters = new DataAccess();
DataSet dataSetFilters = dataFilters.GetDataFilters();
DataTable dataTable = new DataTable();
//Main table
dataTable = dataSetFilters.Tables[0];
int countRow = 0;
int countColumn = 0;
string[,] listFilters = new string[dataTable.Rows.Count, dataTable.Columns.Count];
//Filling list
foreach (DataRow row in dataTable.Rows)
{
foreach (DataColumn column in dataTable.Columns)
{
if (row[column] != null)
{
listFilters[countRow, countColumn] = Convert.ToString(row[column]);
countColumn++;
}
}
countRow++;
countColumn = 0;
}
return listFilters;
}
