/// <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;
}
}