.NET XML Forum RSS Feed (Replies Included)

creating questionnaire section with XML in website

Sun, 18 Dec 2011 23:49:29 -0700

I've designed a website using C# and ASP.NET whose one of the feature is questionnaire section.

registered users can ask questions by logging in to the website and then go to the questionnaire section.

I want to present this system by using XML, i.e. the users questions & answers will be in XML files.

How to do this, I am pretty new to XML. Can anyone provide me the guidance?

building registration and login system with XML, C# & ASP.NET

Sun, 18 Dec 2011 08:29:29 -0700

Can anyone guide me to build registration and login system with XML, C# and ASP.NET.

I want to learn it. Are there any links for it?

I'll be very much glad if any one guides me for this tutorial.

XML parsing using XLinq

Wed, 05 Oct 2011 14:38:42 -0700

I have a simple XML schema from a video recorder that I need to parse using XLinq. All of the XLinq example seem to take a XML document. Here is the schema:

<?xml version="1.0" encoding="utf-8"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="GPSIndexes">
<xs:complexType>
<xs:sequence>
<xs:element name="annotation">
<xs:complexType>
<xs:sequence>
<xs:element name="documentation" type="xs:string" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="RHXmlType" type="xs:string" />
<xs:element name="RHXmlVersion" type="xs:decimal" />
<xs:element name="mediaName" type="xs:string" />
<xs:element name="dateCreated" type="xs:decimal" />
<xs:element name="timeCodeOffset" type="xs:unsignedByte" />
<xs:element maxOccurs="unbounded" name="GPSIndex">
<xs:complexType>
<xs:sequence>
<xs:element name="lon" type="xs:decimal" />
<xs:element name="lat" type="xs:decimal" />
<xs:element name="altitude" type="xs:decimal" />
<xs:element name="timeCode" type="xs:string" />
<xs:element name="name" />
<xs:element name="utcTime" type="xs:decimal" />
<xs:element name="course" type="xs:decimal" />
<xs:element name="speed" type="xs:decimal" />
<xs:element name="azimuth" type="xs:byte" />
<xs:element name="dop" type="xs:decimal" />
<xs:element name="fix" type="xs:string" />
<xs:element name="satsinuse" type="xs:unsignedByte" />
<xs:element name="geoidht" type="xs:decimal" />
<xs:element name="range" type="xs:unsignedByte" />
<xs:element name="data" type="xs:unsignedByte" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>

What is the proper way to load this into XLinq so I can validate XML?

Thanks,
Jason.

rsa-sha1 signature in .NET XML

Fri, 26 Jun 2009 02:19:03 -0700

Hello, I try to create the signature element like this:

<KeyInfo>
  <X509Data>
   <X509Certificate>
   </X509Certificate>
  </X509Data>
  <X509IssuerSerial>
    <X509IssuerName>
      <X509IssuerName>
      </X509IssuerName>
      <X509SerialNumber>
      </X509SerialNumber>
    </X509IssuerName>
  </X509IssuerSerial>
</KeyInfo>

But when I create code

KeyInfo ki = new KeyInfo();
KeyInfoX509Data keyInfoData = new KeyInfoX509Data(cert);
keyInfoData.AddIssuerSerial(cert.Issuer, cert.GetSerialNumberString());
ki.AddClause(keyInfoData);

I can't get it same kind.

Format is:

<KeyInfo>
  <X509Data>
    <X509IssuerSerial>
      <X509IssuerName></X509IssuerName>
      <X509SerialNumber></X509SerialNumber>
    </X509IssuerSerial>
    <X509Certificate>
    </X509Certificate>
  </X509Data>
</KeyInfo>

If I create the second X509Data-tag, I have two different X509-tags then which first have certificate and second have issuerserial.

How can I exclude X509IssuerSerial-tag from X509Data-tag?

Thank you

An XML source from the Internet

Thu, 15 Nov 2007 06:38:16 -0700

hi, all what I need is a good site(link ) that describes how to be professional starting from 0, in creation and manipulating SQL database from the .NET website.
if u have such one please send to me, because I do not have time to read books :P (not because I am lazy but because I have many books to read)

Thanks

xml automatic database setup

Mon, 20 Mar 2006 07:04:32 -0700

hi, can anyone help me. I need to create an XML script so that I dont have to manually create a database when distributing my softwares.

The script should be packaged together with the software so that during installation, the installer uses this script to create the database and the tables with all the definitions on the fly ie column names etc

ANYONE PLEASE ASSIST!

Navigating through XML Documents

Fri, 14 Oct 2005 10:23:53 -0700

