How should i write this code
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=\"Link\" />" + "<FieldRef Name=\"Contents\" />" + "<FieldRef Name=\"Categories\" />" +
"<FieldRef Name=\"Date1\" Nullable=\"TRUE\"/>";
query.Query = "<OrderBy><FieldRef Name='ID' Ascending='FALSE'></FieldRef></OrderBy>";
query.Webs = "<Webs Scope=\"SiteCollection\" />";
query.RowLimit = 5;
DataTable dt = web.GetSiteData(query);
DataView dv = new DataView(dt);
DetailsView1.DataSource = dv;
DetailsView1.DataBind();
}
Togethor with this code
GridViewRow clickedRow = ((LinkButton)sender).NamingContainer as GridViewRow;