Hi Joe,

Every other time, i try to insert or update anything in the database i get this message.

<img src="http://img521.imageshack.us/my.php?image=mojoportalcachedparamercr7.jpg" />

After the message, the record is stored correctly..

The types at DBHOUSE.Update()  match with my table.

MSSQL table  hm_HOUSE table design:

hou_id int
hou_title varchar(512)
hou_description text
hou_price decimal(18, 2)
hou_file varchar(256)
hot_id int
show_online bit

DBHOUSE.Update function:

public static bool Update(
int hou_id,
string hou_title,
string hou_description,
decimal hou_price,
string hou_file,
int hot_id,
bool show_online)
{
SqlParameterHelper sph = new SqlParameterHelper(GetConnectionString(), "hm_HOUSE_Update", 7);
sph.DefineSqlParameter("@hou_id", SqlDbType.Int, ParameterDirection.Input, hou_id);
sph.DefineSqlParameter("@hou_title", SqlDbType.VarChar, 512, ParameterDirection.Input, hou_title);
sph.DefineSqlParameter("@hou_description", SqlDbType.Text, ParameterDirection.Input, hou_description);
sph.DefineSqlParameter("@hou_price", SqlDbType.Decimal, ParameterDirection.Input, hou_price);
sph.DefineSqlParameter("@hou_file", SqlDbType.VarChar, 256, ParameterDirection.Input, hou_file);
sph.DefineSqlParameter("@hot_id", SqlDbType.Int, ParameterDirection.Input, hot_id);
sph.DefineSqlParameter("@show_online", SqlDbType.Bit, ParameterDirection.Input, show_online);
int rowsAffected = sph.ExecuteNonQuery();
return (rowsAffected > 0);

}

It seems quite alright to me... :) Would you have any thoughts on this one?

Thanks for looking at this one.. :)

Ii get the exact same error with another table.