XML and XmlDataSource Control

Object Reference error with "Empty" XML

2013-05-22T12:30:16.987-04:00

While reading an XML file from an Abobe Form submission in an VB.Net application:

An empty tag
<PRType />

As opposed to filled tag
<PRType>1</PRType />

Throws an "Object Reference not set to an object instance". When there is data, the process works.

I've tried capturing the value of the tag, as in the following but I am unable to understand what, if any value there is when its empty and or how to check it.

Its not possible for a user to enter ALL fields on the form... there must be a way to handle "empty"?

Assistance would be appreciated... Thanks!!

If root.SelectSingleNode("PRType").ChildNodes(0).Value = "" Then

Response.Write("This field is EMPTY")
Response.End()
End If

JSON.NET create an array?

2013-05-20T05:44:23.503-04:00

Hi Im working JSON.net and need help formating form values to write as below

"bw_numbers": [23, 27, 28, 29, 34, 39],

Im thinking i need to create an array from form values, bw_1 bw_2 bw_3 bw_4 bw_5 bw_6 and parse as bw_numbers

I have my class set up;

BW_Results results = new BW_Results
        {
            //
        };

string json = "jsonCallback(\n" + JsonConvert.SerializeObject(results, Formatting.Indented) + "\n);";
        
File.WriteAllText(@"C:\inetpub\wwwroot\JSON\dotNet_BW\bw_results.json", json);

Just not quuite sure what im doing yet, cheers p

Adobe form Submission and retrieval in VB.Net App

2013-05-20T13:18:42.163-04:00

I am using the code below to retrieve XML data from an Adobe form submission, but I am unable to post the data to "test.xml".

When I display the URL of the incoming message using:,
Request.UrlReferrer.AbsolutePath.ToString()

I see:
URL: C:/Users/jmizrahi/AppData/Local/Temp/_14bs240bp2d3f55pk.pdf

It is Not an XML file as expected... On the Adobe form I use the "Http" Submit button... I assume that that is a a "POST". When I tried this using the "EMail" submit button, an xml file was generated and attached to an e-mail, I was able to open and examine the contents fine.

Would anyone be able to provide guidance or code examples that illustrate how to send an Adobe form and retrieve the form data?

Thanks!!!

Protected

Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If (Request.RequestType = "POST") And (Request.ContentType = "application/xml; charset=utf-8") Then
'load the posted xml file into the xmldocument object
Dim xdoc As System.Xml.XmlDocument = New System.Xml.XmlDocument()
xdoc.Load(Request.InputStream)
'save the xml file
xdoc.Save(Server.MapPath("c:/inetpub/wwwroot/test.xml"))

'load the xml file from the server and use it
xdoc.Load(Server.MapPath("c:/inetpub/wwwroot/test.xml"))

End If

create xml file from excel using C#.net

2013-05-20T07:32:29.177-04:00

create xml file from excel file using C#.net

Excel input:

Allproduct|Cat1|SubCat1|prod1
Allproduct|Cat1|SubCat1|prod2
Allproduct|Cat1|SubCat2|prod3
Allproduct|Cat1|SubCat1|prod4
Allproduct|Cat2|SubCat1|prod1
Allproduct|Cat2|SubCat1|prod2
Allproduct|Cat2|SubCat2|prod3
Allproduct|Cat2|SubCat1|prod4

Desire XML Out put:

<node Text="Allproduct">
	<node text="Cat1">
		<node text="subcat1>
			<node text="prod1"/>
			<node text="prod2"/>
			<node text="prod4"/>
		</node>
	       <node text="subcat2>
		        <node text="prod3"/>
	       </node>
	</node>
	<node text="Cat2">
		<node text="subcat1>
			<node text="prod1"/>
			<node text="prod2"/>
			<node text="prod4"/>
		</node>
		<node text="subcat2>
			<node text="prod3"/>
		</node>
	</node>
</node>

Formatting Excel (xlsx) columns to number with XSL Stylesheet.

2013-05-17T12:50:56.393-04:00

Hi Folks,

i have got a Ext.Net Web Application with an Excel (xlsx)export functionality, and would like to format some colums eg. A1 C1 H1 as a number, because all columns are represanted as strings.

here is my xsl-template:

