Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...
.NET Forum / .NET Framework / New Users / March 2008

Tip: Looking for answers? Try searching our database.

Deserilazation of Object with collection property Options

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
nadeem - 03 Mar 2008 07:56 GMT
I have a master class suppose Pubisher which contains UserObject as
property.
This UserObject has UserAlertsCollection.

I execute store procedure

CREATE  [dbo].[PROC_PUBLISHER_SELECT_BY_PUBLISHERID]
(
       @PublisherID    AS NUMERIC(18,0)

)
AS

SELECT


Publisher.PublisherId,
                                               Publisher.PartnerId AS
PublisherPartnerId,
                                               Publisher.UserId AS
PublisherUserId,
                                               Publisher.[Name],

Publisher.PhoneNumber,
                                               Publisher.Email,

Publisher.Description,

Publisher.IsModifyTraffickingEnabled,

Publisher.IsModifyApprovedAdsEnabled,
                                               Publisher.DateCreated
AS PublisherDateCreated,
                                               Publisher.DateModified
AS PublisherDateModified,
                                               Publisher.IsDeleted AS
PublisherIsDeleted,
                                               UserObject.UserID,
                                               UserObject.PartnerID,
                                               UserObject.UserName,
                                               --
UserObject.Password,
                                               UserObject.IsEnabled,

UserObject.DateCreated,

UserObject.DateModified,
                                               UserObject.IsDeleted,


UserAlerts.UserAlertsID ,

UserAlerts.UserAlertID ,
                                               UserAlerts.UserID  ,

UserAlerts.IsEnabled  ,

UserAlerts.DateCreated  ,

UserAlerts.DateModified  ,
                                               UserAlerts.IsDeleted

       FROM Publisher

       INNER JOIN [User] AS UserObject
                               ON UserObject.UserID=Publisher.UserID

       INNER JOIN UserAlerts AS UserAlerts
ON UserObject.UserID=UserAlerts.UserID
                               WHERE
Publisher.PublisherId=@PublisherID

FOR XML AUTO , TYPE, ELEMENTS, ROOT('ArrayOfPublisher')

Which returns xml in following pattern

<ArrayOfPublisher>
 <Publisher>
   <PublisherId>1</PublisherId>
   <PublisherPartnerId>1</PublisherPartnerId>
   <PublisherUserId>36</PublisherUserId>
   <Name>Publisher 1 Ltd</Name>
   <PhoneNumber>"100-34343"</PhoneNumber>
   <Email>"info@global_ad.com"</Email>
   <Description>"Emerging company"</Description>
   <PublisherDateCreated>2008-02-13T17:17:17.747</
PublisherDateCreated>
   <PublisherDateModified>2008-02-13T17:17:17.747</
PublisherDateModified>
   <PublisherIsDeleted>0</PublisherIsDeleted>
   <UserObject>
     <UserID>36</UserID>
     <PartnerID>1</PartnerID>
     <UserName>345</UserName>
     <IsEnabled>1</IsEnabled>
     <DateCreated>2008-02-13T17:17:17.747</DateCreated>
     <DateModified>2008-02-13T17:17:17.747</DateModified>
     <IsDeleted>0</IsDeleted>
     <UserAlerts>
       <UserAlertsID>39</UserAlertsID>
       <UserAlertID>2</UserAlertID>
       <UserID>36</UserID>
       <IsEnabled>1</IsEnabled>
       <DateCreated>2008-02-13T17:17:17.747</DateCreated>
       <DateModified>2008-02-13T17:17:17.747</DateModified>
       <IsDeleted>0</IsDeleted>
     </UserAlerts>
     <UserAlerts>
       <UserAlertsID>40</UserAlertsID>
       <UserAlertID>2</UserAlertID>
       <UserID>36</UserID>
       <IsEnabled>1</IsEnabled>
       <DateCreated>2008-02-13T17:17:17.747</DateCreated>
       <DateModified>2008-02-13T17:17:17.747</DateModified>
       <IsDeleted>0</IsDeleted>
     </UserAlerts>
   </UserObject>
 </Publisher>
</ArrayOfPublisher>

But I want the following pattern

 <?xml version="1.0" encoding="utf-8" ?>
- <ArrayOfPublisher xmlns:xsi="http://www.w3.org/2001/XMLSchema-
instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
- <Publisher>
 <Number>1</Number>
 <PublisherPartnerID>1</PublisherPartnerID>
 <PublisherUserID>1</PublisherUserID>
 <Name>test</Name>
 <PhoneNumber>12344</PhoneNumber>
 <EmailAddress>a...@gmail.com</EmailAddress>
 <Description>This is testing of data</Description>
 <IsModifyTraffickingEnabled>true</IsModifyTraffickingEnabled>
 <IsModifyApprovedAdsEnabled>true</IsModifyApprovedAdsEnabled>
 <PublisherIsDeleted>false</PublisherIsDeleted>
 <PublisherDateCreated>2008-03-01T00:00:00+05:00</
PublisherDateCreated>
 <PublisherDateModified>2008-03-01T00:00:00+05:00</
PublisherDateModified>
- <UserObject>
 <Number>0</Number>
 <PartnerID>0</PartnerID>
 <UserName>test1</UserName>
 <Password>323343</Password>
 <IsEnabled>false</IsEnabled>
 <IsDeleted>false</IsDeleted>
 <DateCreated>0001-01-01T00:00:00</DateCreated>
 <DateModified>0001-01-01T00:00:00</DateModified>
- <UserAlerts>
- <UserAlerts>
 <UserAlertsID>0</UserAlertsID>
 <UserAlertsUserID>1</UserAlertsUserID>
 <UserAlertID>1</UserAlertID>
 <UserAlertsIsEnabled>false</UserAlertsIsEnabled>
 <UserAlertsIsDeleted>false</UserAlertsIsDeleted>
 <UserAlertsDateCreated>2008-03-01T00:00:00+05:00</
UserAlertsDateCreated>
 <UserAlertsDateModified>2008-03-01T00:00:00+05:00</
UserAlertsDateModified>
 </UserAlerts>
- <UserAlerts>
 <UserAlertsID>0</UserAlertsID>
 <UserAlertsUserID>1</UserAlertsUserID>
 <UserAlertID>1</UserAlertID>
 <UserAlertsIsEnabled>false</UserAlertsIsEnabled>
 <UserAlertsIsDeleted>false</UserAlertsIsDeleted>
 <UserAlertsDateCreated>2008-03-01T00:00:00+05:00</
UserAlertsDateCreated>
 <UserAlertsDateModified>2008-03-01T00:00:00+05:00</
UserAlertsDateModified>
 </UserAlerts>
 </UserAlerts>
- <UserRolesCollectionObject>
- <UserRoles>
 <Number>0</Number>
 <UserID>1</UserID>
 <UserRoleID>1</UserRoleID>
 <IsEnabled>false</IsEnabled>
 <IsDeleted>false</IsDeleted>
 <DateCreated>2008-03-01T00:00:00+05:00</DateCreated>
 <DateModified>2008-03-01T00:00:00+05:00</DateModified>
 </UserRoles>
- <UserRoles>
 <Number>0</Number>
 <UserID>1</UserID>
 <UserRoleID>1</UserRoleID>
 <IsEnabled>false</IsEnabled>
 <IsDeleted>false</IsDeleted>
 <DateCreated>2008-03-01T00:00:00+05:00</DateCreated>
 <DateModified>2008-03-01T00:00:00+05:00</DateModified>
 </UserRoles>
 </UserRolesCollectionObject>
 </UserObject>
 </Publisher>
- <Publisher>
 <Number>2</Number>
 <PublisherPartnerID>2</PublisherPartnerID>
 <PublisherUserID>1</PublisherUserID>
 <Name>test2</Name>
 <PhoneNumber>2</PhoneNumber>
 <EmailAddress>d...@gmail.com</EmailAddress>
 <Description>This is testing of data</Description>
 <IsModifyTraffickingEnabled>true</IsModifyTraffickingEnabled>
 <IsModifyApprovedAdsEnabled>true</IsModifyApprovedAdsEnabled>
 <PublisherIsDeleted>false</PublisherIsDeleted>
 <PublisherDateCreated>2008-03-01T00:00:00+05:00</
PublisherDateCreated>
 <PublisherDateModified>2008-03-01T00:00:00+05:00</
PublisherDateModified>
- <UserObject>
 <Number>0</Number>
 <PartnerID>0</PartnerID>
 <UserName>test1</UserName>
 <Password>323343</Password>
 <IsEnabled>false</IsEnabled>
 <IsDeleted>false</IsDeleted>
 <DateCreated>0001-01-01T00:00:00</DateCreated>
 <DateModified>0001-01-01T00:00:00</DateModified>
- <UserAlerts>
- <UserAlerts>
 <UserAlertsID>0</UserAlertsID>
 <UserAlertsUserID>1</UserAlertsUserID>
 <UserAlertID>1</UserAlertID>
 <UserAlertsIsEnabled>false</UserAlertsIsEnabled>
 <UserAlertsIsDeleted>false</UserAlertsIsDeleted>
 <UserAlertsDateCreated>2008-03-01T00:00:00+05:00</
UserAlertsDateCreated>
 <UserAlertsDateModified>2008-03-01T00:00:00+05:00</
UserAlertsDateModified>
 </UserAlerts>
- <UserAlerts>
 <UserAlertsID>0</UserAlertsID>
 <UserAlertsUserID>1</UserAlertsUserID>
 <UserAlertID>1</UserAlertID>
 <UserAlertsIsEnabled>false</UserAlertsIsEnabled>
 <UserAlertsIsDeleted>false</UserAlertsIsDeleted>
 <UserAlertsDateCreated>2008-03-01T00:00:00+05:00</
UserAlertsDateCreated>
 <UserAlertsDateModified>2008-03-01T00:00:00+05:00</
UserAlertsDateModified>
 </UserAlerts>
 </UserAlerts>
- <UserRolesCollectionObject>
- <UserRoles>
 <Number>0</Number>
 <UserID>1</UserID>
 <UserRoleID>1</UserRoleID>
 <IsEnabled>false</IsEnabled>
 <IsDeleted>false</IsDeleted>
 <DateCreated>2008-03-01T00:00:00+05:00</DateCreated>
 <DateModified>2008-03-01T00:00:00+05:00</DateModified>
 </UserRoles>
- <UserRoles>
 <Number>0</Number>
 <UserID>1</UserID>
 <UserRoleID>1</UserRoleID>
 <IsEnabled>false</IsEnabled>
 <IsDeleted>false</IsDeleted>
 <DateCreated>2008-03-01T00:00:00+05:00</DateCreated>
 <DateModified>2008-03-01T00:00:00+05:00</DateModified>
 </UserRoles>
 </UserRolesCollectionObject>
 </UserObject>
 </Publisher>
 </ArrayOfPublisher>

Note there is an extra node of UserAlerts which is missing in the
first one
Any help regarding this issue.

I am using vb.net2005

Advance Thanks
mna_4u(at)hotmail.com
Reply to this Message
sloan - 06 Mar 2008 15:40 GMT
microsoft.public.sqlserver.programming
would probably be a more germane newsgroup.

>I have a master class suppose Pubisher which contains UserObject as
> property.
[quoted text clipped - 269 lines]
> Advance Thanks
> mna_4u(at)hotmail.com
Reply to this Message

 Rate this thread:







Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.