Re: [itsdifferent] AML-XSL problem urgent

Thanks ITsDifferent group,

 

I solved the probelm with DataRelation and one to many, setting

Relation.Nested = true.

 

 i avoid join of  the table in DB SP( no redundacy then)

but create a datarelation in.NET and then writeXML

 

I actually stumbleb on this gruop on the  net and decided to join it, i have received great support from you all..

 

 

 

Thanks again

Norica

 

Dhananjay Goyani <deegoyani@yahoo.com> wrote:

Based on your XML, generage XML schema (.xsd); Once a while, you needed to generate it; not always. :) When you perform any read/write operation on the XML file (probably using Dataset; i like the most), load xml schema file first into dataset object using dataset.LoadXmlSchema, and then load the xml file.

 

Then you can access those tables using dataset.tables(0) and dataset.tables(1). Do operations and then say dataset.WriteXML()

 

This is just possible work-around to your problem. You may need to modify the logic accordingly. Hope it helps you out...

 

 

All the best!

Dhananjay

norica gohil <noricagohil@yahoo.co.in> wrote:

Hi

No i cant join them as i am using XSL and all the columns will be populated while i have multiple reasons for each Appl no.

 

Thanks,

Norica

Samir Prabhu <samirsprabhu@yahoo.co.in> wrote:

Hi,

 

In .NET you can create a join based query,populate a dataset and either through default dataset.writeXML() method or by using methods in System.xml namespace format your customized xml comprising the data.

Hope this will help you.

 

Regards,

Samir

norica gohil <noricagohil@yahoo.co.in> wrote:

Hi

Can anyone help me out with this?

 

I have two sets of data (like master Detail) i want to generate both into one as XMl so i can transform with XSl

 

Eg

data1

Appno

Address

Rollno

 

Data2

Appno1,Reason

Appno1,Reason

Appno 1,REason

Appno2,Reason

Appno2,Reason

Appno2,Reason

 

How do i fetch them and merrge to get on XMl as

<candidate>

<Appno1>  </Appno1>

<Address> </Address>

<Rollno></Rollno>

<reasons>

<Reason></Reason>

<Reason></Reason>

<Reason></Reason>

</reasons>

 

</candidate>

 

Thanks,

 

---

Yahoo! India Answers: Share what you know. Learn something new. Click here

---

Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo! Messenger with Voice.

---

Yahoo! India Answers: Share what you know. Learn something new. Click here
Send instant messages to your online friends - NOW

---

Yahoo! India Answers: Share what you know. Learn something new. Click here
Send instant messages to your online friends - NOW

Note: This Group is not a Job Searching Group, so please co-operate and dont transfer any kind of job related material across this Group.AnyOne doing so can be banned from the Group
Thanx , Group Co-Ordinators

SPONSORED LINKS

Computer software spy	Automotive computer software	Medical computer software
Computer telephony software	Computer software online training	Computer monitoring software

---

YAHOO! GROUPS LINKS

•  Visit your group "itsdifferent" on the web.
   
•  To unsubscribe from this group, send an email to:
   itsdifferent-unsubscribe@yahoogroups.com
   
•  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

---