PC Review

Thread Tools Rate Thread

ReadOnly DataColumns with SQL Server 2005 but not SQL Server 2000

Posts: n/a
      13th Oct 2008
Has anyone run into this discrepancy with SQL Server 2005 and the
SqlDataTable Load method?

In SQL Server 2000, when I create a table using the SqlDataTable.Load
method passing it a SqlDataReader, I get a DataTable with DataColumns
with ReadOnly property equal to False. However, the same method in
SQL Server 2005 will
return a DataTable with DataColumns with ReadOnly property equal to
True. Changing the code
to use SqlDataAdapter.Fill method fixes the issue but does anyone
the reason for this discrepancy between SQL Server 2000 and SQL

SqlDataTable.Load(SqlDataReader) returns readonly columns in SQL
Server 2000.
SqlDataAdapter.Fill(SqlDataTable) does not return readonly columns in
SQL Server 2005.

(The SqlDataReader was created using the SqlCommand.ExecuteDataReader


Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ReadOnly DataColumns with SQL Server 2005 Nergock@gmail.com Microsoft C# .NET 0 13th Oct 2008 09:13 PM
any know issues in installing VB.NET 2005 Express, VS.NET 2005 Standard, SQL Server 2005 Express and SQL Server 2005 LeAnne Microsoft VB .NET 2 30th Dec 2005 12:27 PM
Security programs 2005 - , Firewall programs 2005 -, Antivirus programs 2005 -, APPDEV DOT NET SECURITY, Linux Security and Firewall programs 2005 -, CiscoWorks ( CW ) Security programs 2005 - , futa Microsoft Access Security 3 2nd Mar 2005 05:04 AM
McAfee 2005 All In One, McAfee AntiSpyware V1.0 2005, McAfee Personal Firewall Plus V6.0 2005, McAfee QuickClean V5.0 2005, McAfee SpamKiller V6.0 2005, McAfee VirusScan V9.0 2005, new !, other code_fu Anti-Virus 0 1st Oct 2004 11:00 PM
Textbox readonly -> but not with readonly property Milosz - [playseven.com] Microsoft Dot NET Compact Framework 3 1st Mar 2004 01:27 PM




All times are GMT +1. The time now is 10:09 PM.