Paramètre d'un SqlDataSource ignoré
Bonjour à tous,
J'ai un petit problème suivant l'update d'une ligne dans une Grid : un paramètre est complètement ignoré (type Double). Voici le code pour vous égayer :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
<asp:SqlDataSource ID="dsDirectCosts" runat="server" ConnectionString="<%$ ConnectionStrings:MISSqlConnectionString %>"
SelectCommand="SELECT * FROM [DirectCosts] ORDER BY id DESC" DeleteCommand="DELETE FROM [DirectCosts] WHERE [id] = @id"
UpdateCommand="UPDATE [DirectCosts] SET [categoryName] = @categoryname, [amount] = @amount, [InvoiceNo] = @invoiceno, [Remarque] = @remarque, [invoicemonth] = @invoicemonth, [invoiceyear] = @invoiceyear WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter DbType="Int32" Name="id" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter DbType="String" Name="categoryname" />
<asp:Parameter DbType="Double" Name="amount" />
<asp:Parameter DbType="String" Name="invoiceno" />
<asp:Parameter DbType="String" Name="remarque" />
<asp:Parameter DbType="Int32" Name="invoicemonth" />
<asp:Parameter DbType="Int32" Name="invoiceyear" />
<asp:Parameter DbType="Int32" Name="id" />
</UpdateParameters>
</asp:SqlDataSource> |
Et voici le Control dans lequel la valeur peut être changée :
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
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
|
<EditFormSettings EditFormType="Template">
<FormTemplate>
<table>
<tr>
<td>
Category name :
</td>
<td>
<telerik:RadComboBox ID="ddlCategories2" runat="server" DataSourceID="dsDirectCostCategories"
DataTextField="name" DataValueField="guid" Text="<%# Bind('categoryName') %>">
<CollapseAnimation Duration="200" Type="OutQuint" />
</telerik:RadComboBox>
</td>
</tr>
<tr>
<td>
Amount :
</td>
<td>
<telerik:RadTextBox ID="txtbAmount2" runat="server" AutoCompleteType="None" Text="<%# Bind('amount') %>"
Width="155">
</telerik:RadTextBox>
</td>
</tr>
<tr>
<td>
Invoice number :
</td>
<td>
<telerik:RadTextBox ID="txtbInvoiceNumber2" runat="server" AutoCompleteType="None"
Text="<%# Bind('InvoiceNo') %>" Width="155">
</telerik:RadTextBox>
<asp:RequiredFieldValidator ID="RFVInvoiceNumber2" runat="server" ControlToValidate="txtbInvoiceNumber2"
Display="Dynamic" ErrorMessage="Invoice number not entered" SetFocusOnError="True"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td>
Information :
</td>
<td>
<telerik:RadTextBox ID="txtbInformation2" runat="server" AutoCompleteType="None"
Text="<%# Bind('Remarque') %>" Width="155">
</telerik:RadTextBox>
</td>
</tr>
<tr>
<td>
Invoice month :
</td>
<td>
<telerik:RadTextBox ID="txtbInvoiceMonth2" runat="server" AutoCompleteType="None"
Text="<%# Bind('invoicemonth') %>" Width="155">
</telerik:RadTextBox>
</td>
</tr>
<tr>
<td>
Invoice year :
</td>
<td>
<telerik:RadTextBox ID="txtbInvoiceYear2" runat="server" AutoCompleteType="None"
Text="<%# Bind('invoiceyear') %>" Width="155">
</telerik:RadTextBox>
</td>
</tr>
<tr>
<td>
<telerik:RadButton ID="btnUpdate" runat="server" CommandName="Update" OnClientClicking="CheckDuplicateNumber"
Text="Update">
</telerik:RadButton>
<telerik:RadButton ID="btnCancel" runat="server" CausesValidation="false" CommandName="Cancel"
Text="Cancel">
</telerik:RadButton>
</td>
</tr>
</table>
</FormTemplate>
</EditFormSettings> |
Comme vous le voyez, j'utilise un template personnalisé pour la modification d'une ligne. Peut-être que le type Double pose problème... (le field est de type Float dans la table).
Merci d'avance de votre aide.
