DeriveParameters throws NullReferenceException

Hi,


I am coding under .Net compact framework and using
System.Data.SqlClient connect to MS SQL server through PDA USB cradle.
I can execute stored procedures and sql select or updates statements.
But I always get NullreferenceException when I try to use
DeriveParameters function of SQLCommand to get parameters of my stored
procedure? Any idea?
I tried the same function under .Net framework, it works fine.

I am using SQLHelper the function is
DiscoverSpParameterSet(SqlConnection connection, string spName, bool
includeReturnValueParameter)

And I got exception on this line

SqlCommandBuilder.DeriveParameters(cmd);

Anybody has experienced this before. Is it a bug for .NET CF(cannot use
DeriveParameters function)? Do I have to explicit assign those
parameters for my stored procedures (that would be a painful coding)

thanks in advance
-rockdale

.

Relevant Pages

  • DeriveParameters throws NummReferenceException
    ... I am coding under .Net compact framework and using ... System.Data.SqlClient connect to MS SQL server through PDA USB cradle. ... I can execute stored procedures and sql select or updates statements. ... DeriveParameters function)? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DeriveParameters throws NummReferenceException
    ... System.Data.SqlClient connect to MS SQL server through PDA USB cradle. ... I can execute stored procedures and sql select or updates statements. ... DeriveParameters function of SQLCommand to get parameters of my stored ... DeriveParameters function)? ...
    (microsoft.public.dotnet.framework.adonet)
  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Securing Stored Procedures from being seen
    ... username, but in SQL Server, there are too many users to map an individuals ... granting the group execute permissions. ... but I would have to know what groups the user belongs ... see the names of any stored procedures to which he has no rights. ...
    (microsoft.public.sqlserver.security)
  • Re: Querying on dates in dd/mm/yyyy hh/mm/ss format using Access2002 And SQL Server 7
    ... For parsing a string to a date/time, the 103 format doesn't limits the user ... > which is used as the row source for the results form). ... > other solutions assuming I have to use SQL Server 7? ... > I don't understand how I can use parameterized stored procedures to solve ...
    (microsoft.public.access.adp.sqlserver)