|
Hi All
I am making a string from dataset and then converting to xml.while converting its giving me error unexpected symbol "=" at location
For Each row In dsGetBVItemDetails.Tables(0).Rows
strxmlString += _
"<ItemDetails>" & _
"<Item code=" + dsGetBVItemDetails.Tables
(0).Rows(i)(0).ToString() + ">" & _
"<Description>" +
dsGetBVItemDetails.Tables(0).Rows(i)(1).ToString() + "</Description>" & _
"</Item>" & _
"<ItemQty>" + dsGetBVItemDetails.Tables
(0).Rows(i)(2).ToString() + "</ItemQty>" & _
"<Message>" + dsGetBVItemDetails.Tables
(0).Rows(i)(3).ToString() + "</Message>" & _
"</ItemDetails>"
i = i + 1
Next
It is giving error while converting only when adding attribute "code" in element Item pls suggest
and then converting like this
XFinalXML = XElement.Parse(strxmlString.ToString())
xmlResponse = XElement.Parse(XFinalXML.ToString())
xmlResponseDoc = New XDocument(xmlResponse)
schemaResponse.Add(Constants.TARGETNAMESPACE, AppDomain
.CurrentDomain.BaseDirectory & "Schema\" & Constants.GetBVItemsResponse)
nsResponse = xmlResponseDoc.Root.Name.NamespaceName
Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"
|
|
|
|
|
Are you adding double quote characters around the attribute value that follows "<Item code="? You can check this by looking at the generated string in your debugger.
The best things in life are not things.
|
|
|
|
|
yes below is my code
For Each row In dsGetBVItemDetails.Tables(0).Rows
strxmlString += _
"<ItemDetails>" & _
"<Item code=" + dsGetBVItemDetails.Tables
(0).Rows(i)(0).ToString() + ">" & _
"<Description>" +
dsGetBVItemDetails.Tables(0).Rows(i)(1).ToString() + "</Description>" & _
"</Item>" & _
"<ItemQty>" + dsGetBVItemDetails.Tables
(0).Rows(i)(2).ToString() + "</ItemQty>" & _
"<Message>" + dsGetBVItemDetails.Tables
(0).Rows(i)(3).ToString() + "</Message>" & _
"</ItemDetails>"
i = i + 1
Next
Ankit Aneja
"Nothing is impossible. The word itself says - I M possible"
|
|
|
|
|
No, you're not. The resulting string code should be closer to:
<Item code=""" + dsGet... + """>" & _
But, you shouldn't even be doing it this way. You're code is nearly impossible to read and makes it very difficult yo see what's going on. Look at my other reply.
|
|
|
|
|
To add to Dave's comments, you have ignored my suggestion and merely reposted the original code, minus the <pre> tags, so it's almost impossible to read. And it obviously does not include the double quotes; had you used your debugger you would have spotted that fairly quickly.
The best things in life are not things.
|
|
|
|
|
You're missing quotes around the value for code.
Concatentating string together to build an XML document is doing it the hard way and it's less forgiving of typos and invalid characters in the contents.
You might want to look into building it this way:
Dim xml As New XDocument
xml.Declaration = New XDeclaration("1.0", "utf-8", "yes")
Dim rootNode As New XElement("RootNode")
For index = 1 To 3
rootNode.Add(<ItemDetails>
<Item code=<%= index %>>
<Description>Some description text <%= index %></Description>
</Item>
<ItemQty><%= index %></ItemQty>
<Message>Item Message <%= index %></Message>
</ItemDetails>)
Next
xml.Add(rootNode)
Debug.WriteLine(xml.ToString)
Notice that any values are automatically put into quotes when needed. Plus, you get full Intellisense support and syntax checking in Visual Studio 2010.
|
|
|
|
|
Hi Every body...VANAKKAM..( good morning or afternoon or evening in Tamil Langauge)..I want to learn the basiclogic to create my own user control.
Please Guide me..
Selvaraj.G
|
|
|
|
|
In the IDE create a new User Control. Add controls to it and make sure all settings you require are persisted. Apart from that it's the same as creating a form.
You'd be better off learning how to create a controls in a language that hasn't been deprecated and is still supported. Move to .net; C# or VB.net.
Panic, Chaos, Destruction. My work here is done.
Drink. Get drunk. Fall over - P O'H
OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
I cannot live by bread alone. Bacon and ketchup are needed as well. - Trollslayer
Have a bit more patience with newbies. Of course some of them act dumb - they're often *students*, for heaven's sake - Terry Pratchett
|
|
|
|
|
In the name of all that is holy, do not learn VB6.
Nobody uses it.
Switch to VB.Net.
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC Link[ ^]
Trolls[ ^]
|
|
|
|
|
Hello every1
i want to make a program with vb2010 that can compare a wav file with a realtime recorded voice from microphone and triger something (lets say that a msgbox appear)if the microphone msg is closed to the recorded from a wav.
thnx in advance
speedydc
|
|
|
|
|
You'd have to do something along the lines of a sliding window Fast Fourier Transform or Discreet Fourier Transform on both sets of data. There are a couple of problems with this as you'll have to account for differing sample rates of your WAV file and the samples coming from the mic.
You might also want to look into Hidden Markov Models as they tend to be a bit more forgiving in the sample rate differences.
Good Luck!
|
|
|
|
|
Is it possible to copy a file to a destination that includes a shortcut link in the path? For example, below the \Staged\ is actually Staged.LNK that points to a diff. server. I normally would use the UNC path but am being asked to do this specifically. User has full rights on the directory as well.
<br />
'Statement fails.<br />
System.IO.File.Copy("\\Server\Data Dumps\86355 - Shipment Notice Detail 07.18.2011 11.15.15.108.xml", "C:\Documents and Settings\John Doe\Desktop\Staged\86355 - Shipment Notice Detail 07.18.2011 11.15.15.108.xml")<br />
<br />
'If I add-in Staged.LNK, the statement fails, without .LNK, VB creates an actual folder called Staged and copies the file into that folder vs. using the shortcut path (to a diff. server).<br />
My.Computer.FileSystem.CopyFile("\\Server\Data Dumps\86355 - Shipment Notice Detail 07.18.2011 11.15.15.108.xml", "C:\Documents and Settings\John Doe\Desktop\Staged\86355 - Shipment Notice Detail 07.18.2011 11.15.15.108.xml")<br />
Thanks for any help or comments.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
Jon_Boy wrote: Is it possible to copy a file to a destination that includes a shortcut link in the path?
No, since the .lnk is a file, not a virtual path. The file-system treats it as a file, not as a NTFS Junction Point[^].
As an alternative, you can use VB.NET to read what the .lnk file is pointing to, and concatenate that to your path. You'd need to import a COM-library called "Windows Script Host Object Model", then you could run code similar to this;
Imports IWshRuntimeLibrary
Module ShortcutExample
Sub Main
Dim MyWshShell = new WshShell()
Dim MyShortcut = MyWshShell.CreateShortcut("C:\Users\Eddy\Desktop\SomeFolder.lnk")
Console.WriteLine(MyShortcut.TargetPath)
Console.ReadKey()
End Sub
End Module
Happy Programming 
Bastard Programmer from Hell 
|
|
|
|
|
Sounds like a plan. Thanks!
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
You're welcome
|
|
|
|
|
Hello.
I am using VB 2010 under Windows XP to create a MDI Windows Form
application. Question : is it possible to change the color or the title bar
and of the border of the children forms, form by form ?
modified on Monday, July 18, 2011 7:27 AM
|
|
|
|
|
Only if you draw the ENTIRE form yourself. What you're doing is drawing whats called the "non-client" area. This means you'll have to override the WndProc method and handle, at a minimum, the WM_NCPAINT message. This tells your code to paint its non-client area. The form properties won't do you much good here are they only specify the client area dimensions and settings.
Docs on the WM_NCPAINT message[^].
|
|
|
|
|
|
Sure. Most will allow you to change the form borders. How you do that depends on the library you chose.
|
|
|
|
|
I posted this in quick questions but didn't get any satisfactory response. I'm new here and don't know if it's possible to move my question here so I guess I'm guilty of cross posting. Admin - If you delete, could you delete my other post rather than this one please? Anyway - to my question.
Attempting to read from serail port, XP, admin accnt.
if there are chars in the buffer, then the following throws error: Permission denied, code: 800A0046 on the check of AtEndOfStream.
forRead=1
Set fso = CreateObject("Scripting.FileSystemObject")
Set comObj = fso.OpenTextFile("COM3:9600,N,8,1", for Read)
if not comObj.AtEndOfStream then
msgbox comObj.ReadLine
end if
com.Close
Writing on the other hand works just fine with the following:
forWrite=2
Set fso = CreateObject("Scripting.FileSystemObject")
Set com = fso.OpenTextFile("COM4:9600,N,8,1", forWrite)
com.Write "Hello World"
com.Close
Not sure its relevant but I'm using com0com to connect the two ports (3 & 4)
I should perhaps also add that using the MSCOMM obj in VB6 I can read and write no problem.
Any ideas why the permission denied for the read.
Thanks
modified on Saturday, July 16, 2011 5:42 AM
|
|
|
|
|
Don't cross post. You didn't wait long enough before posting this question yet again.
|
|
|
|
|
Hi Dave - A thousand apologies. I did try to explain that I felt I'd probably posted in the wrong place first. If I could live my life over I'd have posted it here first. I'll hopefully live and learn and try to become a better person (but being the wrong side of 50 I fear it may be too late for me). Please feel free to delete my first post or my second post or both whichever you feel is for the best.
|
|
|
|
|
Can't figure out how to code web browser with advanced tabs. And suggestion?
|
|
|
|
|
What have you tried so far? Where are you stuck?
|
|
|
|
|
I have tried using ToolStrip, but can't seem to get the coding right.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
