ObjectDataSource Question

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Hello All,

I am coding with VS.NET 2005 and attempting to execute a somewhat
complicated sql query.

I have created a DataLayer and an objectDataSource, bound to a DetailsView;

This work no problem if I configure the datasource of the DeatilsView to
execute
'SELECT Account
FROM DistributionList
WHERE ListName = ?
AND Broker = ?


If however I attempt to execute:

SELECT Account
FROM DistributionList
WHERE ListName = ?
AND Broker = ?
AND Account Not In (SELECT Account
FROM DistributionList
WHERE ListName = ?
AND Broker = ? )

I get an error message that values were not supplied for one or more
variables. Anybody have any suggestions please?



.



Relevant Pages

  • Re: ObjectDataSource Question
    ... idea, but with the ObjectDataSource in VS.NET 2005, sometimes when I try to ... SELECT Account ... WHERE ListName = @ListName ... AND Broker = @Broker ...
    (microsoft.public.dotnet.languages.csharp)
  • ObjectDataSource Question
    ... I am coding with VS.NET 2005 and attempting to execute a somewhat ... 'SELECT Account ... WHERE ListName =? ... AND Broker =? ...
    (microsoft.public.vstudio.development)
  • ObjectDataSource Question
    ... I am coding with VS.NET 2005 and attempting to execute a somewhat ... 'SELECT Account ... WHERE ListName =? ... AND Broker =? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > I logged in as that user, tried to execute the DTS ... which then launches the DTS package using the sp_OA* procs? ... account is used during proc execution. ... > proxy account to use in the Job Systems tab of SQL Server Agent ...
    (microsoft.public.sqlserver.security)
  • Execute Process Task not failing, but not executing the batch comm
    ... I can execute the following command from the windows "Run" prompt and it ... Might I have something set weird in SQL Server? ... server being by default configured to run as localsystem account, ...
    (microsoft.public.sqlserver.dts)