protected void btn_search_Click(object sender, EventArgs e) { int cId = Convert.ToInt32(ddlRoles.SelectedValue); AdminBSO adminBSO = new AdminBSO(); //DataTable table = adminBSO.AdminGetAllRolesByID(cId); DataTable dataTable = new DataTable(); commonBSO commonBSO = new commonBSO(); DataTable table = adminBSO.GetAllAdminRoles(); DataView dataView = new DataView(table); //dataView.RowFilter = "Admin_Username <> 'administrator' and Admin_Username <> 'Administrator'"; if (cId == 0) { dataView.RowFilter = "Admin_Username not in ('administrator','Administrator')"; dataTable = dataView.ToTable(); commonBSO.FillToGridView(grvAdmin, dataTable); } else { AdminRolesBSO adminRolesBSO = new AdminRolesBSO(); string strUser = adminRolesBSO.GetAdminUserName1(cId); if (strUser != "") { DataTable table1 = adminBSO.GetAdminBystrName(strUser); commonBSO.FillToGridView(grvAdmin, table1); } } }