PC Review


Reply
Thread Tools Rate Thread

ReadOnly DataColumns with SQL Server 2005 but not SQL Server 2000

 
 
Nergock@gmail.com
Guest
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
know
the reason for this discrepancy between SQL Server 2000 and SQL
Server
2005?


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
method.)


Thanks.

 
Reply With Quote
 
 
 
Reply

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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:55 AM.