/// <summary> /// method untuk menampilkan data /// </summary> void lihatdata() { AksesDB cek = new AksesDB(); dView1.DataSource = cek.datadb(); dView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; }
/// <summary> /// method ini untuk melihat data di database /// </summary> void lihatdata() { AksesDB cek = new AksesDB(); dView.DataSource = cek.datadb(); dView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; //dView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None; //dView.AllowUserToOrderColumns = true; //dView.AllowUserToResizeColumns = true; //dView.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; //dView.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; //dView.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; //dView.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; //dView.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; }
/// <summary> /// ini fitur untuk mencari data /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tbSearch_TextChanged(object sender, EventArgs e) { AksesDB data = new AksesDB(); String datacari = tbSearch.Text; dt = data.caridata(datacari); if (tbSearch.Text != "") { // koneksi.Open(); // string query = "select * from penghunikoskosan where Nama like '%" + datacari + "%' or NoKamar like'%"+datacari+"%'"; // da = new SqlDataAdapter(query, koneksi); // dt = new DataTable(); // da.Fill(dt); // koneksi.Close(); dView.DataSource = dt; } else if (tbSearch.Text == "") { dView.DataSource = data.datadb(); dView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; } }