If I use the delete SQL code in line it works fine. If I use a stored procedure to perform the SQL work, I can't determine how to pass the identity value to the SP. Snippets are below...
The grid
<asp:GridView ID="GridView2" runat="server" AllowPaging="True" AllowSorting="True"
                    AutoGenerateColumns="False" DataSourceID="SqlDataSource2">
                    <Columns>
                        <asp:BoundField DataField="member_id" HeaderText="member_id" InsertVisible="False"
                            ReadOnly="True" SortExpression="member_id" />
                        <asp:BoundField DataField="member_username" HeaderText="member_username" SortExpression="member_username" />
                        <asp:BoundField DataField="member_firstname" HeaderText="member_firstname" SortExpression="member_firstname" />
                        <asp:BoundField DataField="member_lastname" HeaderText="member_lastname" SortExpression="member_lastname" />
                        <asp:BoundField DataField="member_state" HeaderText="State" SortExpression="member_state" />
                        <asp:CommandField ShowEditButton="True" />
                        <asp:CommandField ShowDeleteButton="True" />
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:rentalConnectionString1 %>"
                    SelectCommand="renMemberSelect" SelectCommandType="StoredProcedure"
                    DeleteCommand="renMemberDelete"  DeleteCommandType="StoredProcedure"
                      OldValuesParameterFormatString="original_{0}"
                    >
                   
                     <DeleteParameters>
                    
                        <asp:Parameter  Name="member_id" Type="Int32"  />
                       
                      </DeleteParameters>
                       
                    </asp:SqlDataSource
the SP
CREATE PROCEDURE renMemberDelete
@.member_id  as int
As UPDATE [renMembers]
SET member_status=1
WHERE [member_id] = @.member_id
GO
Try:GridView2.DataKeyNames="member_id"
or
<asp:GridView ID="GridView2" runat="server" AllowPaging="True" AllowSorting="True"
                    AutoGenerateColumns="False" DataSourceID="SqlDataSource2" DataKeyNames="member_id">
 
No comments:
Post a Comment