Bonjour,
Ma procédure fonctionne bien depuis SQL Server mais impossible de lui passer les reponses depuis le formulaire .net.
Je patauge un peu.
---- Procedure SQL Server ---
ALTER
PROCEDURE [dbo]
.[sp_update_IHM_BugTrack]
-- Add the parameters for the stored procedure here@BUGID
int,@Assignation
nvarchar(50
),@Status
nvarchar(50
),@Priorité
numeric,@ID_Detail
int,@ID_Appli
int,@Sujet
nvarchar(100
),@Détail
nvarchar(max),@NotifyList
nvarchar(max)AS
BEGIN
SET
NOCOUNT
ON;-- Requêtes
-- Mise à jour de la table IHM_BugTrack
UPDATE
IHM_BugTrack
SET
D_Modif
=
getdate(),Assignation
= @Assignation
,Status
= @Status
,Priorité
= @Priorité
,ID_Appli
= @ID_Appli
WHERE
(BUGID
= @BUGID
);-- Mise à jour de la table IHM_BugTrack_Detail
UPDATE
IHM_BugTrack_Detail
SET
Sujet
= @Sujet
,Détail
= @Détail
,NotifyList
= @NotifyList
WHERE
(UID_Detail
= @ID_Detail
);END
---- et le Formulaire .net ---
<asp:FormView
ID="FormView1"
runat="server"
DataKeyNames="BUGID,UID_Detail,UID_Appli"
DataSourceID="Sql_selectwherebugid"
Width="250px">
<EditItemTemplate>BUGID :
<asp:Label
ID="BUGID"
runat="server"
Text='<%# Eval("BUGID") %>
'></asp:Label><br
/>ID_Detail :
<asp:Label
ID="ID_Detail"
runat="server"
Text='<%# Bind("ID_Detail") %>
'></asp:Label><br
/>UID_Detail :
<asp:Label
ID="UID_Detail"
runat="server"
Text='<%# Eval("UID_Detail") %>
'></asp:Label><br
/>
<br
/>Assignation :
<asp:TextBox
ID="Assignation"
runat="server"
Text='<%# Bind("Assignation") %>
'></asp:TextBox><br
/>Status :
<asp:TextBox
ID="Status"
runat="server"
Text='<%# Bind("Status") %>
'></asp:TextBox><br
/>Priorit‚ :
<asp:TextBox
ID="Priorit‚"
runat="server"
Text='<%# Bind("Priorit‚") %>
'></asp:TextBox><br
/>Sujet :
<asp:TextBox
ID="Sujet"
runat="server"
Text='<%# Bind("Sujet") %>
'></asp:TextBox><br
/>D‚tail :
<asp:TextBox
ID="D‚tail"
runat="server"
Text='<%# Bind("D‚tail") %>
'></asp:TextBox><br
/>
<br
/>D_Enregistrement :
<asp:Label
ID="D_Enregistrement"
runat="server"
Text='<%# Bind("D_Enregistrement") %>
'
></asp:Label><br
/>NotifyList :
<asp:TextBox
ID="NotifyList"
runat="server"
Text='<%# Bind("NotifyList") %>
'></asp:TextBox><br
/>
<br
/>ID_Appli :
<asp:Label
ID="ID_Appli"
runat="server"
Text='<%# Bind("ID_Appli") %>
'></asp:Label><br
/>UID_Appli :
<asp:Label
ID="UID_Appli"
runat="server"
Text='<%# Eval("UID_Appli") %>
'></asp:Label><br
/>Appli :
<asp:DropDownList
ID="DropDownList1"
runat="server"
DataSourceID="Sql_AllAppli"
DataTextField="Appli"
DataValueField="UID_Appli">
</asp:DropDownList><br
/>
<asp:LinkButton
ID="UpdateButton"
runat="server"
CausesValidation="True"
CommandName="Update"
Text="Mettre … jour"></asp:LinkButton>
</EditItemTemplate>
------ et la DataSource ----
<asp:SqlDataSource
ID="Sql_selectwherebugid"
runat="server"
ConnectionString="<%$ ConnectionStrings:SIDBConnectionString1 %>
"
SelectCommand="sp_selectwherebugid_IHM_BugTrack"
SelectCommandType="StoredProcedure"
UpdateCommand="sp_update_IHM_BugTrack"
UpdateCommandType="StoredProcedure">
<UpdateParameters>
<asp:ControlParameter
ControlID="GridView1"
Name="BUGID"
PropertyName="SelectedValue"
Type="Int32"
/>
<asp:FormParameter
FormField="Assignation"
Name="Assignation"
Type="String"
/>
<asp:FormParameter
FormField="Status"
Name="Status"
Type="String"
/>
<asp:FormParameter
FormField="Priorité"
Name="Priorité"
Type="Decimal"
/>
<asp:FormParameter
FormField="ID_Detail"
Name="ID_Detail"
Type="Int32"
/>
<asp:ControlParameter
ControlID="DropDownList1"
Name="ID_Appli"
PropertyName="SelectedValue"
Type="Int32"
/>
<asp:FormParameter
FormField="Sujet"
Name="Sujet"
Type="String"
/>
<asp:FormParameter
FormField="détail"
Name="Détail"
Type="String"
/>
<asp:FormParameter
FormField="NotifyList"
Name="NotifyList"
Type="String"
/>
<asp:Parameter
Direction="ReturnValue"
Name="RETURN_VALUE"
Type="Int32"
/>
</UpdateParameters>
</asp:SqlDataSource>
Merci pour vos conseils.
Afficher la suite