Firm Members
 

Firm Members

GWSCPA Firm Members are CPA firms who have chosen to ensure that each of their professional staff is a member of the Greater Washington Society of CPAs.

To find out more about Firm/Organizational Membership, contact us.

CPA Firm Members

System.Exception: System.Data.SqlClient.SqlException: Invalid object name 'dc_dbam4sql.dbo.firms'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 270 select rtrim(firm) as [id], rtrim(rtrim(fname1) + ' ' + rtrim(fname2)) as [name] from dc_dbam4sql.dbo.firms f where f.pd='Y' and f.sb in ('03','02','01','00') order by [name] asc at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 282 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

Financial Services Members

System.Exception: System.Data.SqlClient.SqlException: Invalid object name 'dc_dbam4sql.dbo.firms'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 270 select rtrim(firm) as [id], rtrim(rtrim(fname1) + ' ' + rtrim(fname2)) as [name] from dc_dbam4sql.dbo.firms f where f.pd='Y' and f.sb IN ('SS','BS') order by [name] asc at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 282 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

Nonprofit Members

System.Exception: System.Data.SqlClient.SqlException: Invalid object name 'dc_dbam4sql.dbo.firms'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 270 select rtrim(firm) as [id], rtrim(rtrim(fname1) + ' ' + rtrim(fname2)) as [name] from dc_dbam4sql.dbo.firms f where f.pd='Y' and f.sb='NP' order by [name] asc at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 282 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210

Full Listing

System.Exception: System.Data.SqlClient.SqlException: Invalid object name 'dc_dbam4sql.dbo.firms'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 270 select case rtrim(piclink) when '' then '' else '
Contact ' + (select top 1 rtrim(n.fname) + ' ' + rtrim(n.lname) from DC_DBAM4SQL.dbo.names n WITH (NOLOCK) where n.[id]=piclink) +'
' end as [contact], rtrim(firm) as [id], rtrim(rtrim(fname1) + ' ' + rtrim(fname2)) as [name], rtrim(faddr1) + case rtrim(faddr2) when '' then '' else ', ' + rtrim(faddr2) end + ', ' + rtrim(fcity) + ', ' + fst + ', ' + rtrim(fzip) as [address], rtrim(fphone) as [phone], case rtrim(fletcon) when '' then '' else '' end as [email], case rtrim(website) when '' then '' else '' end as [website], case [ud1] when '' then '' else 'more info »
'+[ud1]+'

' end as [content] from dc_dbam4sql.dbo.firms f where f.pd='Y' order by [name] asc at ProjectL.Data.SQL.Exec.AdapterDataSet(String connection, String text) in C:\Code\Bryce\SocietySolution\ProjectL\ProjectL.Data\Data\SQL\Exec.cs:line 282 at BryceWebGroup.CMS.Plugin.Panel.QueryList.Shell.Controls.NodeRender.RefreshList() in C:\Code\Bryce\SocietySolution\CMS\BryceWebGroup.CMS.Common.Plugin\Common\QueryList\Shell\NodeRender.ascx.cs:line 210