コード例 #1
0
ファイル: CustomersForm.cs プロジェクト: Pandanom/DB
        private void ShowDb()
        {
            CustTable.Rows.Clear();
            CustTable.Columns.Clear();
            CustTable.Refresh();
            for (int i = 0; i < checkColls.Count; i++)
            {
                if (checkColls[i].Checked)
                {
                    CustTable.Columns.Add(coll[i], coll[i]);
                }
            }


            Table <User> users = db.GetTable <User>();

            foreach (var user in users)
            {
                DataGridViewRow row = new DataGridViewRow();
                row.CreateCells(CustTable);
                int j = 0;
                for (int i = 0; i < checkColls.Count; i++)
                {
                    if (checkColls[i].Checked)
                    {
                        if (i == 8)
                        {
                            row.Cells[j].Value = mnr.GetItem(int.Parse(user.GetCell(i))).FullName;
                        }
                        else
                        {
                            row.Cells[j].Value = user.GetCell(i);
                        }
                        j++;
                    }
                }
                CustTable.Rows.Add(row);
            }
            CustTable.Refresh();
        }