XML Schema Formatting for SchemaGen - XML / XSL Discussion Boards

How to Parse CData value through ISAXXMLReader

pch19827-May-08 21:56

pch1982

7-May-08 21:56

I am facing a issue while parsing CDATA value through ISAXXMLReader.
can anybody guide me for the same

How to Generate HTML Reports in C#..

Aswanth4-May-08 21:59

Aswanth

4-May-08 21:59

Hi..

I'm Using Asp.Net with C#..
I want to Generate HTML Reports in C# with XML Data..

This is my XML Data(xml_Data.xml)

<Page_Details>
<Log Page="show_Page.aspx" Time="07:05:07:32636" Type="Master" ID="1" />
<Log Page="show_Page.aspx" Time="08:10:20:32636" Type="Master" ID="2" />
<Log Page="show_Page.aspx" Time="09:15:20:32636" Type="Master" ID="1"/>
<Log Page="show_Page.aspx" Time="05:20:45:32636" Type="Master" ID="3"/>
</Page_Details>

Please give me the Suggestions in doing this..

Thank You..

Re: How to Generate HTML Reports in C#..

led mike6-May-08 4:57

led mike

6-May-08 4:57

A popular approach would be to use XSLT[^]

led mike

Re: How to Generate HTML Reports in C#.. [modified]

Vinay Dornala9-May-08 0:40

Vinay Dornala

9-May-08 0:40

Hi,

I am suggesting best for XSLT. This will helpful for quick learning.

http://www.zvon.org/xxl/XSLTutorial/Books/Book1/index.html

Regards,

--XSLT team.

modified on Monday, May 19, 2008 9:22 AM

Re: How to Generate HTML Reports in C#..

Christian Graus11-May-08 23:19

Christian Graus

11-May-08 23:19

shakeela wrote:
XSLT team.

Say what ?

Christian Graus

Please read this if you don't understand the answer I've given you

"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 )

Searching against child node in XML

kmpatel4-May-08 11:26

kmpatel

4-May-08 11:26

Hi
I am trying to search for every <author> element that may contain content
such as 'Vignesh'. but there are some potential problems with it.

It only searches the first child of <file> named <author> and never
goes to the second child <author>. IF i search for 'Diaz' or 'Krish', It returns record but for 'Vignesh' and 'Tomy', it does not return record. Is there any logic to search for second child node?Please give me some idea. Any help with this will be greatly appreciated.

I faced formating problem to post xml file so it looks like this hope you dont mind.

document
file
author Diaz John author
author Vignesh Mehta author
/file
file
author Krish P author
author Tomy M. author
/file
/document

Thanks
KP

Re: Searching against child node in XML

led mike6-May-08 4:57

led mike

6-May-08 4:57

kmpatel wrote:
It only searches

It? Sorry but that doesn't tell us anything useful.

kmpatel wrote:
I faced formating problem to post xml file so it looks like this hope you dont mind.

On the screen where you post there is a checkbox "Ignore HTML tags in this message (good for code snippets)"

led mike

XML Schema Formatting for SchemaGen

AirWalk092-May-08 5:58

AirWalk09

2-May-08 5:58

I have an XML Schema that i would like to use BulkLoad 4.0 SchemaGen to create the tables in an SQL 2005 Database. I get the error "Schema: the parent/child table of the relationship on 'Listings' does not match." Code for the Schema is as follows:

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="http://platform.point2.com/schemas/2.0/listingDataFeed" xmlns="http://platform.point2.com/schemas/2.0/listingDataFeed" elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:sql="urn:schemas-microsoft-com:mapping-schema">

<xs:annotation>
<xs:appinfo>
<sql:relationship name="Test"
parent="ListingDataFeed"
parent-key="Listings_Id"
child="Listings"
child-key="Listings_Id"
inverse="true"/>
</xs:appinfo>
</xs:annotation>

