create xml dynamically for client in asp.net

Jan 16 2006 3:00 AM
using vb in asp.net. i am querying a set of records containing codes and names of products. for every branch there are different codes and names. my question is how can i pass the xml file created dynamically to the client? can this be done? what i need is to store the data coming from sql server and put it in an xml file to be used by the user. in program i create the file "myXML.xml" after query. if user1 and user2 use the program, will the content of myXML.xml be the same for both users? They are NOT supposed to have the same content. is my questions correct? i do not have experienced using xml. i have created a program putting the sql data or dataset in a session. if possible i would like to put it in xml. any suggestion or comments is gladly welcome. thank you.