reading xml file and write it into text file in C# - XML / XSL Discussion Boards

First Prev Next

Re: Can I protect Xml file with password?

led mike5-Mar-08 5:12

led mike

5-Mar-08 5:12

See if this helps.[^]

In case you are interested I know nothing about VB or VB.NET, I found this by searching with Google.

led mike

creating an xml file based on the parameters and XML Schema

elizabethsheeba4-Mar-08 4:02

elizabethsheeba

4-Mar-08 4:02

iam creating a reporting webpage. we have several types of reports like sales , customer ,....... if the user selects sales it will redirects to a separate page where they need to enter different parameters using the dropdown,textbox or listbox. for example they have different parameters like product,month,year,location. the user can enter any combinations. like either they select product and location or month and year like any combinations. once they submit the webpage , we have to pass those parameters to the XML and then query the database according to that. hope you've understood my explanation. so for this i just want to know how to send the parameters to the XML and then query the database. Please help me out

Re: creating an xml file based on the parameters and XML Schema

led mike4-Mar-08 12:03

led mike

4-Mar-08 12:03

see if this helps[^], I have not read it.

led mike

[Message Deleted]

Lavanya Madan3-Mar-08 20:27

Lavanya Madan

3-Mar-08 20:27

[Message Deleted]

Re: getting data from XML using vb.net

Christian Graus3-Mar-08 21:35

Christian Graus

3-Mar-08 21:35

What does 'can't read data' mean ? What happens ? What does your XML look like ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: [Message Deleted]

Christian Graus3-Mar-08 22:16

Christian Graus

3-Mar-08 22:16

How is it intelligent to post a question, and to respond when someone tries to get enough info out of you that they can help, by deleting your message ?

NOOB XSD related question.

rotovibe29-Feb-08 5:28

rotovibe

29-Feb-08 5:28

.NET 1.1

Working with the XmlValidatingReader object with an xsd in the XmlSchemCollection to validate a serialized version of a class.

I am getting this XmlSchemaException when I read through the stream to validate my XML.

"The 'TransactionMethod' element is not declared. An error occurred at , (22, 4)."

I am not an XSD expert and would like to get some feedback as to what may be the cause/solution of/for this exception. Included is an XSD that was generated from the actual class as well as the xml I am trying to validate.

---- XSD ----

<br />
<?xml version="1.0" encoding="utf-8"?><br />
<xs:schema targetNamespace="urn:creditcardpaymentrequest-schema" xmlns="urn:creditcardpaymentrequest-schema" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema"><br />
  <xs:element name="CreditCardPaymentRequest" nillable="true" type="CreditCardPaymentRequest" /><br />
  <xs:complexType name="CreditCardPaymentRequest"><br />
    <xs:complexContent mixed="false"><br />
      <xs:extension base="EPayPaymentRequest"><br />
        <xs:sequence><br />
          <xs:element minOccurs="0" maxOccurs="1" name="CreditCard" type="CreditCard" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="AuthorizationOnly" type="xs:boolean" /><br />
        </xs:sequence><br />
      </xs:extension><br />
    </xs:complexContent><br />
  </xs:complexType><br />
  <xs:complexType name="EPayPaymentRequest" abstract="true"><br />
    <xs:complexContent mixed="false"><br />
      <xs:extension base="EPayTransactionRequest"><br />
        <xs:sequence><br />
          <xs:element minOccurs="1" maxOccurs="1" name="IgnoreDuplicates" type="xs:boolean" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="RecurringIndicator" type="xs:boolean" /><br />
        </xs:sequence><br />
      </xs:extension><br />
    </xs:complexContent><br />
  </xs:complexType><br />
  <xs:complexType name="EPayTransactionRequest" abstract="true"><br />
    <xs:complexContent mixed="false"><br />
      <xs:extension base="BaseEntity"><br />
        <xs:sequence><br />
          <xs:element minOccurs="1" maxOccurs="1" name="CustomerId" type="xs:int" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="CustomerNumber" type="xs:string" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="TransactionId" type="xs:int" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="TransactionType" type="TransactionType" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="TransactionMethod" type="TransactionMethod" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="TransactionOrigin" type="TransactionOrigin" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="TransactionAmount" type="xs:decimal" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="ConvenienceFee" type="xs:decimal" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="ServiceOrderFee" type="xs:decimal" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="TotalAmount" type="xs:decimal" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="WaiveMinimumAmount" type="xs:boolean" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="WaiveConvenienceFee" type="xs:boolean" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="WaiveServiceOrderFee" type="xs:boolean" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="ContactName" type="xs:string" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="ContactNumber" type="xs:string" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="Note" type="xs:string" /><br />
        </xs:sequence><br />
      </xs:extension><br />
    </xs:complexContent><br />
  </xs:complexType><br />
  <xs:complexType name="BaseEntity" abstract="true"><br />
    <xs:sequence><br />
      <xs:element minOccurs="1" maxOccurs="1" name="DataStatus" type="EntityDataStatus" /><br />
      <xs:element minOccurs="0" maxOccurs="1" name="OldChangedValues" type="ArrayOfKeyValue" /><br />
    </xs:sequence><br />
  </xs:complexType><br />
  <xs:simpleType name="EntityDataStatus"><br />
    <xs:restriction base="xs:string"><br />
      <xs:enumeration value="NewItem" /><br />
      <xs:enumeration value="NewModified" /><br />
      <xs:enumeration value="Modified" /><br />
      <xs:enumeration value="NotModified" /><br />
      <xs:enumeration value="Deleted" /><br />
    </xs:restriction><br />
  </xs:simpleType><br />
  <xs:complexType name="ArrayOfKeyValue"><br />
    <xs:sequence><br />
      <xs:element minOccurs="0" maxOccurs="unbounded" name="KeyValue" nillable="true" type="KeyValue" /><br />
    </xs:sequence><br />
  </xs:complexType><br />
  <xs:complexType name="KeyValue"><br />
    <xs:complexContent mixed="false"><br />
      <xs:extension base="BaseEntity"><br />
        <xs:sequence><br />
          <xs:element minOccurs="0" maxOccurs="1" name="Key" type="xs:string" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="Value" /><br />
        </xs:sequence><br />
      </xs:extension><br />
    </xs:complexContent><br />
  </xs:complexType><br />
  <xs:complexType id="TransactionMethod" name="TransactionMethod" abstract="true"><br />
    <xs:complexContent mixed="false"><br />
      <xs:extension base="BaseEntity"><br />
        <xs:sequence><br />
          <xs:element minOccurs="1" maxOccurs="1" name="CustomerId" type="xs:int" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="AccountId" type="xs:int" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="AccountNumber" type="xs:string" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="AccountLastFour" type="xs:string" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="NameOnAccount" type="xs:string" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="RecurringIndicator" type="xs:boolean" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="RecurringDocumentReceivedDate" type="xs:dateTime" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="RecurringStartDate" type="xs:dateTime" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="RecurringEndDate" type="xs:dateTime" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="ArEPayStatusId" type="xs:int" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="UpdateDate" type="xs:dateTime" /><br />
        </xs:sequence><br />
      </xs:extension><br />
    </xs:complexContent><br />
  </xs:complexType><br />
  <xs:complexType name="CreditCard"><br />
    <xs:complexContent mixed="false"><br />
      <xs:extension base="TransactionMethod"><br />
        <xs:sequence><br />
          <xs:element minOccurs="1" maxOccurs="1" name="CardType" type="CreditCardType" /><br />
          <xs:element minOccurs="1" maxOccurs="1" name="ExpirationDate" type="xs:dateTime" /><br />
          <xs:element minOccurs="0" maxOccurs="1" name="BillingZipCode" type="xs:string" /><br />
        </xs:sequence><br />
      </xs:extension><br />
    </xs:complexContent><br />
  </xs:complexType><br />
  <xs:simpleType name="CreditCardType"><br />
    <xs:restriction base="xs:string"><br />
      <xs:enumeration value="Visa" /><br />
      <xs:enumeration value="MasterCard" /><br />
      <xs:enumeration value="Discover" /><br />
    </xs:restriction><br />
  </xs:simpleType><br />
  <xs:simpleType name="TransactionType"><br />
    <xs:restriction base="xs:string"><br />
      <xs:enumeration value="Payment" /><br />
      <xs:enumeration value="PaymentForReconnect" /><br />
      <xs:enumeration value="PaymentForRestore" /><br />
      <xs:enumeration value="Refund" /><br />
    </xs:restriction><br />
  </xs:simpleType><br />
  <xs:simpleType name="TransactionOrigin"><br />
    <xs:restriction base="xs:string"><br />
      <xs:enumeration value="Collections" /><br />
      <xs:enumeration value="BillStub" /><br />
      <xs:enumeration value="WalkIn" /><br />
      <xs:enumeration value="Recurring" /><br />
      <xs:enumeration value="AdvancePayment" /><br />
    </xs:restriction><br />
  </xs:simpleType><br />
