I'm seeing something that looks like this as an issue with v2.02v8:

VS2008 TableAdapters are not sending parameter values to stored procedures.
In my app, I am returning 347 rows with a null string parameter. When set to
a specific value, I am getting 3 rows (as expected) when the stored proc is
ran in ElevateDB Manager.

However, when the parameter has a value in VS2008's TableAdapter(s), the
full 347 rows get returned all the time.MS SQL 2005 works perfectly.

Anyone else seeing this, and if so, were you able to find a work around?

Creating connections, params & commands manually in the data tier generates
too much code (by me) so it's really not an option. Table Adapters are
slick.

This is the table adapter code:
using ( Corps.Common.dsCorpsTableAdapters.taCorps taCorps = new
JBR.SimplyA_Z.Corps.Common.dsCorpsTableAdapters.taCorps() )

{

taCorps.Connection.ConnectionString =
SimplyA_Z.Common.Global.DBConnection.ConnectionString;

taCorps.ClearBeforeFill = true;

taCorps.ListByFullName( DS.tCorps,"cha" );

}

This is supposed to return only 3 rows like it does in ElevateDB Mgr but
always returns all of the rows.

jr

James,

<< VS2008 TableAdapters are not sending parameter values to stored
procedures. >>

I'll have to look into this, and get back to you on what I find out.

--
Tim Young
Elevate Software
www.elevatesoft.com