SQL Server Insert Problem

[NathanV]

I have created a class and stored procedure to insert records into a table.
The insert works but only the first character of the "Title" and "Body"
fields are added. I have traced up to the point of executing the sproc and
the string values are intact up to this point. Below is my code for the
SPROC and the insert method of the class:

............... ............... ............... ............... ............... ..............
Sproc
............... ............... ............... ............... ............... ..............
CREATE PROCEDURE spAddBlog
@pTitle varchar,
@pBody varchar,
@pStartdate datetime,
@pEnddate datetime,
@pActive bit
AS
INSERT INTO blog
Values (@pTitle,@pBody ,@pStartdate,@p Enddate,@pActiv e)
GO
............... ............... ............... ............... ............... ..............
Class
............... ............... ............... ............... ............... ..............
mStartdate = DateTime.Now;
mEnddate = DateTime.Now;
mActive = 1;

/* Connection Object */
SqlConnection conn = new
SqlConnection(C onfigurationSet tings.AppSettin g["connString "]);
conn.Open();

/* Command Object */
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandTex t = "spAddBlog" ;
comm.CommandTyp e = CommandType.Sto redProcedure;

SqlParameter objParam;

objParam = comm.Parameters .Add("@pTitle", SqlDbType.VarCh ar);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mTitle;

objParam = comm.Parameters .Add("@pBody",S qlDbType.VarCha r);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mBody;

objParam = comm.Parameters .Add("@pStartda te",SqlDbType.D ateTime);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mStartdate;

objParam = comm.Parameters .Add("@pEnddate ",SqlDbType.Dat eTime);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mEnddate;

objParam = comm.Parameters .Add("@pActive" ,SqlDbType.Bit) ;
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mActive;

try
{
comm.ExecuteNon Query();
comm.Dispose();
return true;
}
catch
{
return false;
}

[Hermit Dave]

you have to specify the size of varchar... if you dont specify its taken as
just a char
CREATE PROCEDURE spAddBlog
@pTitle varchar(100),
@pBody varchar(3000),
.......

also

objParam = comm.Parameters .Add("@pTitle", SqlDbType.VarCh ar, 100);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mTitle;

objParam = comm.Parameters .Add("@pBody",S qlDbType.VarCha r,3000);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mBody;
--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"NathanV" <Na*****@discus sions.microsoft .com> wrote in message
news:86******** *************** ***********@mic rosoft.com...

I have created a class and stored procedure to insert records into a table. The insert works but only the first character of the "Title" and "Body"
fields are added. I have traced up to the point of executing the sproc and the string values are intact up to this point. Below is my code for the
SPROC and the insert method of the class:

............... ............... ............... ............... ............... ..
............. Sproc:
............... ............... ............... ............... ............... ..
............. CREATE PROCEDURE spAddBlog
@pTitle varchar,
@pBody varchar,
@pStartdate datetime,
@pEnddate datetime,
@pActive bit
AS
INSERT INTO blog
Values (@pTitle,@pBody ,@pStartdate,@p Enddate,@pActiv e)
GO
............... ............... ............... ............... ............... ..
............. Class:
............... ............... ............... ............... ............... ..
............. mStartdate = DateTime.Now;
mEnddate = DateTime.Now;
mActive = 1;

/* Connection Object */
SqlConnection conn = new
SqlConnection(C onfigurationSet tings.AppSettin g["connString "]);
conn.Open();

/* Command Object */
SqlCommand comm = new SqlCommand();
comm.Connection = conn;
comm.CommandTex t = "spAddBlog" ;
comm.CommandTyp e = CommandType.Sto redProcedure;

SqlParameter objParam;

objParam = comm.Parameters .Add("@pTitle", SqlDbType.VarCh ar);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mTitle;

objParam = comm.Parameters .Add("@pBody",S qlDbType.VarCha r);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mBody;

objParam = comm.Parameters .Add("@pStartda te",SqlDbType.D ateTime);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mStartdate;

objParam = comm.Parameters .Add("@pEnddate ",SqlDbType.Dat eTime);
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mEnddate;

objParam = comm.Parameters .Add("@pActive" ,SqlDbType.Bit) ;
objParam.Direct ion = ParameterDirect ion.Input;
objParam.Value = mActive;

try
{
comm.ExecuteNon Query();
comm.Dispose();
return true;
}
catch
{
return false;
}