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 } } }