[VB.NET] Mon gridview ne s'update pas.

Bonjour,

J'ai le gridview suivant :

Code:

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
43
44
45
46
47
<asp:GridView ID="gvUserBooking" runat="server" AllowPaging="True" AllowSorting="True"
                    AutoGenerateColumns="False" DataKeyNames="IdAccessoriesBook" DataSourceID="sdsgvUserBooking"
                    PagerStyle-CssClass="pgr" Width="99%" BorderStyle="Solid" CssClass="mGrid" HorizontalAlign="Center">
                    <Columns>
                        <asp:TemplateField ShowHeader="False">
                            <EditItemTemplate>
                                  <asp:ImageButton ID="ImageButton1" runat="server" CausesValidation="False" 
                                    CommandName="Update" ImageUrl="~/imgs/.gif" Text="Update" />
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:ImageButton ID="ImageButton1" runat="server" CausesValidation="False" 
                                    CommandName="Select" ImageUrl="~/imgs/Icon_Literature_16.gif" Text="Select" />
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="UserID" HeaderText="User ID" SortExpression="UserID" 
                            ReadOnly="True" />
                        <asp:BoundField DataField="FirstName" HeaderText="First Name" 
                            SortExpression="FirstName" ReadOnly="True" />
                        <asp:BoundField DataField="LastName" HeaderText="Last Name" 
                            SortExpression="LastName" ReadOnly="True" />
                        <asp:TemplateField HeaderText="Building" SortExpression="BuildingName">
                            <EditItemTemplate>
                                  <asp:Label ID="Label1" runat="server" Text='<%# Bind("BuildingName") %>'></asp:Label>
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:Label ID="Label2" runat="server" Text='<%# Bind("BuildingName") %>'></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="AccessoriesName" HeaderText="Accessories" 
                            SortExpression="AccessoriesName" ReadOnly="True" />
                        <asp:TemplateField HeaderText="Return Date" SortExpression="ReturnDate">
                            <EditItemTemplate>
                               <asp:Label ID="Label5" runat="server" Text='<%# Bind("ReturnDate", "{0:dd/MM/yyyy}") %>'></asp:Label>
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:Label ID="Label1" runat="server" Text='<%# Bind("ReturnDate", "{0:dd/MM/yyyy}") %>'></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="IdAccessoriesBook" HeaderText="IdAccessoriesBook" InsertVisible="False"
                            ReadOnly="True" SortExpression="IdAccessoriesBook" Visible="False" />
                        <asp:CheckBoxField DataField="IsAttribution" HeaderText="IsAttribution" SortExpression="IsAttribution"
                            Visible="False" />
                        <asp:CheckBoxField DataField="IsReturn" HeaderText="Return" 
                            SortExpression="IsReturn" />
                    </Columns>
                    <PagerStyle CssClass="pgr" ForeColor="#F0AB00" />
                </asp:GridView>

Attaché a la datasource suivante :

