Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DataSet readonly from a stored procedure
Message
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:
01490130
Vues:
61
>Hi Bonnie,
> I would say that all the columns are causing the problem. When I step through, the ReadOnly attribute is false on all columns of the DataTable (except for the Primary Key) until I hit the following code:
>
>// Fill the specified table in the DataSet
>adapter.Fill(ds, tableName);
>
>After this line runs, all the columns in the DataTable switch to ReadOnly = true (for the offending stored procedure that is)
>
>
>Don

Have you tried to not use Dynamic SQL in this SP? Someone mentioned today that dynamic SQL may cause this problem and I think it's very likely to be the cause.

(BTW, funny - I used 'cause' twice in the same sentence - once as a verb and once as a noun)
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform