How to get id in gridview from list

Question

protected void LinkButton1_Click(object sender, EventArgs e)
    {
        try
        {
            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=\"Attachments\" />" + "<FieldRef Name=\"Authors\" />" + "<FieldRef Name=\"Link\" />" + "<FieldRef Name=\"Contents\" />" + "<FieldRef Name=\"Categories\" />" +
                               "<FieldRef Name=\"Date1\" Nullable=\"TRUE\"/>";

            query.Webs = "<Webs Scope=\"SiteCollection\" />";

            query.RowLimit = 5;

            DataTable dt = web.GetSiteData(query);

            DataView dv = new DataView(dt);

            DetailsView1.DataSource = dv;
            DetailsView1.DataBind();
        }
        catch (Exception x)
        {
            Label1.Text = x.Message;
        }
    }

I am displaying the title and date in a gridview when i click the linkbutton i want it to show that information in a detailview. i am using a visual webpart.

Answer 1

What if you put your UniqueId to CommandeArgument of the buton and get it back when link button is clicked? Once you get your value you just split this using SPFieldLookupValue and get your ID to filter:

<asp:LinkButton ID="LinkButton1" OnClick="LinkButton1_Click" runat="server" Text='<%# Bind("Title") %>' CommandArgument='<%# Bind("UniqueId")%>'></asp:LinkButton>

in the click event:

LinkButton lb = (LinkButton) sender;
SPFieldLookupValue f = new SPFieldLookupValue(lb.CommandArgument);
string itemID = f.LookupValue;

Do not forget to make a field reference to get UniqueId using CAML:

query.ViewFields = "<FieldRef Name=\"Title\" />" +
                            "<FieldRef Name=\"Authors\" />" +
                            "<FieldRef Name=\"Link\" />" +
                            "<FieldRef Name=\"Contents\" />" +
                            "<FieldRef Name=\"_Category\" />" +
                            "<FieldRef Name=\"UniqueId\" />" +
                             "<FieldRef Name=\"Date1\" Nullable=\"TRUE\"/>";

Hope it helps,

Andrew

Answer 2

This is what you do:

<asp:TemplateField>
 <ItemTemplate>
<asp:LinkButton ID="LinkButton1" onclick="LinkButton1_Click" CommandArgument='<%# Eval("ID") %>' runat="server" Text='<%# Bind("Title") %>'></asp:LinkButton>
 </ItemTemplate>
</asp:TemplateField>       

Then, in your code behind:

    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        LinkButton btn = sender as LinkButton;
        var listItemID = btn.CommandArgument;
    }

Hope this helps