Code:

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
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
<asp:SqlDataSource ID="sdsgvUserBooking" runat="server" ConflictDetection="CompareAllValues"
        ConnectionString="<%$ ConnectionStrings:IT_Rent_connection %>" DeleteCommand="DELETE FROM [tblAccessoriesBook] WHERE [IdAccessoriesBook] = @original_IdAccessoriesBook AND [IdAccessories] = @original_IdAccessories AND [IsAttribution] = @original_IsAttribution AND [IsReturn] = @original_IsReturn AND (([ReturnDate] = @original_ReturnDate) OR ([ReturnDate] IS NULL AND @original_ReturnDate IS NULL)) AND [UserID] = @original_UserID AND [FirstName] = @original_FirstName AND [LastName] = @original_LastName AND [IdBuilding] = @original_IdBuilding AND (([Comment] = @original_Comment) OR ([Comment] IS NULL AND @original_Comment IS NULL)) AND (([Other] = @original_Other) OR ([Other] IS NULL AND @original_Other IS NULL)) AND [EUSID] = @original_EUSID AND (([Signature] = @original_Signature) OR ([Signature] IS NULL AND @original_Signature IS NULL))"
        InsertCommand="INSERT INTO [tblAccessoriesBook] ([IdAccessories], [IsAttribution], [IsReturn], [ReturnDate], [UserID], [FirstName], [LastName], [IdBuilding], [Comment], [Other], [EUSID], [Signature]) VALUES (@IdAccessories, @IsAttribution, @IsReturn, @ReturnDate, @UserID, @FirstName, @LastName, @IdBuilding, @Comment, @Other, @EUSID, @Signature)"
        OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT tblAccessoriesBook.ReturnDate, tblAccessoriesBook.UserID, tblAccessoriesBook.FirstName, tblAccessoriesBook.LastName, tblBuilding.BuildingName, tblAccessoriesBook.IdBuilding, tblAccessories.AccessoriesName, tblAccessoriesBook.IdAccessoriesBook, tblAccessoriesBook.IsAttribution, tblAccessoriesBook.IsReturn, tblAccessoriesBook.Other FROM tblAccessoriesBook INNER JOIN tblBuilding ON tblAccessoriesBook.IdBuilding = tblBuilding.IdBuilding INNER JOIN tblAccessories ON tblAccessoriesBook.IdAccessories = tblAccessories.IdAccessories WHERE (tblAccessoriesBook.IsAttribution = @IsAttrib) AND (tblAccessoriesBook.IsReturn = @IsReturn) AND (tblBuilding.IdCountry = @IdCountry)"
        UpdateCommand="UPDATE [tblAccessoriesBook] SET [IdAccessories] = @IdAccessories, [IsAttribution] = @IsAttribution, [IsReturn] = @IsReturn, [ReturnDate] = @ReturnDate, [UserID] = @UserID, [FirstName] = @FirstName, [LastName] = @LastName, [IdBuilding] = @IdBuilding, [Comment] = @Comment, [Other] = @Other, [EUSID] = @EUSID, [Signature] = @Signature, [PONumber] = @PONumber WHERE [IdAccessoriesBook] = @IdAccessoriesBook">
        <FilterParameters>
            <asp:ControlParameter ControlID="ddlBuilding" ConvertEmptyStringToNull="False" Name="idBuilding"
                PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="tbUserSearch" ConvertEmptyStringToNull="False" PropertyName="Text" />
            <asp:ControlParameter ControlID="ddlAccessories" ConvertEmptyStringToNull="False"
                Name="idAccessories" PropertyName="SelectedValue" />
        </FilterParameters>
        <DeleteParameters>
            <asp:Parameter Name="original_IdAccessoriesBook" Type="Int32" />
            <asp:Parameter Name="original_IdAccessories" Type="Int32" />
            <asp:Parameter Name="original_IsAttribution" Type="Boolean" />
            <asp:Parameter Name="original_IsReturn" Type="Boolean" />
            <asp:Parameter Name="original_ReturnDate" Type="DateTime" />
            <asp:Parameter Name="original_UserID" Type="String" />
            <asp:Parameter Name="original_FirstName" Type="String" />
            <asp:Parameter Name="original_LastName" Type="String" />
            <asp:Parameter Name="original_IdBuilding" Type="Int32" />
            <asp:Parameter Name="original_Comment" Type="String" />
            <asp:Parameter Name="original_Other" Type="String" />
            <asp:Parameter Name="original_EUSID" Type="String" />
            <asp:Parameter Name="original_Signature" Type="String" />
        </DeleteParameters>
        <InsertParameters>
            <asp:Parameter Name="IdAccessories" Type="Int32" />
            <asp:Parameter Name="IsAttribution" Type="Boolean" />
            <asp:Parameter Name="IsReturn" Type="Boolean" />
            <asp:Parameter Name="ReturnDate" Type="DateTime" />
            <asp:Parameter Name="UserID" Type="String" />
            <asp:Parameter Name="FirstName" Type="String" />
            <asp:Parameter Name="LastName" Type="String" />
            <asp:Parameter Name="IdBuilding" Type="Int32" />
            <asp:Parameter Name="Comment" Type="String" />
            <asp:Parameter Name="Other" Type="String" />
            <asp:Parameter Name="EUSID" Type="String" />
            <asp:Parameter Name="Signature" Type="String" />
        </InsertParameters>
        <SelectParameters>
            <asp:ControlParameter ControlID="ddlIsAttrib" Name="IsAttrib" PropertyName="SelectedValue" />
            <asp:ControlParameter ControlID="ddlIsReturn" Name="IsReturn" PropertyName="SelectedValue" />
            <asp:Parameter Name="IdCountry" DefaultValue="Session(&quot;IdCountry&quot;)" />
        </SelectParameters>
        <UpdateParameters>
            <asp:Parameter Name="IdAccessories" Type="Int32" />
            <asp:Parameter Name="IsAttribution" Type="Boolean" />
            <asp:Parameter Name="IsReturn" Type="Boolean" />
            <asp:Parameter DbType="Date" Name="ReturnDate" />
            <asp:Parameter Name="UserID" Type="String" />
            <asp:Parameter Name="FirstName" Type="String" />
            <asp:Parameter Name="LastName" Type="String" />
            <asp:Parameter Name="IdBuilding" Type="Int32" />
            <asp:Parameter Name="Comment" Type="String" />
            <asp:Parameter Name="Other" Type="String" />
            <asp:Parameter Name="EUSID" Type="String" />
            <asp:Parameter Name="Signature" Type="String" />
            <asp:Parameter Name="PONumber" Type="String" />
            <asp:Parameter Name="IdAccessoriesBook" Type="Int32" />
        </UpdateParameters>
    </asp:SqlDataSource>

Dans le code behind au moment du databound, je rajoute un event onclik pour selectionner une ligne :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
Protected Sub gvUserBooking_RowDataBound(sender As Object, e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvUserBooking.RowDataBound
        If (e.Row.RowType = ListItemType.Item Or e.Row.RowType = ListItemType.AlternatingItem) And e.Row.RowState.HasFlag(DataControlRowState.Edit) = False Then
            e.Row.Attributes.Add("onmouseover", "this.style.backgroundColor='#EAEAEA'")
            e.Row.Attributes.Add("onclick", Page.ClientScript.GetPostBackEventReference(sender, "Edit$" & e.Row.RowIndex.ToString))
            'lavender
            If e.Row.RowType = ListItemType.Item Then
                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFF'")
 
            Else
                e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor='#FFF'")
            End If
        End If
    End Sub

La ligne se sélectionne bien en mode Edit, mais lorsque je modifie une valeur dans une des textbox de ma ligne et que je clique sur le bouton associé à la commande Update, rien ne se passe, mon gridview se rafraîchi mais sans avoir mis a jour quoi que se soit.

Je ne comprend pas pourquoi, quelqu'un voit-il mon erreur ?
Merci d'avance de votre aide.

Cordialement.

DeWars