System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Exception: Select name from ProductManufacturers where id = Generac ---> System.Data.SqlClient.SqlException: Invalid column name 'Generac'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) at WebApp.Recordset.Refresh() in O:\WebApp\Recordset.cs:line 123 --- End of inner exception stack trace --- at WebApp.Recordset.Refresh() in O:\WebApp\Recordset.cs:line 139 at WebApp.Recordset..ctor(String dsn, String sql) in O:\WebApp\Recordset.cs:line 41 at WebApp.App.Select(String sql) in O:\WebApp\App.cs:line 769 at PERC.ProductSearch.GetSQL(String& manufacturer) in \\mndev01\E\www\HWMDEVSITE\buildwithpropane\ProductDirectory\ProductSearch.cs:line 56 at PERC.ProductSearch.GetProducts(Int32 min, Int32& iTotal, Int32& iOffset, String& manufacturer) in \\mndev01\E\www\HWMDEVSITE\buildwithpropane\ProductDirectory\ProductSearch.cs:line 97 at PERC.ProductSearch.WriteProducts(Boolean bCalcLink, String& manufacturer) in \\mndev01\E\www\HWMDEVSITE\buildwithpropane\ProductDirectory\ProductSearch.cs:line 152 at PERC.ProductSearch.OnPaint() in \\mndev01\E\www\HWMDEVSITE\buildwithpropane\ProductDirectory\ProductSearch.cs:line 31 --- End of inner exception stack trace --- at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) at WebApp.Invoker.InvokeHelper(Object that, String name, Object[] args) in O:\WebApp\Invoker.cs:line 82 at WebApp.Invoker.Write(App that, String str) in O:\WebApp\Invoker.cs:line 53