Database

using (var command = new SqlCommand("", connection))
{
    var query = new StringBuilder();
    ...
    query.Append(" SELECT e581_key, 'e581', 'rnlt', rnlt, @rnlt, 'SaveEditRNLT', @logUserName, getdate() ");
    query.Append(" FROM e581 ");
    command.Parameters.AddWithValue("@rnlt", _rnlt);
    command.Parameters.AddWithValue("@logUserName", _logUserName);
    ...
    command.CommandText = query.ToString();
    ...
}

query.Append("SELECT e581_key, 'e581', 'pickup_date', pickup_date , '" + _dateMaterialRequired + "' , 'SaveEditPickup', '" + _logUserName + "', getdate() ");

<pre>

Now _dateMaterialRequired and _timeMaterialRequired are variables, properties, that belong to the to the class that called the hard coded SQL statement. When the SQL is called how are the select statement return values assigned to the variables, properties, that are in the calling code?

holdorf wrote:

how are the select statement return values assigned to the variables, properties, that are in the calling code?

holdorf wrote:

But these values are being filled in by the Where clause.

DBCC SHRINKFILE('your-log-file', 200) -- for 200 MB