Hello there,
I am having problems with a stored procedure. When a use SqlCommand,
SqlParameter and the ExecuteNonQuery method, i get this error:
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'spSaveFormRequ est'.
(1 row(s) affected)
The code in the Sql Profiler generated by the ExecuteNonQuery method is
as follows:
declare @P1 varchar(36)
set @P1=NULL
exec sp_executesql N'spSaveFormReq uest',
N'@frmId varchar(36),@fr mName varchar(32),@fr mNameFra
varchar(32),@fr mXmlConfigurati onFile varchar(16),@fr mInUse bit,@catId
varchar(36),@fr mNewId varchar(36) output',
@frmId = '568a0a56-5559-4a6f-8023-89f7efea2696',
@frmName = 'Headsets replacement',
@frmNameFra = '',
@frmXmlConfigur ationFile = NULL,
@frmInUse = 1,
@catId = '063da375-f39c-402d-b6a3-5a491360c99d', @frmNewId = @P1 output
select @P1
The c# code is
conn = new SqlConnection(t his.connectionS tring);
command = new SqlCommand("spS aveFormRequest" , conn);
conn.Open();
command.Paramet ers.Add("@frmId ", SqlDbType.VarCh ar,
36).Value = frmId;
command.Paramet ers.Add("@frmNa me", SqlDbType.VarCh ar,
32).Value = frmName;
command.Paramet ers.Add("@frmNa meFra", SqlDbType.VarCh ar,
32).Value = frmNameFra;
command.Paramet ers.Add("@frmXm lConfigurationF ile",
SqlDbType.VarCh ar, 16).Value = xmlFile;
command.Paramet ers.Add("@frmIn Use", SqlDbType.Bit). Value =
frmInUse;
command.Paramet ers.Add("@catId ", SqlDbType.VarCh ar,
36).Value = catId;
SqlParameter frmNewId = new SqlParameter("@ frmNewId",
SqlDbType.VarCh ar, 36);
frmNewId.Direct ion = ParameterDirect ion.Output;
command.Paramet ers.Add(frmNewI d);
command.Execute NonQuery();
newid = command.Paramet ers["@frmNewId"].Value.ToString ();
I am not sure what I am doing wrong.
Could someone perhaps help me with the error?
I am using Sql Server 2000, Framework 2.0
thanks in advance
*** Sent via Developersdex http://www.developersdex.com ***