My issue is i have some non standard XML and i need to tidy it before it can be parsed with an XElement.Parse(text) function the problem is that the source is as follows (just a sample, the entire file contains many items)
[Code]...
I have one large XML file from one of our vendor and I am trying to pars it using Linq but it looks some wrong logic I am using.
This is xml file:
HTML
<Psw xmlns="http://localhost">
<exid>20</exid>
<Mes><Me>
<doc><ps>
<ghder> .....
The code I am trying:
Dim doc As XDocument
doc = XDocument.Load(TextBox1.Text)
Dim qList = (From xe In doc.Descendants.Elements("ghder") _
Select New With { _
.mid = xe.Element("MId").Value, _
.cdate = xe.Element("cD").Value _
' As well I need to get the value for pn child attribute }).FirstOrDefault
MsgBox(qList.mid)
Error for DBNull ' Object reference not set to an instance of an object.
I would like to parse through and display and picture and description for each 'item' in an XML file. I can't figure out the image part, and I've only been able to concatenate the 'description' to display it:
[Code]...
I'm at the right elements in the tree; I can display the first picture, and I've been able to access all of the 'description' elements. But I need to have each 'item' element display together.
I need to get a list of the item id attribute in a soap packaged XML file, in the example below ref-2 ref-3, but I'm having a problem finding examples that work and not even sure where my attempt at a linq to xml statement is failing. Are there any good examples of parsing a XMLDocument in a SOAP envelope or am I just making this way harder than it needs to be.
[Code]...
I have a simple VB calculator app with a PrintForm procedure shown below which works fine on my Win7 machine but when I deploy the app to an XP Pro machine it produces artifacts from the MenuStrip where the Print command is executed. Any ideas why this would happen or how I can resolve it? I'm new to VB.net and OOP as a whole so if this is a simple problem.
[Code]...
A simple form with a combobox called Combo, drawing artifacts when using ComboBox with Custom Draw and the contents of the combobox is scrolled up or down, and with this source code, illustrates the issue:
Public Class Form1
Private Sub Combo_DrawItem(ByVal sender As Object, ByVal e As System.Windows.Forms.DrawItemEventArgs) Handles Combo.DrawItem
Dim Combo As ComboBox = TryCast(sender, ComboBox)
If Combo Is Nothing Then Exit Sub
If e.Index = -1 Or e.Index >= Combo.Items.Count Then
e.DrawBackground()
[Code] .....
I have an Excel 2007 workbook chock full o' VBA macros that do various things, including one that jumps from chart to chart making PDFs of each using PDFCreator, based on some code I borrowed from Ken Puls (url...).However recently I and some users of the workbook started having problems where the PDFs would be created with either gray image artifacts over the charts,or the whole chart image would have a double of itself skewed slightly. It just happens the problems started after we did a global upgrade to Office 2007, though I had had 2007 installed on my computer for a while and tested and used the workbook extensively without issue up until then. Here is the part of the code that automates the printing:
Sub PDF_print_all()
'Author : Ken Puls (www.excelguru.ca)
'Macro Purpose: Print to PDF file using PDFCreator[code]...
The problem is not consistent either... sometimes it will print to PDF with an oddly shaped block of gray, and sometimes it will only have the whole chart image doubled. The only consistency I could find is that sometimes if an object is selected in a chart beforehand (a text box, chart line, axis numbers, etc) the gray artifact will partly mimic the shape of whatever object had been selected.I wish I could include example images to show exactly what's happening.I know it's not a problem inherent to PDFCreator because if I manually print to it in Excel, the PDF image looks perfect. It's only when I use the automated method that the problem occurs, so I thought maybe it was the code.
I have the following list
[Code]...
I am trying to remove the Car node with ID = 1000, but i can't get it right Here is my Code, note that the debugger never hits e.Remove:
[Code]...
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()
I have a dropdownlist with some duplicate items on it. I intended to remove them by using LINQ, but do not know how to do it.
View 1 RepliesPublic Class GroupSelect
Public Property RowNo() As Integer
Get
[Code]....
I have a multi-client DB (multitennant) with several tables.Two of these tables are tblEmployees and tblTitles.Now I have a relationship from tblEmployees.empTitle to tblTitles.ttlID.That far everything is working.But now I have to make the application for multiple clients/tennants.So I added the fields tblEmployees.empClient and tblTitles.ttlClient and included them into the association.This works fine for reading and for setting the persons title as well.But if I try to remove the title (set it to NULL), SQL to Linq tries to modify both tblEmployees.empTitle and tblEmploy ees. empClient with is not allowed because tblEmployees.empClient is part of the primary key.And so I get the following error:[code]How can I tell SQL to Linq only to modify field tblEmployees.empTitle???
View 1 RepliesI'm using VB .NET and I know that Union normally works ByRef but in VB, Strings are generally processed as if they were primitive datatypes.Consequently, here's the problem:
Sub Main()
Dim firstFile, secondFile As String(), resultingFile As New StringBuilder
firstFile = My.Computer.FileSystem.ReadAllText(My.Computer.FileSystem.SpecialDirectories.Desktop & "1.txt").Split(vbNewLine)
secondFile = My.Computer.FileSystem.ReadAllText(My.Computer.FileSystem.SpecialDirectories.Desktop & "2.txt").Split(vbNewLine)
[Code]...
I would like to be able to parse vb.net code files, so I can examine the collection of Subs, Functions (and their contents, including comments), private variables, etc. I can be open the actual source code files. So for example, if I have:
[Code]....
I'm creating a vb.net winforms application that will take in user given strings, parse them, and print out labels with variable information. The given string will be used in all the labels, but the variable part of the string will change with each label.
My question is: is it better to parse the strings one time, then store those values in arrays, or to parse the string each time a label is printed? Which will perform better? Which is better practice? What is the proper way to test something like this?
I successfully wrote a code to retrieve a version number from a HTML page which is this:
<div class="header">Latest Version: <span class="version">6.59</span></div>
So the following code will return the version number which currently is 6.59 which is what I'm after. [Code] But then i remembered that releases are done as following: 6.59, 6.59b, 6.59c, 6.60, 6.60b etc. So when the b version of 6.59 is released the parser will still return 6.59. So how can i make this code better?
After countless hours of searching I have been unable to get this code to work. If anyone can provide we with an alternative. I know the easiest way is to use the Split() function but im trying to do an alternative method by identifying the spaces within the string and splitting them up.
I tried the search function, but to no avail.
Attached is the code.
CODE:
parsing a JSON from a URL... Using the Nascar JSON file I am trying to place it into a listview or treeview. Displaying the drivers name, number and current position.
[Code]...
I'm trying to find a way to parse a string which looks like this:
1,394,7,0,0,0,0,0,,0,0,63,85,0,,0,0/2,595,59,8,0,0,0,0,0,,,0,0,,0,8,6,0/3,696,0,0,0,0,,,0,0,,84,0,0/#
So that it only reads the first two digits, then delete everything after that till it reads a "/", read the first two digits and delete everything up to the "/" again.This would result in this:
1,394
2,595
3,696
I don't know how to remove every character after the last of the first two digits up to the first / it reads, can anyone help me with that?How can I parse this code easily?
I have a large XML database of song files. I basically want to parse this into a listview with two columns. "Artist" and then a subitem of "Song"
And example of one <song></song> section of the database is:
Quote:
<Song FilePath="C:UsersAdamDownloadsSusan Boyle - I Dreamed A Dream CDRip 2009 [Cov+CD][Bubanee]�7. Up To The Mountain - Susan Boyle.mp3" FileSize="5900603">
<Display Author="Susan Boyle" Title="Up To The Mountain" Album="I Dreamed A Dream"
[Code].....
Then put Author in the Item and Title as a subitem. How would I go about doing this on startup to a database that has thousands of songs?
i have managed to make an application to get print logs from the print server 2003, But now we have changed it to 2008.get print logs from windows 2008 server.i have activated the print loges from service manager -> diagnostics -> application and service logs-> microsoft ->windows ->print service and enabled the logs.using
Dim
EvntLog1() As EventLog = EventLog.GetEventLogs(My.Computer.Name)
For dhi
As
[code]....
i can get some process but i am not sure how to get the printer logs from windows server 2008?
i am getting a piece of text from a webpage, but i would like to only let the text after a $ to show up?
View 1 RepliesI need to convert a string such as "01h45m" into a TimeSpan. I know I can split the string apart to get the numbers, just looking for something more elegant...
View 2 Repliesi need help parsing html using regex..i am hardly find the exact expression to use.
[Code]...
I am reading from an IO.port and returning the data to a string. I need to parse this to data rows that each represent a data record which I will add to a datagridview.
The data basically looks like this. I have inserted <SOH>,<US>, etc. for readability.
[Code]...
I have the html of a page loaded into a string.
confirmUse('??????','Eat'
I want to extract the number that the ?'s represent however confirmUse is used in other parts of the page. The only constant is the 'Eat' which is unique to this specific number.
I usually use Mid and Instr to find what I need but when I try to back track it gives me an error because the index number is below 0.
Is it possible to collect data in this page with table. link here Is t possible to collect and view the data from tables into a ListView control in winForm?Instead of viewing page in webbrowser. i just want to use listview.I found klienma's thread in codebank but i could find a way how to parse table data form the web page.
View 5 RepliesIm trying to parse a log file and display the data in a textbox.The log is forever changing so it will have to be some kind of a loop.I only want the new data to be added to the textbox after the application is running, not the contents already in the log file.
View 1 RepliesIm trying to parse a log file and display the data in a textbox..The log is forever changing so it will have to be some kind of a loop.I only want the new data to be added to the textbox after the application is running, not the contents already in the log
View 5 Replies[code]The two parts I've coloured red change, I need to grab the first part which is the link but I'm not sure how to do this. I've used regex before and it doesn't look possible to use it on this on this, there's about 25 of these in the source.
View 11 Replies