public void setDataGridView(DataGridView DG)
{
this.dataGridView1.DefaultCellStyle.Font = new Font("Calibri", 12);
DG.DataSource = CSTMR_C.showCustomer();
DataTable DT = CSTMR_C.showCustomer();
BindingList <DataTable> listTbl = new BindingList <DataTable>();
if (DT.Rows.Count > 0)
{
int counter = 0, subTblIndex = -1;
foreach (DataRow dr in DT.Rows)
{
if (counter == 0)
{
listTbl.Add(DT.Clone());
subTblIndex++;
}
listTbl[subTblIndex].Rows.Add(dr.ItemArray);
counter++;
if (counter == 10)
{
counter = 0; //set jumlah baris
}
}
}
bindingSource1.DataSource = listTbl;
bindingNavigator1.BindingSource = bindingSource1;
DG.DataSource = (DT.Rows.Count > 0 ? listTbl[bindingSource1.Position] : DT);
DG.Columns[0].HeaderText = "ID";
DG.Columns[1].HeaderText = "Nama";
DG.Columns[2].HeaderText = "Tanggal Lahir";
DG.Columns[3].HeaderText = "Jenis Kelamin";
DG.Columns[4].HeaderText = "Alamat";
DG.Columns[5].HeaderText = "Telepon";
DG.Columns[6].HeaderText = "Email";
DG.Columns[7].HeaderText = "Alergi";
DG.Columns[8].HeaderText = "Tanggal Registrasi";
DG.Columns[9].HeaderText = "Poin";
DG.Columns[10].HeaderText = "Password";
DG.Columns[0].Width = 130;
DG.Columns[3].Width = 50;
DG.Columns[8].Width = 145;
DG.Columns[9].Width = 50;
DG.Columns[2].Width = 150;
DG.Columns[8].Width = 150;
DG.Columns[10].Width = 95;
DG.Columns[2].DefaultCellStyle.Format = "dd - MMMM - yyyy";
DG.Columns[8].DefaultCellStyle.Format = "dd - MMMM - yyyy";
DG.Columns[10].Visible = false;
}
public void setDataGridView(DataGridView DG)
{
dt.Clear();
MySqlDataAdapter adapter = cc.showCustomer();
adapter.Fill(dt);
DG.DataSource = dt;
DG.Columns[0].HeaderText = "ID";
DG.Columns[1].HeaderText = "Nama";
DG.Columns[2].HeaderText = "Alamat";
DG.Columns[3].HeaderText = "Tanggal Lahir";
DG.Columns[4].HeaderText = "Nomor Telp";
}