/// <summary> /// Inserv_ts a new Parameter at the given Index for the Command /// </summary> /// <param name="oCmd">The Command</param> /// <param name="iParameterIndex">The Index</param> /// <param name="sParameterName">Paramter Name</param> /// <param name="oParameterValue">Parameter Value</param> /// <param name="DbType">Parameter Type</param> public static void InsertParameter(System.Data.IDbCommand oCmd, int iParameterIndex, string sParameterName, object oParameterValue, XDbType DbType) { XrDbCommand o = (XrDbCommand)oCmd; XrDbParameter oParam = CreateParameter(sParameterName, oParameterValue, DbType, 0, System.Data.ParameterDirection.Input); o.Parameters.Insert(iParameterIndex, oParam); }
/// <summary> /// Adds a new Parameter to the Command /// </summary> /// <param name="oCmd">The Command</param> /// <param name="sParameterName">Parameter Name</param> /// <param name="oParameterValue">Parameter Value</param> /// <param name="DbType">Parameter Type</param> /// <param name="iSize">Data Size</param> /// <param name="pdDirection">Parameter Direction</param> public static void AddParameter(System.Data.IDbCommand oCmd, string sParameterName, object oParameterValue, XDbType DbType, int iSize, System.Data.ParameterDirection pdDirection) { XrDbCommand o = (XrDbCommand)oCmd; XrDbParameter oParam = CreateParameter(sParameterName, oParameterValue, DbType, iSize, pdDirection); // Replace or Add if (o.Parameters.Contains(sParameterName)) { o.Parameters[sParameterName] = oParam; } else { o.Parameters.Add(oParam); } }
protected static XrDbParameter CreateParameter(string sParameterName, object oParameterValue, XDbType DbType, int iSize, System.Data.ParameterDirection direction) { XrDbParameter oParam; if (iSize != 0) { oParam = new XrDbParameter(sParameterName, (XrDbType)DbType, iSize); } else { oParam = new XrDbParameter(sParameterName, (XrDbType)DbType); } oParam.Direction = direction; oParam.Value = oParameterValue; return(oParam); }