Annadrill
Messages postés
149
Date d'inscription
mercredi 9 mai 2007
Statut
Membre
Dernière intervention
22 novembre 2012
28 sept. 2008 à 20:10
Re bonjour,
bon jai un souci
jai ce code dans un fichier SculptureDataHelper.vb
Public
Sub
InsertSculpture(
ByVal
Sculpture
As
SDMSLibrary.Objects.Sculpture)
Me
.SqlHelper.ExecuteNonQuery(Data.CommandType.StoredProcedure, _
"Sculpture_INSERT"
, _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_SculptureId"
, Sculpture.SculptureId), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_Titre"
, Sculpture.Titre), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_Matiere"
, Sculpture.Matiere), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_Prix"
, Sculpture.Prix), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_Photo"
, Sculpture.Photo), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_Description"
, Sculpture.Description), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_Poeme"
, Sculpture.Poeme), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_Taille"
, Sculpture.Taille), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_QuantMA"
, Sculpture.QuantMA), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_QuantMB"
, Sculpture.QuantMB), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_VenduMA"
, Sculpture.VenduMA), _
New
System.Data.SqlClient.SqlParameter(
"@Sculpture_VenduMB"
, Sculpture.VenduMB))
End
Sub
Puis une procédure stockée comme ceci :
ALTER PROCEDURE
[dbo].[Sculpture_INSERT]
@Sculpture_SculptureId
INT,
@Sculpture_Titre
NCHAR(20),
@Sculpture_Matiere
NCHAR(20),
@Sculpture_Prix
NUMERIC(18, 2),
@Sculpture_Photo
VARCHAR(255),
@SCulpture_Description
VARCHAR(500),
@Sculpture_Poeme
VARCHAR(500),
@Sculpture_Taille
NCHAR(20),
@Sculpture_QuantMA
NUMERIC(18, 0),
@Sculpture_QuantMB
NUMERIC(18, 0),
@Sculpture_VenduMA
NUMERIC(18, 0),
@Sculpture_VenduMB
NUMERIC(18, 0)
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO [Sculpture] (
[Sculpture_SculptureId],
[Sculpture_Titre],
[Sculpture_Matiere],
[Sculpture_Prix],
[Sculpture_Photo],
[Sculpture_Description],
[Sculpture_Poeme],
[Sculpture_Taille],
[Sculpture_QuantMA],
[Sculpture_QuantMB],
[Sculpture_VenduMA],
[Sculpture_VenduMB])
VALUES (
@Sculpture_SculptureId,
@Sculpture_Titre,
@Sculpture_Matiere,
@Sculpture_Prix,
@Sculpture_Photo,
@Sculpture_Description,
@Sculpture_Poeme,
@Sculpture_Taille,
@Sculpture_QuantMA,
@Sculpture_QuantMB,
@Sculpture_VenduMA,
@Sculpture_VenduMB)
END
ca ca marche, mais le problème c'est que c le seul qui marche
si je fais ceci :
Public
Sub UpdateSculpture(
ByVal Sculpture
As SDMSLibrary.Objects.Sculpture)
Me.SqlHelper.ExecuteNonQuery(Data.CommandType.StoredProcedure, _
"Sculpture_UPDATE", _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_SculptureId", Sculpture.SculptureId), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_Titre", Sculpture.Titre), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_Matiere", Sculpture.Matiere), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_Prix", Sculpture.Prix), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_Photo", Sculpture.Photo), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_Description", Sculpture.Description), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_Poeme", Sculpture.Poeme), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_Taille", Sculpture.Taille), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_QuantMA", Sculpture.QuantMA), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_QuantMB", Sculpture.QuantMB), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_VenduMA", Sculpture.VenduMA), _
New System.Data.SqlClient.SqlParameter(
"@Sculpture_VenduMB", Sculpture.VenduMB))
End
Sub
ALTER PROCEDURE
[dbo].[Sculpture_UPDATE]
@Sculpture_SculptureId
INT,
@Sculpture_Titre
NCHAR(20),
@Sculpture_Matiere
NCHAR(20),
@Sculpture_Prix
NUMERIC(18, 2),
@Sculpture_Photo
VARCHAR(255),
@SCulpture_Description
VARCHAR(500),
@Sculpture_Poeme
VARCHAR(500),
@Sculpture_Taille
NCHAR(20),
@Sculpture_QuantMA
NUMERIC(18, 0),
@Sculpture_QuantMB
NUMERIC(18, 0),
@Sculpture_VenduMA
NUMERIC(18, 0),
@Sculpture_VenduMB
NUMERIC(18, 0)
AS
BEGIN
SET NOCOUNT ON;
UPDATE [Sculpture]
SET
[Sculpture_Titre] = @Sculpture_Titre,
[Sculpture_Matiere] = @Sculpture_Matiere,
[Sculpture_Prix] = @Sculpture_Prix,
[Sculpture_Photo] = @Sculpture_Photo,
[Sculpture_Description] = @Sculpture_Description,
[Sculpture_Poeme] = @Sculpture_Poeme,
[Sculpture_Taille] = @Sculpture_Taille,
[Sculpture_QuantMA] = @Sculpture_QuantMA,
[Sculpture_QuantMB] = @Sculpture_QuantMB,
[Sculpture_VenduMA] = @Sculpture_VenduMA,
[Sculpture_VenduMB] = @Sculpture_VenduMB
WHERE
[Sculpture_SculptureId] = @Sculpture_SculptureId
END
Et bien je me retrouve avec l'erreur : Nom d'Objet ''dbo.Sculpture_UPDATE' non valide
je comprends pas, et je ne vois pas comment le résoudre
HELP please...