Hi again,
i know that i need to use a DocumentNavigator class to navigate in XML document, i need to use MoveToChild/MoveToParent there the problem is that i don't know how to load this DocumentNavigator.
tnx for advance.

XML transformation library wanted

Thu, 25 Aug 2005 08:50:33 -0700

Hi,

Im searching for a library - free or commercial - which gives me the possibility to transform files (e.g. ini, csv, ...) to XML by the use of schema files.
My aim is to develop a program in c# which has to transform XML data to csv, ini, ... files and vice versa. I think .NET gives me a good possibility to transform XML to what ever using XSL, but what about the way back. Therefore Im searching for a library giving me that possibility. As the source files which have to be transformed have different structure/look the use of schema files are a must.

Anybody knows a good product?

Thanks in advance
Andreas

MySQL

Tue, 28 Jun 2005 20:59:43 -0700

So here is what im trying to do. Create a client windows form which connects to a mysql database on a webserver. my webserver only lets me use LOCALHOST to connect to the database, so obviously those clients, which wouldnt be LOCAL HOST, wont be able to log in. what im trying to get accomplished is that the windows form on client side gets info from various text areas and then moves them to an ASP page on the server, or perhaps XML or PHP. The server and client need to be able to send data, the data in that database, back and forth between each other. is there any way to do this, and if so please provide an example.

Re: Reading from an XML in VB.Net

Thu, 02 Jun 2005 13:00:35 -0700

: Okay all I want to do is read from one line on the XML....JUST ONE LINE. *sigh* I can't find a tut anywhere on the internet they tells me how to use the read function to do this. What I really want to do is to compare user inputted data from a text box to one element in the XML. EX: The user enters the name John; I hash that value using MD5 then check to see if the value is the same in the XML. Something like
:
: [Semi-Pseudo code]
: Dim user as HashValue (txtUser.txt)
: If user = element name Then
: Blah, blah, blah, etc...
: [/Semi-Pseudo code]
:
: But I can't read just on element. Help please.
:

Right off I cant think of how to pull one line only out of an XML file without reading the file or at least the file up to the point that the line is encountered. Although there is probably a way in the System.Xml Namespace somewhere.

I think I heard or read somewhere that .NET 2005 will support a feature like that where you could query an xml like you do a database. I am not sure of this or not, but to my knowledge in the current .NET versions XML Files need to be loaded and read through either by an XML parser or your code to get data from it. Unless you are wanting to do something like a FileStream and ReadLine() until you get to the right one but using a XmlTextReader would be faster and make it easier to read the data.

My advice appears to be the same as others you have described use the System.Xml.XmlTextReader to perform this

Dim xr as New System.Xml.Xml.TextReader(YourXmlFile)'or load XmlFragment
do while xr.read
If xr.NodeType=System.Xml.XmlNodeType.Element Then
If xr.Name==user Then
Dim input As String = xr.ReadString()
'Do your code MD5 Comparison
Exit Loop ' so you stop reading the file and no extra processing is done
End If
End If
loop
xr.Close

Hope this helps, sorry if it doesn't

XSL Transformation help needed (original and new provided)

Thu, 21 Apr 2005 23:31:15 -0700

Hi all,

I am to this forum and new to XSL. I am working on a generic reporting solution. XSL is the stumbling block.
I need to create an XSL stylesheet that converts ANY(!) XML created by .Net DataSet object into an XML file,
which can be diplayed in a web page using another stylesheet.

The DataSet can have results from multiple (!) queries.
The very first one unnamed SQL creates <table> node with the column names as children where text has the data.
Every new SQL creates Table1, Table2, etc. I need to convert all queries into headers with column names and rows with data.

Original:

<?xml version="1.0" standalone="yes"?>
<OriginalDataSet>
<Table>
<Column1>25.7500</Column1>
</Table>
<Table1>
<Test_x0020_Decimal>45.15</Test_x0020_Decimal>
</Table1>
<Table2>
<Today>2005-04-13T23:02:38.6270000+10:00</Today>
</Table2>
<Table3>
<Num_x0020_of_x0020_Authors>23</Num_x0020_of_x0020 _Authors>
</Table3>
<Table4>
<Num_x0020_of_x0020_Employees>43</Num_x0020_of_x00 20_Employees>
</Table4>
<Table5>
<Column1>Testing Output</Column1>
</Table5>
<Table6>
<au_id>172-32-1176</au_id>
<au_lname>White</au_lname>
<au_fname>Johnson</au_fname>
<phone>408 496-7223</phone>
<address>10932 Bigge Rd.</address>
<city>Menlo Park</city>
<state>CA</state>
<zip>94025</zip>
<contract>true</contract>
</Table6>
<Table6>
<au_id>213-46-8915</au_id>
<au_lname>Green</au_lname>
<au_fname>Marjorie</au_fname>
<phone>415 986-7020</phone>
<address>309 63rd St. #411</address>
<city>Oakland</city>
<state>CA</state>
<zip>94618</zip>
<contract>true</contract>
</Table6>
</OriginalDataSet>

