private void txtFind_OnTextChange(object sender, EventArgs e)
{
string msg = (sender as BunifuTextbox).text;
string filter = string.Format("ad_user like '%{0}%' or isAd = {0}", msg);
HandleGrView.FilterDataTable(viewUser.DataSource as DataTable, filter);
}
private void setDataTable()
{
string query = string.Format("select * from admin_athu where isAd = 0 or ad_user ='******' order by isAd asc", FormLogin.username);
viewUser.DataSource = HandleGrView.GetDataSource(query);
viewUser.Columns["ad_password"].Visible = false;
viewUser.Columns["Images"].Visible = false;
viewUser.Columns["ad_user"].HeaderText = "Username";
viewUser.Columns["isAd"].HeaderText = "Có phải admin";
viewUser.Columns["FullName"].HeaderText = "Tên";
viewUser.Columns["Live"].HeaderText = "Nơi Sống";
viewUser.Columns["DateOfBirth"].HeaderText = "Ngày Sinh";
viewUser.Columns["PhoneNumber"].HeaderText = "Số Điện Thoại";
}