private void button1_Click(object sender, EventArgs e) { string query = @"select Klienti.Imia,Klienti.Familia,Klienti.Otchestvo,Tovar.Srok_otkladivania_tovara_v_nedelah,Sdacha_v_Lambard.Data_prodaji,Tovar.Sostoianie_prodaji from dbo.Klienti, dbo.Sdacha_v_Lambard, dbo.Tovar where Tovar.Srok_otkladivania_tovara_v_nedelah = '1'and Tovar.Sostoianie_prodaji != 'Распродан'"; var list = DBConnectionService.SendQueryToSqlServer(query); Form2.ClearAndAddColumnsDataGridView(dataGridView1, "Familia", "Imia", "Otchestvo", "Srok_otkladivania_tovara_v_nedelah", "Data_prodaji", "Sostoianie_prodaji"); foreach (var row in list) { dataGridView1.Rows.Add(row[0], row[1], row[2], row[3], row[4], row[5]); } }