
protected void Button1_Click(object sender, EventArgs e)
{
try
{
if (DropDownListFeeds.SelectedItem.Value == "All")
{
SPWeb web = SPContext.Current.Web;
SPSiteDataQuery query = new SPSiteDataQuery();
query.Lists = "<Lists>" +
"<List ID=" + web.Lists.TryGetList("StaffNews").ID.ToString() + " />" +
"<List ID=" + web.Lists.TryGetList("CompanyNews").ID.ToString() + " />" +
"<List ID=" + web.Lists.TryGetList("ManagementNews").ID.ToString() + " />" +
"</Lists>";
query.ViewFields = "<FieldRef Name=\"Title\" />" +
"<FieldRef Name=\"Date\" Nullable=\"TRUE\"/>";
query.Query = "<OrderBy><FieldRef Name='Modified' Ascending='FALSE'></FieldRef></OrderBy>";
query.Webs = "<Webs Scope=\"SiteCollection\" />";
query.RowLimit = 10;
DataTable dt = web.GetSiteData(query);
DataView dv = new DataView(dt);
GridViewNewsFeed.DataSource = dv;
GridViewNewsFeed.DataBind();
}
}
catch (Exception x)
{
Label1.Text = x.Message;
}
}
Abowe Date and Title i have a Dropdownlist and a Button the code above are for the button.
the code for what happens when i press linkbutton in the first grinview and display it in the other grindview looks like this.
protected void LinkButton1_Click(object sender, EventArgs e)
{
SPWeb web = SPContext.Current.Web;
SPSiteDataQuery query = new SPSiteDataQuery();
query.Lists = "<Lists>" +
"<List ID=" + web.Lists.TryGetList("StaffNews").ID.ToString() + " />" +
"<List ID=" + web.Lists.TryGetList("CompanyNews").ID.ToString() + " />" +
"<List ID=" + web.Lists.TryGetList("ManagementNews").ID.ToString() + " />" +
"</Lists>";
query.ViewFields = "<FieldRef Name=\"Title\" />" +"<FieldRef Name=\"Authors\" />"+"<FieldRef Name=\"Links\" />"+"<FieldRef Name=\"Contents\" />"+
"<FieldRef Name=\"Date\" Nullable=\"TRUE\"/>";
query.Query = "<OrderBy><FieldRef Name='Modified' Ascending='FALSE'></FieldRef></OrderBy>";
query.Webs = "<Webs Scope=\"SiteCollection\" />";
query.RowLimit = 10;
DataTable dt = web.GetSiteData(query);
DataView dv = new DataView(dt);
GridViewShowMore.DataSource = dv;
GridViewNewsFeed.DataBind();
}