如何从使用linq填充的gridview中获取DatakeyValue

Question

我有以下网格视图：

<asp:GridView ID="gvNOVs" runat="server" AllowPaging="true" AllowSorting="true" PageSize="10"
AutoGenerateColumns="false" Width="100%" BackColor="Transparent" GridLines="None"
RowStyle-HorizontalAlign="Left" PagerSettings-Mode="NumericFirstLast" DataKeyNames="NOVID"
OnRowDataBound="gvNOVs_RowDataBound"
OnRowCommand="gvNOVs_OnSelectRow" 
OnPageIndexChanging="gvNOVs_PageIndexChanging"
OnSorting="gvNOVs_OnSorting"
>
<AlternatingRowStyle CssClass="alternateItemStyle" />
<HeaderStyle CssClass="headerStyle" />
<PagerSettings Mode="NumericFirstLast" />
<RowStyle CssClass="itemStyle" />
<Columns>
<asp:BoundField DataField="NOVID" HeaderText="NOVID" InsertVisible="false" ReadOnly="true" Visible="false"/>
<asp:BoundField DataField="NOVNumber" HeaderText="NOV Number" SortExpression="NOVNumber"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="NOVDate" HeaderText="NOV Date" SortExpression="NOVDate"
ItemStyle-HorizontalAlign="Center" DataFormatString="{0:d}" />
<asp:BoundField DataField="CompanyName" HeaderText="Company Name" SortExpression="CompanyName"
ItemStyle-HorizontalAlign="Center"></asp:BoundField>
<asp:BoundField DataField="CargoTankID" HeaderText="Cargo Tank Number" SortExpression="CargoTankNumber"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="ARBInspectorFirstName" HeaderText="InspectorFirstName"
SortExpression="InspectorFirstName" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="ARBInspectorLastName" HeaderText="InspectorLastName" SortExpression="InspectorLastName"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField DataField="ViolationName" HeaderText="Violation Name" SortExpression="ViolationName"
ItemStyle-HorizontalAlign="Center" />
</Columns>
</asp:GridView>

使用linq:在页面加载事件中填充

var NOVs = from n in db.CT_NOVs
join i in db.CT_Inspectors on n.ARBInspectorID equals i.CTInspectorID
join v in db.CT_ViolationTypes on n.ViolationTypeID equals v.ViolationTypeID
join t in db.CT_Tanks on n.CargoTankID equals t.CargoTankID
join c in db.CT_Companies on t.CompanyID equals c.CompanyID
orderby n.NOVNumber descending
select new
{
n.NOVID,
n.NOVNumber,
NOVDate = n.NOVDate.Value.ToShortDateString(),
ARBInspectorFirstName = i.FirstName,
ARBInspectorLastName = i.LastName,
v.ViolationName,
t.CargoTankID, 
c.CompanyName
};
this.gvNOVs.DataSource = NOVs;
this.gvNOVs.DataBind();

当我点击一行时，我调用这个方法：

protected void gvNOVs_OnSelectRow(object sender, GridViewCommandEventArgs e)
{

}

我不知道如何获取datakeyValue，我想获取被点击行的NOVID。如果我得到e.CommandArgument.ToString()，它会给我CargoTankID的值，我不知道它为什么会给我这个值。

有人知道如何获得所选行的NOVID吗？

Answer 1

这可能会奏效。

1. 从CommandArgument获取索引
2. 从CommandSource获取网格本身
3. 获取数据源

4. 在索引中获取数据项

   int index=int.Parse((字符串)e.CommandArgument)；var grid=(GridView)e。CommandSource；var数据=(IList)网格。数据源；var NOVID=数据[索引]。NOVID；

Answer 2

您应该尝试类似的

string dataKeyValue = (string)this.gvNOVs.SelectedDataKey.Value;