<xsl:template match="/*">
    <Worksheet>
      <xsl:attribute name="ss:Name">
        <xsl:value-of select="local-name(/*/*)" />
      </xsl:attribute>
      <Table x:FullColumns="1" x:FullRows="1">
        <Row>
          <xsl:for-each select="*[position() = 1]/*">
            <Cell>
              <Data ss:Type="String">
                <xsl:value-of select="local-name()" />
              </Data>
            </Cell>
          </xsl:for-each>
        </Row>
        <xsl:apply-templates/>
      </Table>
    </Worksheet>
  </xsl:template>

thanx for your help

Andreas

Using value method with sql:variable in XQuery

2013-05-16T15:16:57.967-04:00

Consider the following element name and XML. I would like to get the value contained within the specified element:

declare @Element varchar(20) = 'Age'
declare @RequestXML xml

set @RequestXML =
'<Root>
  <UserDefined>
    <Age>21</Age>
    <MinDOB>01 Jan 1965</MinDOB>
    <MaxDOB>01 Jan 1995</MaxDOB>
    <EyeColour>Blue</EyeColour>
  </UserDefined>
</Root>'

The following retrieves the required value, however "Age" has been hard-coded here:

select @RequestXML.value('(//Age)[1]', 'varchar(20)')

Instead, I want the element to be defined dynamically using sql:variable("@Element"). However, the following results in an error:

select @RequestXML.value('//sql:variable("@Element"))', 'varchar(20)')

Msg 2370, Level 16, State 1, Line 16
XQuery [value()]: No more tokens expected at the end of the XQuery expression. Found ')'.

Can anyone please suggest a working solution?

json.net formating data

2013-05-16T11:42:47.94-04:00

Hi I need some help with Posting Data to JSON file. I have set up json.net and am parsing form values like so;

Account account = new Account
        {
            Name =  Request["Name"],
            Email = Request["Email"],
            Message = Request["Message"],
        };


        string json = JsonConvert.SerializeObject(account, Formatting.Indented);

        
        File.WriteAllText(@"C:\inetpub\wwwroot\JSON\dotNet5\test_file.json", json);

This outputs JSON ok!

{
  "Name": "ghghg",
  "Email": "hghg@ggfgdf.com",
  "Message": "hghgh"
}

What I need is the JSON to be written as below, adding jsonCallback( );

jsonCallback(
{
 "Name": "ghghg",
 "Email": "hghg@ggfgdf.com",
 "Message": "hghgh"
}

);

Ive not used json.net before so all help greatly appreciated, cheers P

Deny XML for users but not client-side

2013-05-11T13:15:38.383-04:00

Is it possible to deny a user to opent an xml file, but still let the user side be able to access the file through js/ajax?

I am making a multiplayer game and want xml to hold the data, but I dont want anyone accessing the file by knowing its url.

Constructing, Evaluating and Storing Rules Using XML and T-SQL

2013-05-14T09:07:37.977-04:00

Are there any existing examples or references out there of how one might be able to construct something to achieve the above? I would ideally like to write something where:

Data is supplied in XML format
Decisioning is highly configurable
One does not have to re-write SQL code to cater for new rules
Rules are evaluated in SQL only

The following link is an interesting read, however this is C# based: http://moustafarefaat.com/moustafapws/extxmlre.aspx

Are there any existing XML-based rule operators out there? Any pointers would be greatly appreciated!

xml and dtd

2013-05-06T11:39:21.983-04:00

hello to every one

i m working on xml dtd ..can any one told me

how to skip following line

and implment dtd rather than xsd (fro validation of xml) ..I made dtd which is some how working

