Exemple #1
0
        private void fillGrid(String query, int i)
        {
            dc.openCon();
            SqlDataAdapter da = dc.selectTable(query);
            DataTable      dt = new DataTable();

            da.Fill(dt);
            if (i == 1)
            {
                metroGrid1.DataSource = dt;
                DataGridViewButtonColumn col = new DataGridViewButtonColumn();
                col.UseColumnTextForButtonValue = true;
                col.Text = "Delete";
                col.Name = "deleteUsr";
                metroGrid1.Columns.Add(col);
                dc.closeCon();
            }
            else
            {
                metroGrid2.DataSource = dt;
                DataGridViewButtonColumn col = new DataGridViewButtonColumn();
                col.UseColumnTextForButtonValue = true;
                col.Text = "Delete";
                col.Name = "deleteUsr";
                metroGrid2.Columns.Add(col);
                dc.closeCon();
            }
        }
Exemple #2
0
        void dispTableLog(String query)
        {
            DataCon dc = new DataCon();

            SqlDataAdapter da = dc.selectTable(query);
            DataTable      dt = new DataTable();

            da.Fill(dt);
            metroGrid2.DataSource = dt;
        }