//Отбор клиентов по городу
private void filterCityBtn_Click(object sender, EventArgs e)
{
try
{
clientName.Text = "";
clientsTable.DataSource = null;
DBConnection.FilterCity(city.SelectedValue.ToString());
clientsTable.DataSource = DBConnection.dtClients;
if (DBConnection.dtClients.Rows.Count > 0)
{
ReadClientsTableRow(0);
}
}
catch (Exception ex)
{
exceptPanel.Visible = true;
richTextBox1.Text = ex.ToString();
}
}