Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Retrieving SQL Data with a Stored Procedure
Message
De
03/03/2006 11:18:54
Jason Mesches
Ocean Systems Engineering Corporation
Carlsbad, Californie, États-Unis
 
 
À
02/03/2006 21:47:29
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
C# 2.0
OS:
Windows XP SP2
Database:
MS SQL Server
Divers
Thread ID:
01101144
Message ID:
01101272
Vues:
11
Hello James,

Could you post the error stack trace? That should help determine where/what the problem is.

Thanks,
---J

>Hi All,
>
>
>I'm having trouble doing what should be really simple.
>
>I have a table in SQL that has a list of Glass types "Glass". I have a stored procedure that returns the entire list of glasses, "Glass_SelAllProc".
>
>I'm trying to build a business objec that will retrieve the Glass data. I create a business object class derived from ABusinessObject. I set the TableName and PrimaryKey in the constructor. I have another method TestIt with the following code:
>
>
>DataSet ds = null;
>ds = this.GetDataSet("Glass_SelAllProc",System.Data.CommandType.StoredProcedure);
>return ds;
>
>
>I create the object in the Object Test Bench and invoke the method TestIt(). On the line calling te GetDataSet method I get an erro saying "Method Invoke Failed".
>
>Under Details it says:
>
>An unhandled exception of type 'System.NullReferenceException' occurred in Mere Mortals Framework 2005.dll
>
>Additional information: Object reference not set to an instance of an object.
>
>
>Any ideas?
>
>Aloha,
>
>James
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform