Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DataSet readonly from a stored procedure
Message
 
To
20/11/2010 08:19:35
Timothy Bryan
Sharpline Consultants
Conroe, Texas, United States
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
Environment:
C# 4.0
Database:
MS SQL Server
Miscellaneous
Thread ID:
01489891
Message ID:
01490071
Views:
68
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
Previous
Reply
Map
View

Click here to load this message in the networking platform