Example #1
0
        // public DatabaseHandler(string p_connectionString) { if (!string.IsNullOrEmpty(p_connectionString.Trim())) connectionString = p_connectionString; }
        #endregion

        #region AddParameter Methods
        private void AddParameter(SqlCommand command, string parameterName, SqlDbType dbType, int size, ParameterDirection direction,
                                  byte precision, byte scale, string sourceColumn, System.Data.DataRowVersion sourceVersion, object value)
        {
            SqlParameter p = new SqlParameter(parameterName, dbType, size, direction, precision, scale, sourceColumn,
                                              sourceVersion, true, value, null, null, null);

            command.Parameters.Add(p);
        }
Example #2
0
        private SqlParameter CreateSqlParameter(string parameterName,
                                                SqlDbType dataType, int size,
                                                string srcColumn, System.Data.ParameterDirection direction,
                                                System.Data.DataRowVersion srcVersion)
        {
            SqlParameter myParameter = new SqlParameter();

            myParameter.ParameterName = parameterName;
            myParameter.SqlDbType     = dataType;
            myParameter.Size          = size;
            myParameter.SourceColumn  = srcColumn;
            myParameter.Direction     = direction;
            myParameter.SourceVersion = srcVersion;

            return(myParameter);
        }
Example #3
0
 /// <summary>
 /// See <see cref="IProvider">IProvider interface</see>.
 /// </summary>
 public abstract IDataParameter AddParameter(System.Data.IDbCommand command, string parameterName, object dbType, int size, System.Data.ParameterDirection dir, bool isNullable, byte precision, byte scale, string srcColumn, System.Data.DataRowVersion srcVersion, object value);
Example #4
0
 public long GetIDFromDataRow(System.Data.DataRow dr, System.Data.DataRowVersion rowState)
 {
     return(Convert.ToInt64(dr["MPAItemID", rowState].ToString()));
 }