<xs:element name="ListingDataFeed" type="data" sql:relation="ListingsDataFeed"
sql:key-fields="Listings_Id"/>
<xs:complexType name="data">
<xs:sequence>
<xs:element name="PublishDate" type="xs:dateTime"/>
<xs:element name="DocumentationUrl" type="xs:string"/>
<xs:element name="Disclaimer" type="xs:string"/>
<xs:element name="Copyright" type="xs:string"/>
<xs:element name="Listings" type="listings" minOccurs="0" sql:relation="Listings"
sql:key-fields="Listings_Id"
sql:relationship="Test"/>
</xs:sequence>
</xs:complexType>
<xs:complexType name="listings">
<xs:sequence>
<xs:element name="Listing" type="listing" minOccurs="0" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>

All of the code defining relationships is what I have added to the Schema that i received in an attempt to set proper relationships to "Listings". There is further XML code for the "listing" data, but i'm pretty sure that the problem is in the code above. Any help would be really appreciated, Thanks!

Pieter.

Saving an XML file as an HTML file without losing XSL formatting applied to XML.

preeti asai2-May-08 2:29

preeti asai

2-May-08 2:29

Hi friends,
I have an XML file, and it has XSL file that is applied for formatting data contained in xml. Now I WANT TO SAVE THE XML FILE AS AN HTML FILE, but the content and styles should not be lost. Thats what my problem is.

when i m saving the xml file as an html, its all styles are lost, and it saves only plain text.

So please if u have any solution for that, pls provide me that, as soon as possible.

Thanks in advance.

Re: Saving an XML file as an HTML file without losing XSL formatting applied to XML.

Christian Graus2-May-08 21:21

Christian Graus

2-May-08 21:21

xml, html, and xsl files are only plain text. It sounds to me like what you mean is, you used newlines to generate breaks in your text file and you need to change your XSL to instead add br tags, so you emit HTML.

XML: Read, Write and Modify

Zaegra1-May-08 7:15

Zaegra

1-May-08 7:15

Hello,
I have a group called GroupX and it contains several brands. Those brands contain products and those products have two values: their price and their product number. Now I want to store this in a XML file, and I know that I have to use System.XML but I just can't find out on how to store, read and modify this data using XML. I've searched the internet, but didn't find what I was looking for.. I am using Visual Basic with Visual Studio 2005.

Please help me out, Smile | :)

--Zaegra--

Re: XML: Read, Write and Modify

DerekFL1-May-08 9:36

DerekFL

1-May-08 9:36

Is this in a database or do you want to create the xmlDocument in Visual Basic from a text file or something?

Re: XML: Read, Write and Modify

Christian Graus3-May-08 1:18

Christian Graus

3-May-08 1:18

Zaegra wrote:
I've searched the internet

I find that hard to believe.

There is a myriad of ways to store XML, the easiest is to use a stringbuilder to build your XML by hand, but that is more error prone than using XMLDocument or the XMLStreamWriter ( not sure what that is called ). XMLDocument is a standard DOM implimentation, it's how you would read/modify an XML document.

WSE 3.0 and SoapHeaderException with database???

jerome_data29-Apr-08 7:27

jerome_data

29-Apr-08 7:27

Hi,