New, comments are not necessary, they are for readability only

<?xml version="1.0" standalone="yes"?>
<?xml-stylesheet type="text/xsl" href="datasetstylesheet.xsl" ?>
<DATASET>


<header>
<field>Column1</field>
</header>
<row>
<field>25.7500</field>
</row>


<header>
<field>Test_x0020_Decimal</field>
</header>
<row>
<field>45.15</field>
</row>


<header>
<field>Today</field>
</header>
<row>
<field>2005-04-13T23:02:38.6270000+10:00</field>
</row>


<header>
<field>Num_x0020_of_x0020_Authors</field>
</header>
<row>
<field>23</field>
</row>


<header>
<field>Num_x0020_of_x0020_Employees</field>
</header>
<row>
<field>43</field>
</row>


<header>
<field>Column1</field>
</header>
<row>
<field>Testing Output</field>
</row>


<header>
<field>au_id</field>
<field>au_lname</field>
<field>au_fname</field>
<field>phone</field>
<field>address</field>
<field>city</field>
<field>state</field>
<field>zip</field>
<field>contract</field>
</header>
<row>
<field>172-32-1176</field>
<field>White</field>
<field>Johnson</field>
<field>408 496-7223</field>
<field>10932 Bigge Rd.</field>
<field>Menlo Park</field>
<field>CA</field>
<field>94025</field>
<field>true</field>
</row>
<row>
<field>213-46-8915</field>
<field>Green</field>
<field>Marjorie</field>
<field>415 986-7020</field>
<field>309 63rd St. #411</field>
<field>Oakland</field>
<field>CA</field>
<field>94618</field>
<field>false</field>
</row>

</DATASET>

Your help is appreciated!
Anatoli

If you need more info, please post here.

Reading from an XML in VB.Net

Wed, 02 Feb 2005 07:43:07 -0700

Okay all I want to do is read from one line on the XML....JUST ONE LINE. *sigh* I can't find a tut anywhere on the internet they tells me how to use the read function to do this. What I really want to do is to compare user inputted data from a text box to one element in the XML. EX: The user enters the name John; I hash that value using MD5 then check to see if the value is the same in the XML. Something like

[Semi-Pseudo code]
Dim user as HashValue (txtUser.txt)
If user = element name Then
Blah, blah, blah, etc...
[/Semi-Pseudo code]

But I can't read just on element. Help please.

XML schema

Fri, 10 Dec 2004 09:05:41 -0700

Hello,

This is the problem. I am using typed datasets, to generate an xml file from the schema xsd defined in .NET. It is populated using a stored proc in SQL server.

The putput xml file shows this: (enterprise is root element)
<enterprise xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

I need to remove this part from the output - "xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" since I also have a DTD definition in the output inserted later (the dtd declaration in the xml is a requirement)

Having both the schema definition (xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance) and the dtd is causing problems and i need to remove the schema definition. How can i do that - since I am using the schema to generate the XML file in .NET i don't know if i can do that.

any suggestions will be helpful, thanks,

saumil
Saumil Annegiri,
Research Assistant,
Center for Business and Information Technologies,
ULLafayette, LA
ph. # 337-654-8660

Re: Creating database tables from XML Data

Wed, 10 Nov 2004 12:47:07 -0700

Hi, I got the solution for this

Thank you

: Hi,
:
: I would like to know how to create a database table with the XML Data.
: I worked on reading data from XML into Dataset. It is successfule. But I am unable to create a table with that data into database.
:
: Plz help me.
:
: regards,
: Venkatesh
:

Creating database tables from XML Data

Mon, 08 Nov 2004 08:45:36 -0700

Hi,

I would like to know how to create a database table with the XML Data.
I worked on reading data from XML into Dataset. It is successfule. But I am unable to create a table with that data into database.

Plz help me.

regards,
Venkatesh

help needed-- asp .net

Mon, 14 Jun 2004 00:36:29 -0700

hi all,
could it possible to add an alert message for a ontextchanged event for a text box which is in edit template of a data grid.
alert message should contain both ok and cancel option.
does anybody has solution?
Regards,
Jamie