2- apart from that i need to apppend dtd reference (<!DOCTYPE record SYSTEM my.dtd">)in my xml file ... ..

Pleaase help me ..do let me know when further expalantion is required..

Thanks

XML Read File Error

2013-05-10T15:47:40.7-04:00

Hi,

I have the following code,

Dim xmldoc As New XmlDocument()
        xmldoc.Load(Server.MapPath("~\export\LiStatus.xml"))

        Dim objNode As XmlNode = node.selectSingleNode("Identity/Type")


        If objNode IsNot Nothing Then

            If objNode.Value.ToString() = "500" Then
                '
            ElseIf objNode.Value.ToString() = "501" Then
                '
            End If
        End If

I get an error on 'node' on the following line:

Dim objNode As XmlNode = node.selectSingleNode("Identity/Type")

Any help appreciated.

How to store Excel file as XML and pass this XML to stored procedure?

2013-05-10T18:26:59.49-04:00

I want to read an Excel file and store the result as XML to a DataSet. I want to pass this XML data to stored procedure as a parameter.

How to Write XSL with Rowspan and bgcolor

2013-01-31T14:44:38.34-05:00

I need to create HTML file with a Table from XML file.

Table has 6 rows (Row 1 rowspan is 3, Row 4 rowspan is 3).

How to write xsl(v 1.0) to display first 3 rows bgcolor as gray & next 3 rows bgcolor as yellow then next 3 rows bgcolor as gray(if i've more).

If the first Row rowspan is 4, first 4 rows bgcolor as gray next four rows bgcolor as yellow.

Please advice

Linq to XML Issue

2013-05-03T00:21:06.197-04:00

I am passing an XML document to my stored procedure. Is there a way I can pass in the declaration as well? Right now I do a Stringbuilder and append the declaration first and then do a xmldoc.ToString() to pass in the whole thing. Is there a way to do just xmldoc.ToString() where it will know to include the declaration?

Linq to xml not working

2013-05-09T18:30:34.33-04:00

<TravelItineraryReadRS TimeStamp="2013-05-09T17:55:46" Version="1.1.1">
<Success/>
<TravelItinerary>
<PersonName NameNumber="01.01" NameReference="SCM0978-NA021215" RPH="1">
<GivenName>RESERVATION</GivenName><Surname>TEST</Surname>
<Email>test@test.COM?</Email></PersonName>
<Telephone AreaCityCode="BDL" PhoneNumber="7/732-555-0400" RPH="001"/>
<Telephone AreaCityCode="BDL" PhoneNumber="201-555-1350-B" RPH="002"/><Telephone AreaCityCode="BDL" PhoneNumber="201-555-4938-F" RPH="003"/>
<Telephone AreaCityCode="BDL" PhoneNumber="908-555-6400-C" RPH="004"/><Telephone AreaCityCode="BDL" PhoneNumber="732-555-0872-H" RPH="005"/>
<ItineraryInfo><ReservationItems><Item RPH="1">
<FlightSegment ArrivalDateTime="07-28T11:00:00" DepartureDateTime="2013-07-28T09:00:00" FlightNumber="0491" NumberInParty="01" ResBookDesigCode="Q" SegmentNumber="0001" Status="YK">
<OriginLocation LocationCode="EWR"/><DestinationLocation LocationCode="DTW"/><MarketingAirline Code="CO" FlightNumber="0491"/>
<UpdatedDepartureTime>07-28T09:00:00</UpdatedDepartureTime><UpdatedArrivalTime>07-28T11:00:00</UpdatedArrivalTime></FlightSegment>
</Item><Item RPH="2"><FlightSegment ArrivalDateTime="08-05T20:49:00" DepartureDateTime="2013-08-05T18:55:00" FlightNumber="0482" NumberInParty="01" ResBookDesigCode="Q" SegmentNumber="0003" Status="YK"><OriginLocation LocationCode="DTW"/><DestinationLocation LocationCode="EWR"/>
<MarketingAirline Code="CO" FlightNumber="0482"/>
<UpdatedDepartureTime>08-05T18:55:00</UpdatedDepartureTime>
<UpdatedArrivalTime>08-05T20:49:00</UpdatedArrivalTime></FlightSegment>
</Item><Item RPH="3">
<Hotel SegmentNumber="0002" Status="GK" Type="HHT">
<SpecialPrefs><Text>CF</Text></SpecialPrefs>
<RoomType RoomTypeCode="C2Q"/><RoomRate><Base Amount="69.00"/>
</RoomRate><GuestCounts><GuestCount Count="01"/>
</GuestCounts><TimeSpan End="08-05" Start="07-28"/>
<BasicPropertyInfo ChainCode="AA" HotelCityCode="DTW" HotelName="MARIOTT"/>
<Address><AddressLine>201 WESTFIELD</AddressLine>
<AddressLine>DETROIT MI 30293</AddressLine></Address>
<ContactNumbers><ContactNumber PhoneNumber="717-235-3333"/>
</ContactNumbers></Hotel>
</Item></ReservationItems>
<Ticketing RPH="01" TicketTimeLimit="T-"/></ItineraryInfo>
</TravelItinerary></TravelItineraryReadRS>

I am looking for AddressLine from Address and try to write query but it is not working.

 XDocument xdoc = XDocument.Load("hotelitinerary.xml");
 var hotels = xdoc.Descendants("Hotel");

Extracting escaped XML from encapsulated response

2013-05-09T11:44:36.943-04:00

We have a web service that returns encapsulated XML to a T-SQL stored procedure in the following format:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<soap:Body>
    <GetAddressResponse xmlns="http://tempuri.com/myWS/">
      <GetAddressResult><?xml version="1.0" encoding="utf-8"?><myWSCode><Result>AddressOK</Result></myWSCode></GetAddressResult>
    </GetAddressResponse>
</soap:Body>
</soap:Envelope>

I essentially want to select the following as an XML column:

<myWSCode>
<Result>AddressOK</Result>
</myWSCode>

The following link has got me most of the way there - http://stackoverflow.com/questions/4927300/sql-and-escaped-xml-data

select convert(xml, n.c.value('.', 'varchar(max)'))
from @xml.nodes('soap:Envelope/soap:Body/GetAddressResponse/GetAddressResult/text()') n(c)

However, this obviously does not process the namespace references correctly and results in the following error:

Msg 2229, Level 16, State 1, Line 38
XQuery [nodes()]: The name "soap" does not denote a namespace.

xml file not showing in xmldatasource

2013-05-08T16:15:22.52-04:00

I am creating my first app in asp.net.

I am trying to decide on which grid control to use and need to link a grid control to an xml file as a datasource. I put the xml file in the project folder. Using the wizard to bind the datasource, I select the 'Browse' button for the data file. I get the dialog box, Select XML File. On the left is the tree of my project. I have put the xml file in a couple of the folders and when I select the folder, the xml file does not appear. When I select 'all files', I can see the Default.aspx and Web.config file in the top folder.

How can I get the xml file to appear?

Thanks in advance.

Gloria

Google Base XML Consumption C# & Razor

2013-05-07T09:55:04.643-04:00

Hi All,

I'm trying to consume an xml feed based on the Google Base namespace. I keep getting an error regarding the g: on nodes.

Heres an example of the document:

<?xml version="1.0" encoding="UTF-8"?>
<feed xmlns="http://www.w3.org/2005/Atom" xmlns:g="http://base.google.com/ns/1.0" xmlns:c="http://base.google.com/cns/1.0">
  <title>Feed Title</title>
  <link rel="self" href="http://www.mydomain.local"/>
  <author>
    <name>My Google Base Feed</name>
  </author>
  <id>tag:mydomain.local,2013-05-05</id>

  <updated>2013-05-05T11:50:54Z</updated>

  <entry>
    <title>First Items Title</title>
    <summary><![CDATA[Text summary of item lisitng]]></summary>
    <id>ITD123</id>
    <g:image_link>exterior.jpg</g:image_link>
    <g:image_link>lounge.JPG</g:image_link>
    <g:image_link>kitchen.JPG</g:image_link>
    <g:image_link>bed1.JPG</g:image_link>
    <link href="http://mydomain.local/" />
    <g:location>London</g:location>
    <g:make>Ford</g:make>
    <g:model>Focus</g:model>
    <g:price>4995</g:price>
    <g:year>2012</g:year>
    <g:bedrooms>2</g:bedrooms>
    <c:type type="string">Hatchback</c:type>
    <g:condition>Second Hand</g:condition>
    <c:width>6'</c:width>
    <c:length>16'</c:length>
    <c:age></c:age>
    <c:condition>Excellent</c:condition>
    <c:exdisplay>False</c:exdisplay>   
      <c:regionName><![CDATA[London]]></c:regionName>
    <c:Postcode>EC1V</c:Postcode>    
  </entry>

Can any one suggest the best tool to get this data out? (So that I can store it in a SQL Db).

Thanks for any help :)

Jus

Parsing Json File

2013-05-06T11:33:27.29-04:00

hi,

I have a json file something similar to below.

{
"Users": [
{
"UID": "judyh",
"UUID": "UUID_001",
"Ustatus": "A",
"Lname": "HIGGS",
"NS": "16",
"Email": "judy.higgs@factiva.com",
"Account": "9ZZZ002000",
"Fname": "JUDY",
"AccCode": "0001"
},
{
"UID": "judyh",
"UUID": "UUID_002",
"Ustatus": "A",
"Lname": "HIGGS",
"NS": "16",
"Email": "judy.higgs@factiva.com",
"Account": "9ZZZ002000",
"Fname": "JUDY",
"AccCode": "0001"
},
],
"Action": "c"
}

I want to remove curly braces and get the data starting from SQuare brackets.

ALso i want to read "Action" which is "C" in this case but it may differ

Create XML file from existing DTD file

2013-04-30T05:41:50.73-04:00

I have a DTD file with some rules. Now i have to create an xml file based on this schema in VS 2012