quote:

---

Originally posted by imaraz

Hi everyone, I have created a general stored procedure that takes two parameters one as Table name and the other as Field name to be able to use it for several tables with same data structure.
-----------------------------------------------------

USE [Users]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[spInsertIntoModList]

@TableName nvarchar(64),
@Name nvarchar(64)
AS
BEGIN

SET NOCOUNT ON;

DECLARE @cmd AS NVARCHAR(1000)
SET @cmd = N'INSERT INTO ' + @TableName + ' (Name) VALUES (''' + @Name + ''')'

EXEC (@cmd)

END

-----------------------------------------------------
I call this stored procedure using a C# code but it throws an exception of
'Could not find stored procedure 'INSERT INTO Applications (Name) VALUES ('App 11')''

(The parameters sent from C# code was 'Applications' for @TableName and 'App 11' for @Name)

C# code:

public long ExecuteSP(string pSPName, ref SqlParameterCollection pParams)
{
try
{
OpenConnection();
}
catch
{
return -1;
}

SqlParameter[] lParamArray = new SqlParameter[pParams.Count];

pParams.CopyTo(lParamArray, 0);

SqlCommand lCommand = new SqlCommand(pSPName, mConnection);

lCommand.CommandType = CommandType.StoredProcedure;

for (int i = 0; i < pParams.Count; i++)
lCommand.Parameters.AddWithValue(lParamArray[i].ParameterName.ToString(),lParamArray[i].Value.ToString());


try
{
lCommand.ExecuteNonQuery();
CloseConnection();
}
catch
{
CloseConnection();
return 0;
}
return 1;
}


Any ideas what I am doing wrong?
Thanks :)

---

quote:

---

Originally posted by imaraz


Wow it worked! Thanks a lot man..

---