Exemplos de WindowsFormsApp2 Form5.ClearAndAddColumnsDataGridView em C# (CSharp)

Exemplo n.º 1

        private void button1_Click(object sender, EventArgs e)
        {
            string query = @"SELECT count(Kategorii_tovarov.Nasvanie),Nasvanie
            from dbo.Kategorii_tovarov
            group by Nasvanie";
            var    list  = DBConnectionService.SendQueryToSqlServer(query);

            Form5.ClearAndAddColumnsDataGridView(dataGridView1, "Kategorii_tovarov.Nasvanie");
            foreach (var row in list)
            {
                dataGridView1.Rows.Add(row[0], row[1]);
            }
        }