View Incident Report

Minor

Reported By: James Relyea
Reported On: 3/8/2009
For: Version 2.02 Build 8

# 2946 Visual Studio TableAdapter Designer Not Working Properly with Procedures Containing Parameters

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.

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" );

}

Comments and Workarounds

The issue was that Visual Studio does not expect the ElevateDB .NET Data Provider to auto-populate the parameters after preparing the stored procedure, which is what it does. The ElevateDB .NET Data Provider has been changed to cope with this and only populate the parameters if they are missing or unknown.

Resolution

Fixed Problem on 3/9/2009 in version 2.02 build 9

Products Affected

ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap