WebServices and XMl dataset

[Sam]

Hi there!

I would like to know:

a) How to read xml datasets from cache?

b) How to save it as xml and map the fields and update the my sql /
SYbase database?

Please help me out.

With Thanks!
Sam

[Gaurav Vaish \(EduJini.IN\)]

> a) How to read xml datasets from cache?

As everything else :)
Ok... I assume that you are referring to System.Web.Cach ing cache.
You can directly do:
Cache.Add(...)

b) How to save it as xml and map the fields and update the my sql /
SYbase database?

DataSet to XML:
Use the overloaded method DataSet.WriteXm l(...)

MySQL and Sybase:
Checkout for the native drivers. Or you may want to use ODBC drivers.
For MySQL - http://www.mysql.com/products/connector/net/
I don't work with Sybase... but at least ODBC driver should be
available.

--
Happy Hacking,
Gaurav Vaish
http://www.mastergaurav.org
http://webservices.edujini.in
-------------------

[Gaurav Vaish \(EduJini.IN\)]

>> b) How to save it as xml and map the fields and update the my sql /

SYbase database?

DataSet to XML:
Use the overloaded method DataSet.WriteXm l(...)

Oops! I think I misunderstood you.

You may want to look at NHibernate -- www.nhibernate.org -- and O/R Mapping
tool is what you are looking for.
--
Happy Hacking,
Gaurav Vaish
http://www.mastergaurav.org
http://webservices.edujini.in
-------------------

[Newkid]

Hi Gaurav,

I was looking at your website where you have published couple of articles pertaining to webservices.

As far as point (a) is concern, you're true on your stand. I would like to know what Cache.Add(..) will do? Will it read or add something to cache? Please clarify and what could be the parameter of add function?

Point (b) is about to save the datasets into xml (in case, not able to read from webserver cache), maps the fields so that one can update the database at our end.

Thanks a ton for lending me a helping hand...

Sam

[Sam]

Thanks Gaurav for showing some light on this nasty issue.

What could be the parameter of Cache.add() ? Secondly, to store the xml
file do we need to provide the physical path or website address?

With Thanks!
Sam

[Gaurav Vaish \(EduJini.IN\)]

> What could be the parameter of Cache.add() ? Secondly, to store the xml

file do we need to provide the physical path or website address?

Look into the documentation.. . you'll get all required info there --
specfically the method signatures.

These methods are overloaded. Choose the one that suits you the most.
--
Happy Hacking,
Gaurav Vaish
http://www.mastergaurav.org
http://webservices.edujini.in
-------------------

[Sam]

Gaurav,

Sorry to get back you little late as I'm suffering from fever.

All the way, I am unable to read the dataset that is stored in cache.
Could you please help me out? I tried fragment caching, page caching,
serialization & deserialization etc etc.

Please help me out by explaining at length.

Thanks for your time and support.

Gaurav Vaish (EduJini.IN) wrote:

What could be the parameter of Cache.add() ? Secondly, to store the xml
file do we need to provide the physical path or website address?

Look into the documentation.. . you'll get all required info there --
specfically the method signatures.

These methods are overloaded. Choose the one that suits you the most.
--
Happy Hacking,
Gaurav Vaish
http://www.mastergaurav.org
http://webservices.edujini.in
-------------------

[Gaurav Vaish \(www.EduJini.IN\)]

Hi Sam,

Sorry to hear about your fever. Hope you're feeling ok now.

All the way, I am unable to read the dataset that is stored in cache.
Could you please help me out? I tried fragment caching, page caching,
serialization & deserialization etc etc.
What all is that you've tried?
What's the error that you're getting?
Please help me out by explaining at length.

Let me figure out some time to write at length on this. Not sure if I have
any time this week... but will try to do it ASAP :)

Get well soon.

--
Happy Hacking,
Gaurav Vaish | http://www.mastergaurav.org
http://www.edujini.in | http://webservices.edujini.in
-------------------

[Sam]

No, I am not getting any error. That is the main problem. Please check
for more details:

https://asylumwakeskatesnow.com/ePos...vice/PWWS.asmx

Thanks for your time and support.

Sam
Gaurav Vaish (www.EduJini.IN) wrote:

Hi Sam,

Sorry to hear about your fever. Hope you're feeling ok now.

All the way, I am unable to read the dataset that is stored in cache.
Could you please help me out? I tried fragment caching, page caching,
serialization & deserialization etc etc.

What all is that you've tried?
What's the error that you're getting?

Please help me out by explaining at length.

Let me figure out some time to write at length on this. Not sure if I have
any time this week... but will try to do it ASAP :)

Get well soon.

--
Happy Hacking,
Gaurav Vaish | http://www.mastergaurav.org
http://www.edujini.in | http://webservices.edujini.in
-------------------