Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DataSet readonly from a stored procedure
Message
 
À
20/11/2010 08:19:35
Timothy Bryan
Sharpline Consultants
Conroe, Texas, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
ADO.NET
Versions des environnements
Environment:
C# 4.0
Database:
MS SQL Server
Divers
Thread ID:
01489891
Message ID:
01490071
Vues:
70
Tim,

Check the stored procedure to see if you are using a column name that is being returned using the 'AS' clause. For example,

Select col1, isnull(col2, ' ') as col2 from ....

HTH
>Hi all,
>
>We have two different stored procedures to retrieve data into datasets. The way the selection criteria differs but other than this the data retrieved is identical for tables, columns and such. One of the stored procedures when we fill a DataSet is readonly and the other is read/write. I was under the impression that all DataSet's were read/write by default. Any idea if there is something in the framework that determines to make a DataSet readonly? Is there a way around this?
>Thanks
>Tim
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform