MS SQL XML - XML Serialization

Author

XML Serialization

VKforSQLRS

2006-01-11, 9:23 am

I have got a requirement whereby : on click of a button[SAVE] data in a
textbox is to be XML serialized and stored in an SQL table. And onlick of
another button[RESTORE] that data is to be deserialized and restored on the
textbox. IS this possible and how ???

Actually I am new to serialization but it is urgent.

Any help will be highly appreciated.

Kent Tegels

2006-01-11, 8:24 pm

Hello VKforSQLRS,

> I have got a requirement whereby : on click of a button[SAVE] data in
> a textbox is to be XML serialized and stored in an SQL table. And
> onlick of another button[RESTORE] that data is to be deserialized and
> restored on the textbox. IS this possible and how ???

Yes and no. Mostly no, but if you're willing to think out of the box a bit,
its doable. One way to do is to have some intermediate class that holds the
value shown in the textbox and serialize that. I'll post an example to the
URL shown below in a few hours.

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

VKforSQLRS

2006-01-13, 3:23 am

thankyou so much for your reply.

I am working on it. Will definetly let you know the status.

"Kent Tegels" wrote:

> Hello VKforSQLRS,
>
>
> Yes and no. Mostly no, but if you're willing to think out of the box a bit,
> its doable. One way to do is to have some intermediate class that holds the
> value shown in the textbox and serialize that. I'll post an example to the
> URL shown below in a few hours.
>
> Thank you,
> Kent Tegels
> DevelopMentor
> http://staff.develop.com/ktegels/
>
>
>

Kent Tegels

2006-01-13, 9:23 am

Hello VKforSQLRS,

> thankyou so much for your reply.
> I am working on it. Will definetly let you know the status.

Here's the code sample:
http://www.sqljunkies.com/WebLog/kt...serialized.aspx

Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/

Sponsored Links