从ASP.NET GridView获取DataRow [英] Getting a DataRow from an ASP.NET GridView

问题描述

我有一个ASP.NET GridView 绑定到一个 ObjectDataSource （绑定到一个MySQL数据库） 。在这个网格上，我有2个未绑定的 ButtonField 列，我想触发服务器端事件。因此，我已经在 GridView 的 RowCommand 事件中添加了一个事件处理程序。

I have an ASP.NET GridView that's bound to an ObjectDataSource (which is bound to a MySQL database). On this grid, I have 2 unbound ButtonField columns that I want to trigger server-side events. Hence I have added an eventhandler method to the GridView's RowCommand event.

在所述事件处理程序的代码中，我需要以某种方式掌握用户点击的底层 DataRow 。但是，我似乎不能让这个工作;如果我使用如下代码，则 selectedRow 变量总是 null ：

In the code of said eventhandler, I need to somehow get hold of the underlying DataRow that was clicked on by the user. However, I can't seem to get this to work; if I use code like the following the selectedRow variable is always null:

protected void searchResultsGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
  CallDataRow selectedRow = (CallDataRow) searchResultsGridView.Rows[Convert.ToInt32(e.CommandArgument)].DataItem;
}

我已经Google搜索和找到的页面，如 http：//ranafaisal.wordpress .com / 2008/03/31 / how-to-get-the-current-row-in-gridview-row-command-event ，但我发现没有任何工作。我很确定我只是缺少一些明显的东西，但是我无法弄明白什么...

I've Googled and found pages such as http://ranafaisal.wordpress.com/2008/03/31/how-to-get-the-current-row-in-gridview-row-command-event, but nothing I've found has worked. I'm pretty sure I'm just missing something obvious, but I can't figure out what...

这是ASP.NET代码，如果这有帮助： / p>

Here's the ASP.NET code if that helps:

  <asp:GridView ID="searchResultsGridView" runat="server" AutoGenerateColumns="False" 
    DataKeyNames="PersonNo,CallDate" 
    Width="100%" AllowPaging="True" EnableSortingAndPagingCallbacks="True" 
    onrowcommand="searchResultsGridView_RowCommand" PageSize="20">
    <Columns>
      <asp:BoundField DataField="PersonNo" HeaderText="Account number" ReadOnly="True" 
        SortExpression="PersonNo" />
      <asp:BoundField DataField="AgentNo" HeaderText="Agent number" 
        SortExpression="AgentNo" />
      <asp:BoundField DataField="AgentName" HeaderText="Agent name" 
        SortExpression="AgentName" />
      <asp:BoundField DataField="TelNumber" HeaderText="Telephone number" 
        SortExpression="TelNumber" />
      <asp:BoundField DataField="CallDate" HeaderText="Call date/time" ReadOnly="True" 
        SortExpression="CallDate" />
      <asp:ButtonField CommandName="play" HeaderText="Audio" ShowHeader="True" 
        Text="Play" />
      <asp:ButtonField CommandName="download" Text="Download" />
    </Columns>
  </asp:GridView>

推荐答案

最后通过执行以下操作使其工作： / p>

Finally got it to work by doing the following:

1. 添加包含绑定的HiddenField的TemplateField。

1. Adding a TemplateField containing a bound HiddenField.

<asp:TemplateField ShowHeader="False">
  <ItemTemplate>
    <asp:HiddenField ID="audioFileName" runat="server" Value='<%# Eval("AudioFileName") %>' />
  </ItemTemplate>
</asp:TemplateField>

在RowCommand事件处理程序中添加以下代码：

Adding the following code in the RowCommand event handler:

protected void searchResultsGridView_RowCommand(object sender, GridViewCommandEventArgs e)
{
  string audioFile = ((HiddenField) searchResultsGridView.Rows[Convert.ToInt32(e.CommandArgument)].FindControl("audioFileName")).Value;
}

这是一个污泥它不是特别安全，但它的工作，这就是我现在所需要的。任何更好的解决方案仍然欢迎，但...

It's a cludge and it's not particularly secure, but it works and that's all I need right now. Any better solutions are still welcome though...

这篇关于从ASP.NET GridView获取DataRow的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！