public void ProcessDataTable(DataTable dt) { foreach (DataRow row in dt.Rows) { for (int i = 0; i < row.ItemArray.Length; i++) { if (row[i] != null && row[i] is string && row[i] != System.DBNull.Value && row[i].ToString() != "") { row[i] = EncodIngHelper.ConvertISOToCP936(row[i].ToString()); } } } }
public void ProcessOutputCommand(IDbCommand command) { if (command == null) { return; } foreach (IDbDataParameter parameter in command.Parameters) { if (parameter.Value != DBNull.Value && parameter.Value is string && (parameter.Direction == ParameterDirection.Output || parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.ReturnValue)) { parameter.Value = EncodIngHelper.ConvertISOToCP936(parameter.Value as string); } } }