private void информацияОКлиентахToolStripMenuItem_Click(object sender, EventArgs e)
{
clients clnt = new clients();
clnt.Show();
this.Close();
}
private void loadDataGridView(string tableName)
{
if (tableName == "owners")
{
owners owners = new owners();
owners.dataGridView1.DataSource = null;
PublicClasses.sql = "select * from owners where isDeleted=0";
owners.dataGridView1.DataSource = PublicClasses.executeSqlRequest().Tables[0];
owners.dataGridView1.Columns[0].Visible = false;
owners.dataGridView1.Columns[6].Visible = false;
owners.dataGridView1.Columns[1].HeaderText = "Фамилия";
owners.dataGridView1.Columns[2].HeaderText = "Имя";
owners.dataGridView1.Columns[3].HeaderText = "Отчество";
owners.dataGridView1.Columns[4].HeaderText = "Адрес";
owners.dataGridView1.Columns[5].HeaderText = "Телефон";
owners.Show();
}
else
{
clients clients = new clients();
clients.dataGridView1.DataSource = null;
PublicClasses.sql = "select * from clients where isDeleted=0";
clients.dataGridView1.DataSource = PublicClasses.executeSqlRequest().Tables[0];
clients.dataGridView1.Columns[0].Visible = false;
clients.dataGridView1.Columns[6].Visible = false;
clients.dataGridView1.Columns[1].HeaderText = "Фамилия";
clients.dataGridView1.Columns[2].HeaderText = "Имя";
clients.dataGridView1.Columns[3].HeaderText = "Отчество";
clients.dataGridView1.Columns[4].HeaderText = "Адрес";
clients.dataGridView1.Columns[5].HeaderText = "Телефон";
clients.Show();
}
}