protected void btnrespforn_Click(object sender, EventArgs e) { DataAccess Conn = (DataAccess)Session["DBUserConn"]; QueryHelper QHS; QHS = Conn.GetQueryHelper(); string filter; if (userkind.SelectedValue == "1") { // Responsabili filter = QHS.AppAnd(QHS.CmpEq("active", "S"), QHS.IsNotNull("userweb"), QHS.CmpNe("userweb", "")); DataTable DT = Conn.RUN_SELECT("manager", "idman,title,userweb", "title asc", filter, null, false); if (DT == null || DT.Rows.Count == 0) { return; } RenderManagersTable(DT); } if (userkind.SelectedValue == "2") { // Fornitori string query = "select registryreference.idregistryreference as idregistryreference, registry.idreg as idreg,registry.title as Anagrafica, registryreference.referencename as Riferimento, registryreference.userweb as Login "; query += " from registry join registryreference on (registry.idreg=registryreference.idreg) where registry.active='S' "; query += " and userweb is not null and userweb <>''"; DataTable DT = Conn.SQLRunner(query); if (DT == null || DT.Rows.Count == 0) { return; } RenderRegistryTable(DT); } }