</xs:schema><br />

--- XML TO VALIDATE ---

<br />
<?xml version="1.0" encoding="utf-8"?><br />
<CreditCardPaymentRequest xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><br />
  <DataStatus>NewModified</DataStatus><br />
  <OldChangedValues /><br />
  <CustomerId>11270</CustomerId><br />
  <CustomerNumber>119931004</CustomerNumber><br />
  <TransactionId>0</TransactionId><br />
  <TransactionType>Payment</TransactionType><br />
  <TransactionOrigin>BillStub</TransactionOrigin><br />
  <TransactionAmount>31</TransactionAmount>  <br />
  <ConvenienceFee>0</ConvenienceFee><br />
  <ServiceOrderFee>0</ServiceOrderFee><br />
  <TotalAmount>31</TotalAmount><br />
  <WaiveMinimumAmount>false</WaiveMinimumAmount><br />
  <WaiveConvenienceFee>false</WaiveConvenienceFee><br />
  <WaiveServiceOrderFee>false</WaiveServiceOrderFee><br />
  <ContactName>STEVE SMITH</ContactName><br />
  <ContactNumber>9034547688</ContactNumber><br />
  <IgnoreDuplicates>false</IgnoreDuplicates><br />
  <RecurringIndicator>false</RecurringIndicator><br />
  <AuthorizationOnly>false</AuthorizationOnly><br />
  <TransactionMethod xsi:type="TransactionMethod"><br />
    <DataStatus>NewModified</DataStatus><br />
    <OldChangedValues /><br />
    <CustomerId>11270</CustomerId><br />
    <AccountId>0</AccountId><br />
    <AccountNumber>5454545454545454</AccountNumber><br />
    <AccountLastFour>5454</AccountLastFour><br />
    <NameOnAccount>Test User</NameOnAccount><br />
    <RecurringIndicator>false</RecurringIndicator><br />
    <RecurringDocumentReceivedDate>0001-01-01T00:00:00.0000000-06:00</RecurringDocumentReceivedDate><br />
    <RecurringStartDate>0001-01-01T00:00:00.0000000-06:00</RecurringStartDate><br />
    <RecurringEndDate>0001-01-01T00:00:00.0000000-06:00</RecurringEndDate><br />
    <ArEPayStatusId>0</ArEPayStatusId><br />
    <UpdateDate>0001-01-01T00:00:00.0000000-06:00</UpdateDate><br />
    <CardType>MasterCard</CardType><br />
    <ExpirationDate>2010-10-10T00:00:00.0000000-05:00</ExpirationDate><br />
    <BillingZipCode>77777</BillingZipCode><br />
  </TransactionMethod> <br />
  <CreditCard xsi:type="CreditCard"><br />
    <DataStatus>NewModified</DataStatus><br />
    <OldChangedValues /><br />
    <CustomerId>11270</CustomerId><br />
    <AccountId>0</AccountId><br />
    <AccountNumber>5454545454545454</AccountNumber><br />
    <AccountLastFour>5454</AccountLastFour><br />
    <NameOnAccount>Test User</NameOnAccount><br />
    <RecurringIndicator>false</RecurringIndicator><br />
    <RecurringDocumentReceivedDate>0001-01-01T00:00:00.0000000-06:00</RecurringDocumentReceivedDate><br />
    <RecurringStartDate>0001-01-01T00:00:00.0000000-06:00</RecurringStartDate><br />
    <RecurringEndDate>0001-01-01T00:00:00.0000000-06:00</RecurringEndDate><br />
    <ArEPayStatusId>0</ArEPayStatusId><br />
    <UpdateDate>0001-01-01T00:00:00.0000000-06:00</UpdateDate><br />
    <CardType>MasterCard</CardType><br />
    <ExpirationDate>2010-10-10T00:00:00.0000000-05:00</ExpirationDate><br />
    <BillingZipCode>77777</BillingZipCode><br />
  </CreditCard>   <br />
