|
Hello All,
I am having some trouble taking data from my Dataset and transforming into an XML document that has the proper formatting. I'm hoping someone here may have had similar trouble in the past.
(All names have been changed to protect the innocent  )
What I want get when everything is said and done is the following:
<ResidentTransactions>
<Account>
<Customer>
<ServiceTransactions>
<Transactions>
<Charge>
<Detail>
<Description>Trash pick-up</Description>
<TransactionDate>2008-08-01</TransactionDate>
<ChargeCode>trash</ChargeCode>
<CustomerID>#########</CustomerID>
<Amount>12.00</Amount>
<Comment>Trash (08/2008)</Comment>
<PropertyPrimaryID>TestProp1</PropertyPrimaryID>
</Detail>
</Charge>
</Transactions>
<Transactions>
.
.
.
</Transactions>
</ServiceTransactions>
</Customer>
</Account>
</ResidentTransactions>
What I am getting is basically ignoring all the nesting, and just grabbing the innermost table with the actual data:
<ResidentTransactions>
<Detail>
<Description>Trash pick-up</Description>
<TransactionDate>2008-08-01</TransactionDate>
<ChargeCode>trash</ChargeCode>
<CustomerID>########</CustomerID>
<Amount>12.00</Amount>
<Comment>Trash (08/2008)</Comment>
<PropertyPrimaryID>TestProp1</PropertyPrimaryID>
</Detail>
<ResidentTransactions>
The code below is what is loading the data into the dataset:
SqlDataAdapter Da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ds.ReadXmlSchema(@"C:\DEV\Schemas\BillingData.xsd");
Da.Fill(ds, "Detail");
When writing the XML I do the following:
StringWriter source = new StringWriter();
XmlDocument SourceXml = new XmlDocument();
XmlDocument RetXml = new XmlDocument();
ds.WriteXml(source,XmlWriteMode.IgnoreSchema);
SourceXml.LoadXml(source.ToString());
I believe it may have something to do with the fact that the outermost elements don't contain any data, they just contain the sub elements. When I render the XML, those "tables" in the dataset don't actually have any data to grab. In the last few days I haven't been able to come up with a solution though, and I really don't want to piece together a big string unless I have to.
Anything that may point me in the right direction would be greatly appreciated.
Thank you,
-Ian Jacobs
[EDIT] Removed an ID code I missed on the 1st pass
|
|
|
|
|
XML is not suppose to be pretty, just correct and readable. If you want to pretty-format the XML, you have to do it yourself.
|
|
|
|
|
|
I don't understand why the CASE statements like this don't work. Why can't I check for greater than?
private int iGrade = 85;
private char cLetter = ' ';
switch (iGrade)
{
case > 90:
cLetter = 'A';
break;
case >; 80:
cLetter = 'B';
break;
case > 70:
cLetter = 'C';
break;
default:
cLetter = 'F';
break;
}
Everything makes sense in someone's mind
|
|
|
|
|
KMAROIS wrote: Why can't I check for greater than?
Because Switch Case[^] doesn't work like that. 
You can use if else [^]instead.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
In VB you can do this but not C#. I had a search around and found this[^] which gives this functionality - pretty interesting.
DaveBTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)Expect everything to be hard and then enjoy the things that come easy. (code-frog)
|
|
|
|
|
|
Blue_Boy wrote: Correct code:
Not really.
Blue_Boy wrote: case iGrade>90:
You can't do like that. The value in the case label has to be constant, and of the same type as the value in the switch.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Sorry but someone else had post unhelped this answer, I didn't post by myself.
Sure I will delete it.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
If you don't know C#, always compile your answer before giving it. This won't build.
Christian Graus
No longer a Microsoft MVP, but still happy to answer your questions.
|
|
|
|
|
Sorry but someone else had post unhelped this answer, I didn't post by myself.
Sure I will delete it
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
|
Sorry but someone else had post unhelped this answer, I didn't post by myself.
sure I will delete it.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
|
|
|
|
|
KMAROIS wrote: case >; 80:
is this a new syntax introduced in C#?
|
|
|
|
|
I'm exporting data from a datagrid to an excel spreadsheet.I want the spreadsheet to open and display the data when the data is exported(when you click button export).How do i go about making that happen.Please help
|
|
|
|
|
Twyce wrote: I want the spreadsheet to open and display the data when the data is exported(when you click button export).
Once you export the data and file has been written, open the Excel application passing the recently written file name.
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
hi,
can you please tell how you are exporting data from datagrid?
I need it urgently.
I donot have MS office installed on server
|
|
|
|
|
Im trying to create a crystal report with a subreport.. for every line that display on the main report there will be a subreport and the subreport uses a value from the line that has been displayed as its parameter.. can anyone please help with this? i created a dataset that has a datatable, i fill the dataset and point this to the subreport like this(am not sure if this is right):
SqlDataAdapter subReportAdapter = new SqlDataAdapter(query, connString);
DataSet2 ds2 = new DataSet2();
subReportAdapter .Fill(ds2, "BookedTimes");
venueReport.Subreports["TimesSubReport"].SetDataSource(ds2);
It just throws an error in runtime saying "Invalid argument provided".
|
|
|
|
|
any one has an example on how to override the style of the splitter on windows form using c#?
I want to have something like MS Outlook or Windows Vistal Explorer splitter?
|
|
|
|
|
|
Hi,
I have to install a driver msi-package (B.msi) in the installation of my application (A.msi). But it is not possible to install an msi while an other msi is running. Is there a way to start installation B.msi after the installation of A.msi, if the user doubleclicks only A.msi?
Thanks!
Ariadne
|
|
|
|
|
Ariadne wrote: Is there a way to start installation B.msi after the installation of A.msi, if the user doubleclicks only A.msi?
What about using a batch file that will run A.msi first and after that B.msi 
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
Manas Bhardwaj wrote: What about using a batch file
not bad, but there are customers, who do not look. If they see an msi-file, they click on it.
(The driver msi B.msi is part of A.msi, it is deployed after A.msi starts.)
I thing, I have to spawn a task in A.msi, which starts after A.msi has completed. - But how?
Ariadne
|
|
|
|
|
|
Go through a tutorial on the Web. They're free.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
