469,572 Members | 1,306 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,572 developers. It's quick & easy.

ACCESS -> (XML + XLST) -> to files

Sorry I don't have code yet. I'm asking for solutions which can help me
solve the problem. This is the first time I have to cope this situation,
hence I'm clueless how to start. I would like to ask for some ideas then I
can start from scratch.

Let's say: I have a dataset which has a table Customers (which retrieves
from an Access Database)
1/ I convert it into XML format, it should look like this
<Customer>
<Name>...</Name>
<SSN>....<SSN<
...
</Customer>
My Question for this is how can I write it into a file.

2/ Second, I want to view it in any browser by providing it a XLST format;
otherwise I also need to provide XLST to read the XML as well

My Question for this is: how can I make XLST format generic since the
table can always be different. It's not always Customers, it can be
Contacts, Addresses.....

I appreciate for any ideas
Thanks

PS: The way I describe above may be not efficient. If there are other ways,
please instruct me)

"Oleg Tkachenko" <oleg@NO!SPAM!PLEASEtkachenko.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Hai Nguyen wrote:
I would like to know after transforming my datatables which store in dataset into XML form. Now I want to save it into a file and also create a XLST file to read it.

Well, could you please elaborate the question? Feel free to post some
code and samples.
--
Oleg Tkachenko
XML Insider
http://www.tkachenko.com/blog

Nov 18 '05 #1
3 1359
why use xml and xlst when all you need to do is show it on a browser ?

its a good idea if you can have any particular type of file transform...
..say xls download or tab download etc... in that case you just load the
corresponding xslt... and transform..

but in this case.. just use DataGrid.... use auto generation of columns for
datagrid....... bind the dataset...

HTH
--
Regards,

HD

"Hai Nguyen" <ha******@neo.tamu.edu> wrote in message
news:eT**************@TK2MSFTNGP09.phx.gbl...
Sorry I don't have code yet. I'm asking for solutions which can help me
solve the problem. This is the first time I have to cope this situation,
hence I'm clueless how to start. I would like to ask for some ideas then I
can start from scratch.

Let's say: I have a dataset which has a table Customers (which retrieves
from an Access Database)
1/ I convert it into XML format, it should look like this
<Customer>
<Name>...</Name>
<SSN>....<SSN<
...
</Customer>
My Question for this is how can I write it into a file.

2/ Second, I want to view it in any browser by providing it a XLST format;
otherwise I also need to provide XLST to read the XML as well

My Question for this is: how can I make XLST format generic since the
table can always be different. It's not always Customers, it can be
Contacts, Addresses.....

I appreciate for any ideas
Thanks

PS: The way I describe above may be not efficient. If there are other ways, please instruct me)

"Oleg Tkachenko" <oleg@NO!SPAM!PLEASEtkachenko.com> wrote in message
news:%2****************@TK2MSFTNGP10.phx.gbl...
Hai Nguyen wrote:
I would like to know after transforming my datatables which store in dataset into XML form. Now I want to save it into a file and also create a
XLST
file to read it.

Well, could you please elaborate the question? Feel free to post some
code and samples.
--
Oleg Tkachenko
XML Insider
http://www.tkachenko.com/blog


Nov 18 '05 #2
Hai Nguyen wrote:
Sorry I don't have code yet. I'm asking for solutions which can help me
solve the problem. This is the first time I have to cope this situation,
hence I'm clueless how to start. I would like to ask for some ideas then I
can start from scratch.

Let's say: I have a dataset which has a table Customers (which retrieves
from an Access Database)
1/ I convert it into XML format, it should look like this
<Customer>
<Name>...</Name>
<SSN>....<SSN<
...
</Customer>
My Question for this is how can I write it into a file.

see XmlDocument.Save method
http://msdn.microsoft.com/library/de...ssavetopic.asp

2/ Second, I want to view it in any browser by providing it a XLST format;
otherwise I also need to provide XLST to read the XML as well

My Question for this is: how can I make XLST format generic since the
table can always be different. It's not always Customers, it can be
Contacts, Addresses.....


do you need to use XSLT, are you sending the file elsewhere for display?
Otherwise, a DataGrid can read in such a file (since it's a DataSet)
and you can define a custom display format using template
columns....otherwise, if you do need XSLT, then you need to read up on
it, as you are asking exactly what it does and is for.

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET
Nov 18 '05 #3
You are right. I have to send the file to user so that they can keep their
file. That's the requirement.

I would like to know how i can do that

Thank for all your help so far. I need more a little tip I will be fine.


2/ Second, I want to view it in any browser by providing it a XLST format;
otherwise I also need to provide XLST to read the XML as well

My Question for this is: how can I make XLST format generic since the table can always be different. It's not always Customers, it can be
Contacts, Addresses.....

do you need to use XSLT, are you sending the file elsewhere for display?
Otherwise, a DataGrid can read in such a file (since it's a DataSet)
and you can define a custom display format using template
columns....otherwise, if you do need XSLT, then you need to read up on
it, as you are asking exactly what it does and is for.


"Craig Deelsnyder" <cdeelsny@NO_SPAM_4_MEyahoo.com> wrote in message
news:uB**************@TK2MSFTNGP09.phx.gbl... Hai Nguyen wrote:
Sorry I don't have code yet. I'm asking for solutions which can help me
solve the problem. This is the first time I have to cope this situation,
hence I'm clueless how to start. I would like to ask for some ideas then I can start from scratch.

Let's say: I have a dataset which has a table Customers (which retrieves
from an Access Database)
1/ I convert it into XML format, it should look like this
<Customer>
<Name>...</Name>
<SSN>....<SSN<
...
</Customer>
My Question for this is how can I write it into a file.

see XmlDocument.Save method

http://msdn.microsoft.com/library/de...ssavetopic.asp
2/ Second, I want to view it in any browser by providing it a XLST format; otherwise I also need to provide XLST to read the XML as well

My Question for this is: how can I make XLST format generic since the table can always be different. It's not always Customers, it can be
Contacts, Addresses.....


do you need to use XSLT, are you sending the file elsewhere for display?
Otherwise, a DataGrid can read in such a file (since it's a DataSet)
and you can define a custom display format using template
columns....otherwise, if you do need XSLT, then you need to read up on
it, as you are asking exactly what it does and is for.

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

Nov 18 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Hai Nguyen | last post: by
1 post views Thread by Rahul Agarwal | last post: by
reply views Thread by Haffe | last post: by
3 posts views Thread by Christoph Wienands | last post: by
1 post views Thread by Luigi | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.