</CreditCardPaymentRequest><br />

thanks!

reading xml file and write it into text file in C#

adiveppanavar29-Feb-08 3:30

adiveppanavar

29-Feb-08 3:30

hi friends...
i am reading xml file but i am not able to write it in .txt file.
so please help me how to do it. and i am using c#.net
i want read xml file and generate xyz.txt file

thanks
manohar

manohar

Re: reading xml file and write it into text file in C#

led mike29-Feb-08 4:57

led mike

29-Feb-08 4:57

adiveppanavar wrote:
but i am not able to write it in .txt file.

Post the code that you are having trouble with and explain specifically what happens, what is wrong, what the problem is.

Also read this[^]. Pay attention to item #2.

led mike

Re: reading xml file and write it into text file in C#

adiveppanavar13-Mar-08 0:57

adiveppanavar

13-Mar-08 0:57

string file = "D:\\sampleXML2.xml";
XmlTextReader reader = new XmlTextReader(file);
while (reader.Read())
{
switch (reader.NodeType)
{
case XmlNodeType.Text:
Console.WriteLine(reader.Value);
break;
}

FileStream stream = new FileStream("D:\\manohar.txt", FileMode.OpenOrCreate, FileAccess.Write);
StreamWriter sw = new StreamWriter(stream);

sw.WriteLine(reader.Value);

sw.Close();
stream.Close();
}
Console.WriteLine("Enter Any Key");
Console.ReadLine();
}

Re: reading xml file and write it into text file in C#

led mike13-Mar-08 5:56

led mike

13-Mar-08 5:56

XmlDocument doc = new XmlDocument();
doc.Load("..\\..\\NavData.xml");
StreamWriter sw = new StreamWriter("MyData.txt");
XmlNodeList nodes = doc.SelectNodes("//text()");
foreach (XmlNode n in nodes)
    sw.WriteLine(n.Value);

sw.Flush();
sw.Close();

led mike

Cannot navigate to child element through xpath

drweb8628-Feb-08 5:13

drweb86

28-Feb-08 5:13

Hi!

I have a file with next format

<root_xx xmlns="x-schema:mxschema://docsearch">
<docid>36511453

and have to extract from it a docID element with xpath