I try to implement WSE and Custom UsernameTokenManager (http://msdn2.microsoft.com/en-us/library/aa480575.aspx#wss_ch3_impdirectauth_wse30_topic6) to connect todatabase

I use in my webconfig:

<connectionStrings>
<add name="MySqlConnection" connectionString="Data Source=MySqlServer;Initial Catalog=aspnetdb;Integrated Security=SSPI;" />
</connectionStrings>
<system.web>
...
<membership defaultProvider="SqlProvider" userIsOnlineTimeWindow="15">
<providers>
<clear />
<add
name="SqlProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="MySqlConnection"
applicationName="MyApplication"
enablePasswordRetrieval="false"
enablePasswordReset="true"
requiresQuestionAndAnswer="true"
requiresUniqueEmail="true"
passwordFormat="Hashed" />
</providers>
</membership>

But when i test my webservice i have this message:
Server unavailable, please try later

ConnectionString is ok.

Thanks

Need to assign value from xml file to string variable in .net

subbu.sk27-Apr-08 21:20

subbu.sk

27-Apr-08 21:20

Hai all,

i had on gateway.xml file,like

<<?xml version="1.0" encoding="utf-8" ?><br="" mode="hold">
<GateWay name="UserID">

<title>Gate</title>

<Collection>

<struserid>zoo

<strpwd >test </strpwd >

<strapiID >301</strapiID >

<strurl >http://sms.xyz.com/sen.asp?</strurl >

</Collection>
>

and i need to assign strUserID variable in .net,and i had to assign the
(strUserID =zoo) from the xml file....

Thanks in advance

Thanks
Subbu.

Re: Need to assign value from xml file to string variable in .net

led mike28-Apr-08 4:28

led mike

28-Apr-08 4:28

Look for some tutorial or example articles on working with the XML DOM. There are millions of them. There are even small samples in MSDN documentation for the <code>System.XML.XMLDocument class. You might find such articles here on CodeProject or TopXML or www.w3schools.com or on MSDN.

led mike

how to prepare sitemap.xml file?

jegastar27-Apr-08 20:34

jegastar

27-Apr-08 20:34

Hi everyone,
I am developing a website in the name of www.seopageranktips.com
I am working for RSS feed in my website. I have several links in my site.How to prepare sitemap.xml file? so that my site will be craweled better. Pls help me.
---Jegastar D.

Re: how to prepare sitemap.xml file?

Mark J. Miller29-Apr-08 7:57

Mark J. Miller

29-Apr-08 7:57

I haven't had to do this in the last year, but unless things have changed each search engine has different requirements for sitemap files. You will need to visit each of the search engines separately and look at the schema for their sitemaps and use that as a guide.

Mark's blog: developMENTALmadness.blogspot.com

UPS XML Online Ship Tool Integration

chamlight24-Apr-08 12:52

chamlight

24-Apr-08 12:52

Hi-
Does anyone have any experience with integration of the UPS (United Parcel Service) Online Ship Tool, Address Verification, and Label printing into a .net c# application. We are in the middle of this project and could use any help offered. Thanks

Re: UPS XML Online Ship Tool Integration

alay jain2-May-08 20:45

alay jain

2-May-08 20:45

hi..

basically i want UPS web service which work on international level..
the code needed in asp.net 2.0

hi .. in UPS web service when i post 6 digit zip code or like any character than it is not accepted by UPS web service app. version 1.2 it gives error like " UPS only accept 5 digit zip code"

so u have any idea about UPS web service which works on all zip codes..? i want code in ASP.NET . so if u have than please send me..

XML file and Database

Sankalp Verma22-Apr-08 22:48

Sankalp Verma

22-Apr-08 22:48

Hi all,

I want to build an application in which I have an XML files which contains the connection string and credentials to connect to multiple databases. I want to connect to these databases and run a stored procedure on these database and close the connection. Can anyone guide how to proceed on this. I want to have front end which will fetch the data from the XML file for database connection, make the connection, run the stored procedure and Close the connection. Any Idea How can this be implemented.

Sankalp

Re: XML file and Database

Christian Graus22-Apr-08 23:24

Christian Graus

22-Apr-08 23:24

Just use XPath to select the nodes containing your connection strings, then use them to connect. Which bit are you stuck on ?

Re: XML file and Database

raginisingh24-Apr-08 22:03

raginisingh

24-Apr-08 22:03

sir ,
i have a que is that how to acess xml in database

ragini

Xml Attibute in C#

manustone21-Apr-08 23:59

manustone

21-Apr-08 23:59

HI am trying to Serialize( cos requested by application )
a class using XML Attributes.
Xml file should be like the one written below. I tried using XML
Serialization Attributes but I cannot find any solution.
The fact is that for each item name is an attribute for the class
variable, but I am not able to put the value without adding an extra tag.
Have you some idea about that?

OUPUT on FILE expected
<MyData>
<variable name="FirstVar">value
<variable name="FirstVar">value1</variable>
<variable name="SecondVar">value2</variable>
<variable name="ThirdVar">value3</variable>
</MyData>

MY CLASS that doesn't work
class variable
{
[XmlAttribute]
String name;
}
class MyData
{
[XmlElement]
variable[] list;
}

write xml root element attribute string in .net(C#).

r aa j20-Apr-08 23:26

r aa j

20-Apr-08 23:26

how to write xml root element attribute string in .net(C#).like
anybody know plz reply me

Rajendran.AL

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