public void AddText(string field, string value)
{
if (!field.StartsWith("@"))
{
field = "@" + field;
}
value = SQLfunctions.SQLstr(value);
cmd.Parameters.Add(field, SqlDbType.Text).Value = value;
}
public void AddNText(string field, string value, bool FullHTML = false)
{
if (!field.StartsWith("@"))
{
field = "@" + field;
}
if (!FullHTML)
{
value = SQLfunctions.SQLstr(value);
}
cmd.Parameters.Add(field, SqlDbType.NText).Value = value;
}
public void AddVarChar(string field, string value, int maxlen = 8000)
{
if (!field.StartsWith("@"))
{
field = "@" + field;
}
value = SQLfunctions.SQLstr(value);
if (System.Convert.ToBoolean(SQLDBVersion < 2005))
{
if (maxlen > MaxVarChar)
{
maxlen = MaxVarChar;
}
value = value.Substring(0, maxlen);
cmd.Parameters.Add(field, SqlDbType.VarChar, maxlen).Value = value;
}
else
{
if (maxlen == -1)
{
cmd.Parameters.Add(field, SqlDbType.VarChar).Value = value;
}
else if (maxlen < MaxVarChar)
{
value = value.Substring(0, maxlen);
cmd.Parameters.Add(field, SqlDbType.VarChar, maxlen).Value = value;
}
else if (maxlen > MaxVarChar)
{
if (maxlen > MaxVarChar)
{
maxlen = MaxVarChar;
}
value = value.Substring(0, maxlen);
cmd.Parameters.Add(field, SqlDbType.VarChar, maxlen).Value = value;
}
else
{
// skulle ikke komme
}
}
}