But when i'm trying to execute something like
/*/docID

it doesn't work.

Could you help me with maitaining xpath expression?

Re: Cannot navigate to child element through xpath

led mike28-Feb-08 5:54

led mike

28-Feb-08 5:54

First your post is not accounting for the '<' and '>' characters. Pay attention to the posting guides on the screen to get them posted correctly.

Also are you using some XPath documentation to learn how XPath works? www.w3schools[^] is a good source.

led mike

Dynamically generating XHTML using asp.net

honeyss27-Feb-08 22:11

honeyss

27-Feb-08 22:11

Can anyone help me regarding generating XHTML dynamically using asp.net.........
Thanks in Advance Smile | :)

Repost ignore

led mike28-Feb-08 5:49

led mike

28-Feb-08 5:49

Reposting your questions is considered rude. If you have specific questions about the materials I pointed you to in your original thread you should use that thread to ask them.

Also perhaps you should read some CodeProject Guidelines[^]

led mike

Re: Repost ignore

honeyss28-Feb-08 17:55

honeyss

28-Feb-08 17:55

Hi Mike .........
I didnt reposted the question.......
Please once go through these question thoroughly....
In the previoues post i posted the question as how to transform xml to XHTML...
and now the post is how to generate XHTML code Dynamically ..........

Cry | :((

Re: Repost ignore

led mike29-Feb-08 4:54

led mike

29-Feb-08 4:54

http://www.google.com/search?hl=en&lr=lang_en&q=MSDN+asp.net+xhtml&btnG=Search[^]

why are you so helpless?

led mike

how to insert image data(bytes) into XML File

Krishnraj26-Feb-08 20:18

Krishnraj

26-Feb-08 20:18

Dear all,

i have one table named ContactPerson in which there is one column named "PersonImg" which has a datatype - image and it stores image(.gif, .jpeg) in binary format.

Now i want to insert that table data into one XML file, but i get an error when i insert image data into XML.
Needed yr help.

Thanks in advance

Regards,
Confused | :confused:

Rana k.j.

Re: how to insert image data(bytes) into XML File

led mike28-Feb-08 5:45

led mike

28-Feb-08 5:45

krish_rana16 wrote:
Needed yr help.

Only because you refuse to study the subject yourself. There is an enormous amount of information available on the internet and probably even articles on this site that discuss and provide example code for doing just that. Lazy people who won't do their own work do not frequently find help here on CodeProject. In case you don't realize it, studying and reading documentation is part of a developers work. Wink | ;)

led mike

Formating XML

nickiii25-Feb-08 6:03

nickiii

25-Feb-08 6:03

Hi everyone:

I'm having trouble exporting the follow query to XML in a valid format. For some reason it wraps in the middle of a few elements causing .NET to say the end tag is missing. I'm using SQL '05 and when I show the query results in text the same exact thing happens.

Is it possible for to "Export to File" from within Management Studio and specify the format?

<br />
SELECT DISTINCT origin_location AS location<br />
FROM famis_locations<br />
WHERE origin_location <> ''<br />
ORDER BY origin_location<br />
FOR XML AUTO, ELEMENTS<br />

Thanks!

Re: Formating XML

led mike25-Feb-08 8:20

led mike

25-Feb-08 8:20

nickiii wrote:
I'm having trouble exporting the follow query to XML

I'm assuming you mean inserting the SQL String as text into an XML TextNode yes?

nickiii wrote:
For some reason .... causing .NET to say the end tag is missing.

you can't store text in XML that contains the lessthan and/or greaterthan ('<', '>') characters since they are XML syntax characters. There are various methods to account for this like using entities or encoding the string and then decoding it when you read it back into memory.

led mike

Re: Formating XML

nickiii25-Feb-08 8:37

nickiii

25-Feb-08 8:37

led mike wrote:
I'm assuming you mean inserting the SQL String as text into an XML TextNode yes?

No. The posted query is what I use to get the locations from SQL. I want to export the location list to XML and read the XML with .NET. The query is actually being ran in Query Analyzer.

Re: Formating XML

led mike25-Feb-08 8:52

led mike

25-Feb-08 8:52

Ah, I should have figured that from the FOR XML, by bad.

However it's probably the same problem with the results from the query containing invalid XML Text characters.

You might find more detailed answers in places like this[^]

led mike

Re: Formating XML

nickiii25-Feb-08 9:00

nickiii

25-Feb-08 9:00

I Googled this issue earlier and that site came up. Just thought I'd take the easy way out hoping someone has tried the exact same thing as myself.

Thanks for responses led mike!

XML to HTML Conversion in .Net

honeyss24-Feb-08 18:37

honeyss

24-Feb-08 18:37

Hi Can i anyone provide me the links for the conversion of XML to XHTML in .Net.
Thanks in Advance.

Last Visit: 31-Dec-99 18:00 Last Update: 9-May-24 22:59

Refresh

ᐊ Prev 1...68 69 70 717273 74 75 76 77 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.