Stored Procedure Troubles -- Please Help!

I have a sproc that does an insert/update into tables HS_Entity and HS_Content. When I run it from Sql Query Analyzer, it executes no problemo. When I call it from my asp.net app, using the exact same (hard-coded) parameters, I get this error:





"Object must implement IConvertible."





I understand this is normally a conversion issue, but I've checked each value a million times!








========================================================





-- ENTITY TABLE


@name nvarchar (50),


@keywords nvarchar(500),


@permissions nvarchar (12),


@isActive bit,


@createdBy nvarchar(50),


@updatedBy nvarchar(50),





-- CONTENT TABLE


@contentPk int,


@categoryPk int,


@contentTitle nvarchar(500),


@content nvarchar(2500)





as





declare @entityPk int


declare @version int


declare @updated smalldatetime


declare @created smalldatetime


set @updated = getDate()


set @created = getDate()





if @contentPk > 0


-- UPDATE ENTITY AND CONTENT: INSERTS NEW ENTITY AND CONTENT AND INCREMENTS VERSION


begin


set @entityPk = (select entityPk from HS_Content where contentPk=@contentPk)


set @version = (select version from HS_Entity where entityPk=@entityPk)-- + 1


exec HS_Entity_IU


10, --1


@version,


@name,


@keywords,


@permissions,


@isActive,


@created,


@updated





update HS_Content set


entityPk=@entityPk,


categoryPk=@categoryPk,


contentTitle=@contentTitle,


content=@content


where contentPk=@contentPk


end


else


-- INSERT ENTITY AND CONTENT: INSERTS NEW ENTITY AND CONTENT


begin


set @version = 1


exec HS_Entity_IU


10,


@version,


@name,


@keywords,


@permissions,


@isActive,


@created,


@updated


set @entityPk = (select top 1 entityPk from HS_Entity order by entityPk asc)





insert into HS_Content values


(@entityPk, @categoryPk, @contentTitle, @content)


end





==============================================











Here is a portion of the c# code:





==============================================





paramCol[i] = new SqlParameter("@name", SqlDbType.NVarChar, 50);


paramCol[i].Direction = ParameterDirection.Input;


paramCol[i++].Value = name;


paramCol[i] = new SqlParameter("@keywords", SqlDbType.NVarChar, 500);


paramCol[i].Direction = ParameterDirection.Input;


paramCol[i++].Value = keywords;


paramCol[i] = new SqlParameter("@permissions", SqlDbType.NVarChar, 12);


paramCol[i].Direction = ParameterDirection.Input;


paramCol[i++].Value = permissions.ToString();


paramCol[i] = new SqlParameter("@isActive", SqlDbType.Bit, 1);


... etc





try {


SqlHelper.ExecuteNonQuery(Global.ConnectionString, "HS_Content_IU", paramCol);


} catch (Exception ex) {


if (conn.State == ConnectionState.Open)


conn.Close();


conn.Dispose();


System.Web.HttpContext.Current.Response.Write(ex.Message);


}





==============================================





thanks for your help!


Brent