hi all,
I have 8 lists. These 8 lists have 7 fields in common. I would like it to change the grid when I choose one of the lists with the enter button, but not working. Please can u help me?
this is aspx code
code ascx.cs
protected void Page_Load(object sender, EventArgs e)
{
// _id = Page.Request.QueryString["ID"];
if (!Page.IsPostBack)
{
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
//CaricaTendina(ElevatedWeb);
// CaricaGriglia(ElevatedWeb);
CaricaItem(ElevatedWeb);
}
});
}
}
private void CaricaItem(SPWeb web)
{
// _id = Page.Request.QueryString["ID"];
if (!Page.IsPostBack)
{
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
//CaricaTendina(ElevatedWeb);
// CaricaGriglia(ElevatedWeb);
CaricaItem(ElevatedWeb);
}
});
}
}
protected void btnCerca_Click(object sender, EventArgs e)
{
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
CaricaItem(ElevatedWeb);
}
});
}
{
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
CaricaItem(ElevatedWeb);
}
});
}
protected void btnAnnulla_Click(object sender, EventArgs e)
{
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
PulisciControlli();
CaricaItem(ElevatedWeb);
}
});
}
{
SPSecurity.RunWithElevatedPrivileges(delegate ()
{
using (SPSite ElevatedSite = new SPSite(SPContext.Current.Web.Site.ID))
using (SPWeb ElevatedWeb = ElevatedSite.OpenWeb(SPContext.Current.Web.ID))
{
PulisciControlli();
CaricaItem(ElevatedWeb);
}
});
}
private void PulisciControlli()
{
{
txtAttivita.Text = "";
txtEsito.Text = "";
txtCausale.Text = "";
txtOrigineCSV.Text = "";
}
txtEsito.Text = "";
txtCausale.Text = "";
txtOrigineCSV.Text = "";
}
private void CaricaItem(SPWeb web)
{
SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/");
SPListItemCollection items = listaGestAtt.GetItems();
SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/");
SPListItemCollection items = listaGestAtt.GetItems();
var itemBindabili = from SPListItem i in items.Cast()
select new
{
ID = i.ID, // va messo xk nella griglia hai DataKeyNames="ID"
Titolo = i["Title"],
Attivita = new SPFieldLookupValue(i["Attivit_x00e0_"] as String).LookupValue, // i["Attivit_x00e0_"], // va preso internal name del campo
OrigineCSV = new SPFieldLookupValue(i["OrigineCSV"] as String).LookupValue,
IDUtente = ControllaID(web, Convert.ToString(i["Utente"])),
Utente = ControllaUtente(web, Convert.ToString(i["Utente"])),
Esito = new SPFieldLookupValue(i["Esito"] as String).LookupValue,
Causale = new SPFieldLookupValue(i["Causale"] as String).LookupValue
};
select new
{
ID = i.ID, // va messo xk nella griglia hai DataKeyNames="ID"
Titolo = i["Title"],
Attivita = new SPFieldLookupValue(i["Attivit_x00e0_"] as String).LookupValue, // i["Attivit_x00e0_"], // va preso internal name del campo
OrigineCSV = new SPFieldLookupValue(i["OrigineCSV"] as String).LookupValue,
IDUtente = ControllaID(web, Convert.ToString(i["Utente"])),
Utente = ControllaUtente(web, Convert.ToString(i["Utente"])),
Esito = new SPFieldLookupValue(i["Esito"] as String).LookupValue,
Causale = new SPFieldLookupValue(i["Causale"] as String).LookupValue
};
grdItems.DataSource = itemBindabili.ToList();
grdItems.DataBind();
}
grdItems.DataBind();
}
private string ControllaUtente(SPWeb web, string fieldValue)
{
if (!string.IsNullOrEmpty(fieldValue))
{
if (!string.IsNullOrEmpty(fieldValue))
return new SPFieldUserValue(web, fieldValue).User.Name;
else
return (fieldValue);
}
return (fieldValue);
}
private int ControllaID(SPWeb web, string fieldValue)
{
if (!string.IsNullOrEmpty(fieldValue))
{
if (!string.IsNullOrEmpty(fieldValue))
return new SPFieldUserValue(web, fieldValue).User.ID;
else
return -1;
}
return -1;
}
protected void ddlListaDiRiferimento_SelectedIndexChanged(object sender, EventArgs e)
{
{
string value = ddlListaDiRiferimento.SelectedValue;
}
Barbara BarbaraPosted Mar 23, 2020, 11:05 AM
SPList listaGestAtt = web.GetList(web.ServerRelativeUrl + "/Lists/" + ........);
Barbara BarbaraPosted Mar 23, 2020, 10:55 AM
Vinay SinghPosted Mar 23, 2020, 10:45 AM