trouble executing SP, SqlDbType.Bit.. .

[Jeff]

ASP.NET 2.0

This stored procedure fails because the variable type contains a number.
I've debugged the SP in VS2005 and it works if I change the 0/1 value of
type to true/false... How should I fix this?? I cannot just replace type
with the phrase "false" or "true"... maybe using SqlDbType.Bit is wrong

This is header of this SP:
ALTER PROCEDURE dbo.DeleteMessa ge @id uniqueidentifie r, @user int, @type
bit

Here is the ASP.NET code
public override void DeleteMessage(S ystem.Guid id, int user, Boolean type)
{
using (SqlConnection cn = new SqlConnection(t his.ConnectionS tring))
{
SqlCommand cmd = new SqlCommand("Sen dMessage", cn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add("@id", SqlDbType.Uniqu eIdentifier).Va lue = id;
cmd.Parameters. Add("@user", SqlDbType.Int). Value = user;
cmd.Parameters. Add("@type", SqlDbType.Bit). Value = type;
}
}

any suggetions?

Jeff

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

It says boolean, so you need to pass true (with no quotation marks) or false
-- for the value.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net


"Jeff" wrote:

ASP.NET 2.0

This stored procedure fails because the variable type contains a number.
I've debugged the SP in VS2005 and it works if I change the 0/1 value of
type to true/false... How should I fix this?? I cannot just replace type
with the phrase "false" or "true"... maybe using SqlDbType.Bit is wrong

This is header of this SP:
ALTER PROCEDURE dbo.DeleteMessa ge @id uniqueidentifie r, @user int, @type
bit

Here is the ASP.NET code
public override void DeleteMessage(S ystem.Guid id, int user, Boolean type)
{
using (SqlConnection cn = new SqlConnection(t his.ConnectionS tring))
{
SqlCommand cmd = new SqlCommand("Sen dMessage", cn);
cmd.CommandType = CommandType.Sto redProcedure;
cmd.Parameters. Add("@id", SqlDbType.Uniqu eIdentifier).Va lue = id;
cmd.Parameters. Add("@user", SqlDbType.Int). Value = user;
cmd.Parameters. Add("@type", SqlDbType.Bit). Value = type;
}
}

any suggetions?

Jeff