I am using VS2005 and SQL Server 2005. The problem I am having is when I call my SQLDataSource to delete rows the delete is firing twice. The trace and debugging show the code executing once. In fact right after the delete, the table only shows one delete, but right after the command function is exited the 2nd row is deleted. Also, I have tested the stored procedure to make sure it only deletes 1 one and then resequences the records.
Show below are excerpts from my .aspx and code behind files.
<asp:LinkButton ID="PreCompanyCensusDeleteBtn" runat="server"
CommandArgument='<%# Eval("PecEmpSeqNr") %> />
<asp:SqlDataSource ID="PreCompanyCensusGridViewDataSource" ConnectionString="<%$ ConnectionStrings:PreCompanyConnectionString %>"
DataSourceMode="dataset" SelectCommand="PreCompanyCensusSelect" SelectCommandType="StoredProcedure"
View Complete Post