列表视图UpdateCommand传递空值

Question

我正在尝试获得一个自动绑定和更新数据元素的listview。在看了许多示例和教程之后，我似乎仍然找不到我的代码的错误所在。显示器工作正常。失败的只是update命令。这是我的SqlDataSource节点：

<asp:SqlDataSource ID="MSSQLDataSource" runat="server"
                   ConnectionString="<%$ ConnectionStrings:DBConn%>"
                   DataSourceMode="DataSet"
                   SelectCommand="select isnull(visits, 0) as Visits, iis.VirtualName, iis.clientname, iis.devurl, iis.stagingurl , iis.liveurl from iissites iis left join (select count(*) as visits, VirtualName from devvisits group by VirtualName) dv on iis.VirtualName = dv.VirtualName order by visits desc" UpdateCommand="update iissites set clientname = @clientname, stagingurl = @stagingurl where VirtualName = @VirtualName">
    <UpdateParameters>
        <asp:Parameter Name="clientname" Type="String" />
        <asp:Parameter Name="stagingurl" Type="String" />
        <asp:Parameter Name="VirtualName" Type="String" />
    </UpdateParameters>
</asp:SqlDataSource>

请注意，@VirtualName参数正在被拾取(但未绑定，因为它是PK)。这是我的asp:ListView节点：

<asp:ListView DataSourceID="MSSQLDataSource" runat="server" DataKeyNames="VirtualName">            
    <LayoutTemplate>
        <table cellpadding="1">
            <tr id="Tr1" runat="server">
                <th>&nbsp;</th>
                <th id="Th2">Clent Name</th>
                <th id="Th1">Local Site</th>
                <th id="Th3">LHits</th>
                <th>Staging</th>
            </tr>
            <tr id="ItemPlaceHolder" runat="server" ></tr>
        </table>
    </LayoutTemplate>

    <ItemTemplate>
        <tr runat="server" class='<%# Container.DataItemIndex % 2 == 0 ? "row" : "row alt" %>'>
           <td class="command"><asp:ImageButton ImageUrl="images/edit.jpg"  ID="btnEdit" runat="server"  Text="Edit" CommandName="Edit" /></td>
            <td>
                <%#Eval("clientname") ?? "nbsp;" %>
            </td>
            <td align="left">
                <asp:LinkButton ID="LinkButton1" OnCommand="clickLink"
                                CommandName="devvisits" CommandArgument='<%#Eval("VirtualName") %>'
                                runat="server" ><%#Eval("VirtualName") ?? "nbsp;"%>
                </asp:LinkButton>
            </td>
            <td align="left">
                <%#Eval("Visits") ?? "nbsp;" %>
            </td>
            <td>
                <%#Eval("stagingurl") ?? "nbsp;" %>
            </td>
        </tr>
    </ItemTemplate>

    <EditItemTemplate>
        <tr id="TrEdit" runat="server">
            <td>
                <asp:ImageButton ImageUrl="images/cancel.jpg" runat="server" CommandName="Cancel" />
                <asp:ImageButton ImageUrl="images/save.jpg" runat="server" ID="UpdateButton" CommandName="Update" />
            </td>
            <td>
                <asp:TextBox ID="clientname" runat="server" Text='<%#Bind("clientname") %>'  ></asp:TextBox>
            </td>
            <td align="left">
                <asp:Label ID="VirtualName" runat="server">
                    <asp:LinkButton ID="LinkButton2" OnCommand="clickLink"
                                    CommandName="devvisits"
                                    CommandArgument='<%#Eval("VirtualName") %>'
                                    runat="server" ><%#Eval("VirtualName") %>
                    </asp:LinkButton>
                </asp:Label>
            </td>
            <td align="left">
                <asp:Label ID="DevHits" runat="server">
                   <%#Eval("Visits") %>
                </asp:Label>
            </td>
            <td align="left">
                <asp:TextBox ID="TextBox2" runat="server" Text='<%#Bind("stagingurl") %>'  ></asp:TextBox>
            </td>
        </tr>
    </EditItemTemplate>
</asp:ListView>

任何反馈都将不胜感激。

-Jesse

Answer 1

我也和它斗争了很久，找到了一个变通的方法，但它真的很难看。我从ListView ItemUpdating事件中的控件中获取值，将值存储在局部变量中，然后处理objectdatasource更新事件，使用这些值设置对象的属性。我使用objectdatasource的DataObjectTypeName。我不喜欢这个解决方案，但这是唯一对我有效的方法，我可以继续前进……