В GridView1 есть столбец asp:CommandField c ShowDeleteButton="True". При нажатии на кнопку "DELETE" на MSSQL отправляется команда с параметрами, равными NULL:
1.
exec sp_executesql N'exec xAuthorDelete @UserID, @AuthorID',N'@UserID int,@AuthorID int', @UserID=NULL,@AuthorID=NULL
До этого удаление работало, но вчера сдуру залез в "Configure Data Source" и... :(
GridView1
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
<asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#CCCCCC"
BorderWidth="1px" CellPadding="3" EnableSortingAndPagingCallbacks="True" Width="98%"
AutoGenerateColumns="False" BorderStyle="None" AllowSorting="True" AllowPaging="True"
DataSourceID="SqlDataSource1" DataKeyNames="AuthorID,UserID" PageSize="6">
<FooterStyle BackColor="White" ForeColor="#000066" />
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" Font-Bold="True" />
<SelectedRowStyle BackColor="#669999" ForeColor="White" BorderColor="DarkRed" BorderStyle="Solid"
BorderWidth="2px" Font-Bold="True" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="AuthorID" HeaderText="AuthorID" InsertVisible="False"
SortExpression="AuthorID" ReadOnly="True">
<ItemStyle CssClass="border_ordinary" />
</asp:BoundField>
<asp:BoundField DataField="UserID" HeaderText="UserID" SortExpression="UserID" ReadOnly="True">
<ItemStyle CssClass="border_ordinary" />
</asp:BoundField>
<asp:HyperLinkField DataNavigateUrlFields="AuthorURL" DataTextField="AuthorName"
HeaderText="Автор (на СИ)" SortExpression="AuthorName" Target="_blank">
<ItemStyle CssClass="border_ordinary" />
</asp:HyperLinkField>
<asp:HyperLinkField DataNavigateUrlFields="AuthorID" DataNavigateUrlFormatString="BookList.aspx?AuthorID={0}"
DataTextField="BookCnt" DataTextFormatString="{0}" HeaderText="Книги" SortExpression="BookCnt">
<ItemStyle CssClass="border_ordinary" />
</asp:HyperLinkField>
<asp:BoundField DataField="MaxWasChange" HeaderText="Изменения" SortExpression="MaxWasChange"
DataFormatString="{0:d}" ReadOnly="True">
<ItemStyle CssClass="border_ordinary" />
</asp:BoundField>
<asp:BoundField DataField="PeriodName" HeaderText="Когда?" SortExpression="MaxWasChange"
ReadOnly="True">
<ItemStyle CssClass="border_ordinary" />
</asp:BoundField>
<asp:CommandField ButtonType="Image" DeleteImageUrl="~/Image/delete48.png" HeaderText="Удалить"
ShowDeleteButton="True">
<ItemStyle CssClass="border_ordinary" />
</asp:CommandField>
</Columns>
<RowStyle ForeColor="#000066" />
<PagerSettings Mode="NumericFirstLast" Position="TopAndBottom" FirstPageText="[begin]"
LastPageText="[end]" PageButtonCount="4" />
</asp:GridView>
SqlDataSource1
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [vAuthorForUser] WHERE UserID = 1"
DeleteCommand="exec xAuthorDelete @UserID, @AuthorID" DeleteCommandType="Text"
>
<DeleteParameters>
<asp:Parameter Name="UserID" Type="Int32" />
<asp:Parameter Name="AuthorID" Type="Int32" />
</DeleteParameters>
</asp:SqlDataSource>
