Maybe padding with spaces isn't aloud for primary keys. -----Original Message----- From: Discussion of advanced .NET topics. [mailto:[EMAIL PROTECTED] On Behalf Of Franklin Gray Sent: Tuesday, October 25, 2005 11:18 AM To: [email protected] Subject: Re: [ADVANCED-DOTNET] Primary Key Bug
No....that's just another BS excuse. If XML doesn't recognize them as different then XML is wrong too. The data is different and no software tool should ever been making assumptions about the data. IT IS A BUG!!!!!!!!!!!!!! Message from Christopher Reed <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM received on 10/25/2005 09:51 AM 10/25/2005 09:51 AM Christopher Reed <[EMAIL PROTECTED]>@DISCUSS.DEVELOP.COM Please respond to "Discussion of advanced .NET topics." <[email protected]> Sent by "Discussion of advanced .NET topics." <[email protected]> To: [email protected] cc: Subject: Re: [ADVANCED-DOTNET] Primary Key Bug Let's look at this from another perspective. <?xml version="1.0" standalone="yes"?> <NewDataSet> <Table1> <Key>key1</Key> </Table1> <Table1> <Key>key1 </Key> </Table1> </NewDataSet> The above is the XML representation of your datatable (in a dataset). The point is that if you tried to make the Key element unique in the above XML, it would complain because the spacing is not relevant to an XML document. Thus, you should always view data within ADO.NET as if it was represented by a XML file. This is not a bug. This is by design of XML. Hope this helps! Christopher Reed Web Applications Supervisor Information Technology City of Lubbock [EMAIL PROTECTED] "The oxen are slow, but the earth is patient." >>> [EMAIL PROTECTED] 5:00:33 pm 10/24/2005 >>> Anybody noticed that this code errors? Is this fixed in 2.0? Module Module1 Sub Main() Dim DT As New DataTable DT.Columns.Add("Key", GetType(String)) DT.Rows.Add(New Object() {"key1"}) DT.Rows.Add(New Object() {"key1 "}) DT.PrimaryKey = New DataColumn() {DT.Columns("Key")} End Sub End Module =================================== This list is hosted by DevelopMentorR http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentorR http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
