Example #1
0
        public void InitGridNguoiDung()
        {
            // tạo các cột
            dtgrNguoiDung.Columns.Clear();
            DataGridViewColumn col00 = new DataGridViewTextBoxColumn();

            col00.Name       = "id";
            col00.HeaderText = "id";
            col00.Width      = 50;
            dtgrNguoiDung.Columns.Add(col00);
            DataGridViewColumn col0 = new DataGridViewTextBoxColumn();

            col0.Name       = "tentk";
            col0.HeaderText = "Tên Tài khoản";
            col0.Width      = 300;
            dtgrNguoiDung.Columns.Add(col0);
            DataGridViewColumn col1 = new DataGridViewTextBoxColumn();

            col1.Name       = "hoten";
            col1.HeaderText = "Họ Tên";
            col1.Width      = 300;
            dtgrNguoiDung.Columns.Add(col1);
            DataGridViewColumn col2 = new DataGridViewTextBoxColumn();

            col2.Name       = "email";
            col2.HeaderText = "Email";
            col2.Width      = 300;
            dtgrNguoiDung.Columns.Add(col2);
            DataGridViewColumn col3 = new DataGridViewTextBoxColumn();

            col3.Name       = "ngaysinh";
            col3.HeaderText = "Ngày Sinh";
            col3.Width      = 250;
            dtgrNguoiDung.Columns.Add(col3);
            //
            DataTable dt = new DataTable();

            dt = b_user.Call_Select_user();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                string id       = dt.Rows[i]["f_ID"].ToString();
                string tentk    = dt.Rows[i]["f_Username"].ToString();
                string hoten    = dt.Rows[i]["f_Name"].ToString();
                string email    = dt.Rows[i]["f_Email"].ToString();
                string ngaysinh = dt.Rows[i]["f_DOB"].ToString();
                dtgrNguoiDung.Rows.Add(id, tentk, hoten, email, ngaysinh);
            }
            //
        }