Need Expert Help and Advice. Thank You.

Hello,

Consider I have a String:

Dim MyStringAs String ="Hello"

or an Integer:

Dim MyIntegerAs Integer = 100

or a class which its properties:

Dim MyClass As New MyCustomClassMyClass.Property1 ="Hello"MyClass.Property2 = Unit.Pixel(100)MyClass.Property3 = 100

Or even a control:

Dim MyLabelAs LabelMyLabel.Id ="MyLabel"MyLabel.CssClass ="MyLabelCssClass"

Is there a way to save a String, an Integer, a Boolean, a Class, a Control in an SQL database?

Something like:

Define something (Integer, String, Class, Control, etc)

Save in SQL 2005 Database

Later in code Retrive from database given its ID

Is this possible?

How should I do this?

What type of SQL 2005 table field should be used to store the information?

Thanks,

Miguel

Yes it is possible

You can serialize your object (some extra design work) and save as XML in XML field. The advantage is that you can search this XML on SQL server. Another solution is to save your object as binary data in image field or varbinary(max) (which is now recommended replacement for image field). You probably have to have another field in your database to identity your object.

Thanks

Need advice

Hi,
I have a few offices accross the country running MSDE and my HQ SQL 2000. I
need to port the data nightly to the HQ. Should I consider Replication?
Whatever is done on the MSDE at the offices are not needed after copied to
the HQ. I was thinking of creating an app (running at all offices) to copy
the data nightly to the HQ but I am worried if the connection goes down
during the copy?
Please advice.
Thanks
I would do this with DTS instead of replication since you don't have a
requirement to maintain the data in MSDE after it is transferred and it
doesn't appear you are sending anything from HQ back to any of the offices.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:574D914C-55A2-48B3-B606-55DD5D9E02BC@.microsoft.com...
> Hi,
> I have a few offices accross the country running MSDE and my HQ SQL 2000.
> I
> need to port the data nightly to the HQ. Should I consider Replication?
> Whatever is done on the MSDE at the offices are not needed after copied to
> the HQ. I was thinking of creating an app (running at all offices) to copy
> the data nightly to the HQ but I am worried if the connection goes down
> during the copy?
> Please advice.
> Thanks