Using LINQ To XML With Global Namespace - Xmlns Is Added To Each Non-data Element?
Jan 14, 2010
I have to create an xml doc for a vendor who specifically states they must have their xml as follows:
<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<WMWROOT xmlns="http://www.blahblah.com/BLAH/Interface">
<WMWDATA>[code].......
I cannot find a way to get LINQ to spit out xml the way they want. Question is, can LINQ do it or do I need to resort to hardcoding the xml the old way before LINQ to XML?
View 5 Replies
ADVERTISEMENT
Jul 31, 2010
I am trying to use xml documents to store data for a movie database, but am having an issue
here is the code I am using
Imports <"...movies.xml">
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
[Code]....
Why do I get that xmlns = "" in the movie parent node?
Of I remove the parent node from the movieAdd variable it puts xlmns = in all the nodes
View 3 Replies
Jan 23, 2012
I have three tables: BOOKS(BookID, Title, Author) CLASSES(ClassID, Title, MajorID,BookID) and MAJORS(MajorID, Description). I added these three tables to a LINQ to SQL class (UBooks.dbml) and then connected to the data sources. Then declared DataContext.
Using LINQ, my goal is to display all books in a grid which I have done with:
Dim allBooks = From Books In db.Books _
Order By Books.BookID _
Select Books
Me.BookBindingSource.DataSource = allBooks
Next I need to display all majors in a listbox. I would like the description to be shown however I am only getting the majorID to display with the code
lstMajors.DataSource = db.Majors
I have tried db.Majors.Description, however I am told then that Description is not a member of the LINQ table. and my final goal is to display all the books for whichever Major is selected in another data grid. This is what I am primarily concerned with right now. When using the SQLClient classes, I was able to create a string joining the tables (also had the description properly showing in the listbox, but that is of little importance right now to me). In the video tutorials I was able to watch whenever the tables were dragged from the database into the OR designer of the LINQtoSQL.dbml class file all of the associations were already there and the narrator only really had to do some drag and drop. Not only is drag and drop not working without these associations, but I'd much rather learn the code behind it.
View 4 Replies
Mar 2, 2010
Scenario:A widget developer codes using HTML and javascript.my vb.net application allows developers to create widgets for other users.in javascript you can call window.external to comunicate with the host windows scripting object and I would like to add a helper namespace with many functions to aid the development of widgets similar to windows sidebar's System namespace.
Problem:So I could allow developers to use Window.External.System but how can I just allow them to access System directly without using Window.External?Microsoft adds a System Namespace to windows sidebar gadgets host window which is just an internet explorer server window.
View 1 Replies
May 4, 2010
I have done edit and remove and create xml but there is one problem adding.
Public Sub Add()
Dim xLabResults = New XDocument()
xLabResults = XDocument.Load(frmMain.xLabResultXmlPath)
[code]....
It does add but there is unnecessary xmlns="" on the add node, and ofcourse error reading it thus ignored when I read the xml.
dp.SyntaxHighlighter.ClipboardSwf = '/dp.SyntaxHighlighter/Scripts/clipboard.swf'
dp.SyntaxHighlighter.HighlightAll('73c54fd0ff56414895293ae2ac3c2a3e')
View 7 Replies
Dec 4, 2009
Which is the best way to store global variables, in My.Settings or My.Namespace. The reason I ask is because I need to know certain boolean values if certain forms are open from other forms. At present I am defining Global Boolean variables in My.Application, which give the result I require.
View 3 Replies
Sep 27, 2010
I have a solution that contains many projects all using the same root namespace. No code files explicitly name a namespace. So lets say the root namespace is ExampleRootNamespace.Now a problem comes into play when I want to add an explicitly named namespace to one of the code files I am working on. I want to be able to isolate this code from the rest of the assembly to be able to run FxCop against it. So I add something like Namespace Interfaces.CSV to the code file.
This causes any code that references this assembly to need to say Imports ExampleRootNamespace.Interfaces.CSV. So far so good. I can even run FxCop against the assembly. The problem now is that in other assemblies I cannot say any longer things like:
Public class frmInputBoolean Inherits
ExampleRootNameSpace.frmFormTemplate
Visual Studio is now asking me to rename the namespace to:
Public class frmInputBoolean Inherits
Global.ExampleRootNameSpace.frmFormTemplate
There are hundreds of errors related to this. So my questions are:
1) Why would basically naming a namespace under the root for the first time cause issues with the program?
2) Are there any workarounds to this issue without renaming?
I also want to add that with regards to ExampleRootNamespace.Interfaces.CSV I am not referencing this anywhere in the codebase. I'm currently just referencing it from a unit test project. So I don't see why adding this namespace causes an issue.
View 2 Replies
Sep 27, 2010
I am working on a solution that does not name namespaces in code files. Instead it uses the root name space of the project (which is the same across all assemblies). Basically there is only one implicit namespace.
Well, I am trying to isolate some code so that I can run FxCop against it. I explicated named the code file with a namespace to do this. This works for FxCop, but it bricks the entire solution.Visual Studio is now asking me to prefix all uses of the implicit namespace with Global. So instead of:
[Code]...
View 1 Replies
Jul 13, 2009
Dim hDoc As HtmlDocument
Dim tEle As HtmlElement
Dim tEleOption As HtmlElement
[code].....
View 5 Replies
Mar 3, 2011
I would like the following function to return Nothing if the element with the specified key is not in the collection. Instead, it returns an error - something to the effect of "no element found"
Public Class MyCollection
Inherits System.Collections.ObjectModel.Collection(Of MyType)
Public Function FindByActivityKey(ByVal searchValue As Integer) As MyType
[code]....
View 1 Replies
Jan 27, 2011
We are doing a query against an in-memory collection of LINQ data objects. The wrinkle is that we are ordering by a column in a related table whose records have not necessarily been loaded yet (deferred loading:)
Dim oPkgProducts = _
From b In oBillPkg.BillProducts _
Where b.Successful.GetValueOrDefault(Common.X_INDETERMINATE) = _
[code]....
View 1 Replies
Jan 13, 2011
I have been given the task of calling a web service which returns an xml data feed which I am doing like so;
For Each r As DataRow in SomeDataTable
Dim msFeed As String = string.format("http://some-feed.com?param={0}", r!SOME_VAL)
Dim x
[code].....
View 4 Replies
May 30, 2012
I am working on a realtime application where the data is addded to a List(of T) all the time. MB per minute
Elements older than X minutes shall be removed from the beginning of the list to free memory.
As far as i can understand will there be an internal (slow) redim when i add each element after i have reach the number defined with the Capasity metod. (I set that quite big from the start, but the data speed is unpredictable so it can be exceed)
What happens each time i remove and element from the beginning of the list , seems like it takes a lot of time, ? new redim ?
What is the most CPU fficient way of removing 1 or many elements from the beginning of such a list?
View 7 Replies
Apr 14, 2011
The XML sample below has two records and each record has three similar Nodes (<datafield tag="500" >) What I want to accomplish is get the value of the second Node <datafield tag = "5000">. The fallowing code I gets the value for all three nodes but I want something like get elementat(1). I tried this but it didn't worked MsgBox(xEle.Elements.ElementAt(1).Value)
Code:
Dim xd As XDocument = XDocument.Load("C:UsersstopeteDesktopMarc_convertxml.xml")
If xd IsNot Nothing Then
Dim datafields = From datafield In xd.Descendants("datafield")
[code]....
View 2 Replies
Oct 26, 2008
I am using VS 2008 but am having problems getting the namespace system.xml.linq to be recognized. I am attempting to add the reference but I don't seem to be be allow to select it.System.XML.Linq is grayed out in the AddReference menu. What must I do to add this reference to my project?
View 3 Replies
Aug 6, 2010
I'm trying to grasp the linq to xml 'inline query syntax' features of VB.Net First I tried with this simple xml file:
<?xml version="1.0" encoding="utf-8" ?>
<Root>
<Child Name="somename">
[code]....
This xml, when loaded in an XDocument, can be loaded and queried as follows:
Dim xdoc = XDocument.Load("sample.xml")
Console.WriteLine(xml.Root.<Child>.@Name)
Then I change the <Root> element in the sample xml file to:
<Root xmlns="http://SomeNamespace">
Now I can't seem to use the convenient 'Axis Properties' syntax anymore... I can only get it to work with the explicit XElement syntax:
Dim ns As XNamespace = "http://SomeNamespace"
' works, but I would like to use the same syntax as above...
Console.WriteLine(xdoc.Descendants(ns + "Child").First().Attribute("Name").Value)
View 1 Replies
Mar 5, 2012
I have 290 Group Policy Backup xml files which I need to enumerate in separate folders.
With each Group Policy backup xml file, I need to query the Policy settings.
Anyone who's looked at a Group Policy xml backup file before would know they're chock-a-block full of Namespace declarations.
I want to know, using Linq to XML, as I query each xml file, how can I dynamically query the XML the Namespace and then append the Namespace into the Linq query for the child nodes/values?[code]...
View 3 Replies
Feb 28, 2012
How do I work out what the namespace declaration is for the Extension node?I want to return all of the child nodes under: GPO->User->ExtensionData->Extension..[code]I get the following error: Sequence contains no elements..Also, the XML sample I have provided is only a small snippet, the ExtensionData->Extension nodes can be nested in different areas, so I was hoping to find the way of specifying the full path.
View 2 Replies
Mar 15, 2010
I'm adding an element to existing XML doc with the following code:
Dim theXMLSource As String = Server.MapPath("~/Demo/") & "LabDemo.xml"
Dim nodeElement As XElement
Dim attrAndValue As XElement = _
[code]....
It makes error like this:
System.NullReferenceException: Object reference not set to an instance of an object.Object reference not set to an instance of an object.Error line: nodeElement.Add(New XElement(attrAndValue))
View 4 Replies
May 13, 2010
Please excuse my stupidity, I tend to find the traversing XML overly complicated.
[Code]...
Once it gets to staffBio I get an error saying "Object reference not set to an instance of an object." obviously because that node does not exist. My question is how can I assign the value to a variable even when it is empty without having to do a conditional check before each assignment?
View 2 Replies
Mar 15, 2010
I'm editing XML element with the following XML:
<?xml version="1.0" encoding="utf-8"?>
<!--Test XML with LINQ to XML-->
<LabSerivceInfo><LabService>
<ServiceType>Copy</ServiceType>
<Price>1</Price></LabService>
[Code] .....
How to update the ServiceType and Price where ServiceType = varServiceType?
View 2 Replies
Nov 12, 2009
Using VB.NET (3.5), i have an ArrayList of Employees. I'm trying to build an XML representation (to feed another system) and one of the fields is a simple incrementing ID, starting at 1.[code]...
View 1 Replies
Feb 25, 2011
Just playing about with LinqToXml and I need to form a xelement as follows:
Dim xe As XElement = _
<Xml>
<ElementOne>
<SubElement></SubElement>
<SubElement></SubElement>
[Code]...
This creates an error here: xsi:type "XML namespace prefix 'xsi' is not defined"
Is it possible to write this in Linq to xml?
View 1 Replies
Oct 28, 2010
Using the XML elements below, I am trying to locate all table elements where they have a column@Name equal to a specific item such as "email" and return the Database@Location and Table@Name. My LINQ statement returns the proper table@name but for each element found returns the first database@Location for both. So my question is, how can I search for a column@Name and return the proper Database@Location and Table@Name [Code]
View 1 Replies
Mar 15, 2010
I'm trying to update an element in the XML document below:
Here's the code:
Dim xmldoc As XDocument = XDocument.Load(theXMLSource1)
Dim ql As XElement = (From ls In xmldoc.Elements("LabService") _
Where CType(ls.Element("ServiceType"), String).Equals("Scan") _
[code]....
But, I got this error message:
Object reference not set to an instance of an object.Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.Error line:ql.SetValue("23")
View 1 Replies
May 13, 2009
I'm a bit of a LINQ newbie and I was having some trouble with the following. I'm trying to perform a query using LINQ on an XML file and store the results in a list of DataClass objects that match the XML.I've got an XML file that is defined like this:
<NewDataSet>
<NewDataTable>
<Field>Accepted ASNs</Field>
<Val>59</Val>[code]....
I have created a Data class to support this XML format. What I would like to do is create a LINQ Query to grab these 3 records and store them into a List of my DataClass. In order to support multiple Order elements, I have my class defined with a generic list of "Order" structs... It looks like this:
Public Class ASNData
Private _field As String
Private _value As String[code].....
how to grab the 3 order elements and store them into my list of Order structs.
View 4 Replies
Apr 15, 2011
It has two records and each record has three similar Nodes (<datafield tag="500">). What I want to accomplish is get the value of the second Node <datafield tag = "5000">. The following code I gets the value for all three nodes but I want something like get elementat(1).I tried this but it didn't worked.
MsgBox(xEle.Elements.ElementAt(1).Value)
Dim xd As XDocument = XDocument.Load("C:UsersstopeteDesktopMarc_conv ertxml.xml")
If xd IsNot Nothing Then
Dim datafields = From datafield In xd.Descendants("datafield")
Where (datafield.Attribute("tag").Value = "500")
[Code]...
View 2 Replies
Apr 19, 2011
I have a XML xElement like[code]...
In order to get rid of Trick nodes where value is null, I wrote:
myXmlElement.<Play>.<Trick>.Where(Function(m) m.<Trick>.Value = "").Remove()
View 4 Replies
Nov 21, 2011
I use Excel PIA thru "Imports Excel = Microsoft.Office.Interop.Excel". IDE allows to set "global" reference for any namespace (in Project -> 'Project name' Properties -> References). But it doesn't allow to set alias for this namespace, so I have to write "Imports Excel = ..." thru all files where I need it. This would be great to have such thing in IDE!
View 3 Replies
Nov 27, 2010
I have two module-level variables and Linq query. I want the results of the Let clause to change the global variables - is this possible?
For example:
Dim X As Integer = 0
Dim Y As Integer = 0
[code].....
View 3 Replies
