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]);
}
}
