Visual Basic

How do i load xml file into memory for parsing

16-Apr-09 0:50

CPallini wrote:
BTW2: never heard about combinatorial explosion? [^]

Thanks for that. I'd done some studying about factorials, and the nCr button on my calculator, but didn't know the proper name for it

Update records

mansi368715-Apr-09 21:20

mansi3687

15-Apr-09 21:20

I m Using Vb 6.0 and access.I have more then 1000 records in particular table,now i wmat to update 2 to 3 rows only in that table,then how can i update without loading or updating all records?I m using VSFlexgrid for displaying data.

Re: Update records

Henry Minute15-Apr-09 23:58

Henry Minute

15-Apr-09 23:58

Does not Access SQL have a Select statement?
I haven't used Access for years, but from memory it always used to.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Update records

Johan Hakkesteegt16-Apr-09 0:18

Johan Hakkesteegt

16-Apr-09 0:18

Tip: try not to mention that you are using vb6 on this forum.

Like with any database, you can write code in your application that executes an SQL statement.

You just build your update statement in the code, something like:

Dim dbConn As Connection
Set dbConn = New Connection
dbConn.CursorLocation = adUseClient
dbConn.Open "Your connection string here"
Dim MyNewValue As String
Dim SomeValueThatIdentifiesWhatRowToUpdate As String

MyNewValue = "blablabla"
SomeValueThatIdentifiesWhatRowToUpdate = "more blablabla"

dbConn.Execute ("UPDATE MyTable SET MyField='" & MyNewValue & "' WHERE MyOtherField='" & SomeValueThatIdentifiesWhatRowToUpdate & "' ")

Or something along these lines.

My advice is free, and you may get what you paid for.

kryan015-Apr-09 11:09

kryan0

15-Apr-09 11:09

I want to load an xml file into my program then extract data from it into text boxes. For loading purpose I would like to be able to have something that looks like the open file dialog. So that I can select different xml file each time load it into my program have it take the layout I would like be able to alter any text then save the alteration and print it out.

Re: How do i load xml file into memory for parsing [modified]

0x3c015-Apr-09 11:43

15-Apr-09 11:43

Are you using VB or VB.Net?

VB.Net:
Use an OpenFileDialog, use System.Xml.Linq.XDocument.Load(filePath) to get an XDocument and then recursively get every node. If it has child nodes, recurse further. If not, write the child node text somewhere. To save it, just save the XDocument, and have any editing alter the XDocument itself

So, in summary

Load:
OpenFileDialog. Get filename
System.Xml.Linq.XDocument.Load(FileName)
Get every node
If node has child node: go to previous instruction
Else: write node details

Editing node:
Alter XDocument itself

Saving:
XDocument.Save

VB[1-6]:
Interface with COM. I can't help you here

modified on Thursday, April 16, 2009 6:50 AM [Needed to clarify]

kryan015-Apr-09 12:03

kryan0

15-Apr-09 12:03

i am using visual studio 2008 express edition vb
thanks for the info i will have to try that

Christian Graus15-Apr-09 19:16

Christian Graus

15-Apr-09 19:16

Is XDocument a DOM implimentation ? What does it offer over the non LINQ DOM class ?

Christian Graus

Driven to the arms of OSX by Vista.

"I am new to programming world. I have been learning c# for about past four weeks. I am quite acquainted with the fundamentals of c#. Now I have to work on a project which converts given flat files to XML using the XML serialization method" - SK64 ( but the forums have stuff like this posted every day )

Johan Hakkesteegt16-Apr-09 0:28

Johan Hakkesteegt

16-Apr-09 0:28

Probably not much that actually matters, but LINQ exposes the xml document's structure and tags to Visual Studio's intellisense. In other words, it makes writing code for a specific xml structure easier for he developer.

My advice is free, and you may get what you paid for.

0x3c016-Apr-09 0:47

16-Apr-09 0:47

Not really that much in all honesty, but it makes XML a lot easier. It works with LINQ far more easily, which is useful if he ever wants to apply the principles to other projects. I'm not certain, but going by this link, it doesn't the XDocument class doesn't appear to be DOM (to be precise, the Remarks and Examples sections imply this). Also, an XElement doesn't require creation from an XDocument, which doesn't tie it down to one particular XML file

VB.NET 2008 Subreport Cannot Be Shown

kryan016-Apr-09 8:29

kryan0

16-Apr-09 8:29

ok here is my code for loading the file
<pre>Imports System.Xml.XPath
Imports System.Xml.Linq
Imports System

Public Class Form1

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Dim xmldoc As XDocument = XDocument.Load("OpenFileDialog1.FileName")
Dim
OpenFileDialog1.Filter = "Xml (*.xml)|*.xml"
OpenFileDialog1.ShowDialog()
System.Xml.Linq.XDocument.Load(OpenFileDialog1.FileName)

End Sub

End Class </pre>

How do i load node text into text box from here

a simple xml file for testing here person.xml

<pre>
<xml version="1.0" encoding= "utf=8"?>
<Person>
<FName>Keith</FName>
<LName>Ryan</LName>
</Person>
</pre>

thanks

DaveMcTKD15-Apr-09 9:37

DaveMcTKD

15-Apr-09 9:37

I have searched for answers on the web, have some good suggestions but they do not seem to fix my problem.
On a web form, I have a report with a sub-report. No matter what I do, I get the error message "Error: Subreport could not be shown."
I can run the subreport as a main report on another page, and it works fine.
I found elsewhere that I have to add a handler for the subreportpreocessing event, and have done so but it does not get called when I step through the code.
Below is some code for the events that lead up to the problem:

==========
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim JobAppID As Integer = Val(Me.DDL_JobAppID.SelectedValue) 'For main report parameter
Dim params(0) As ReportParameter
Me.ReportViewer1.LocalReport.ReportPath = ".\admin\employmentapplicant.rdlc"

AddHandler ReportViewer1.LocalReport.SubreportProcessing, AddressOf SubreportDatabind

params(0) = New ReportParameter("vJobAppID", JobAppID, False)
Me.ReportViewer1.LocalReport.SetParameters(params)
Me.ReportViewer1.LocalReport.Refresh()
'End If
End Sub

Public Sub SubreportDatabind(ByVal sender As Object, ByVal e As SubreportProcessingEventArgs)
Dim MyReportDataSource = New ReportDataSource("DS_References", Me.DS_References)
e.DataSources.Add(MyReportDataSource)
End Sub
==
Also, in the .aspx file I have tried both with and without the following:<LocalReport ReportPath="Admin\EmploymentApplicant.rdlc" OnSubreportProcessing="SubreportDatabind">

Help would be appreciated!!

Dave McDonald
Web Developer

Re: VB.NET 2008 Subreport Cannot Be Shown

Dave Kreskowiak17-Apr-09 4:37

Dave Kreskowiak

17-Apr-09 4:37

Well, I haven't used ReportViewer and don't do ASP.NET apps, so my experience is quite limited.

But, from what I can see, everything looks OK. The only question I have is what does the code look like that defines and sets up "MyReportDataSource"? Is this the same source used for the parent report??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Seeking recommendations for PDF Merge Library

Kschuler15-Apr-09 4:12

Kschuler

15-Apr-09 4:12

I've got a project that requires merging of several PDF documents into one PDF document. From my research, it is my understanding that this cannot be done without a third party component or library.

Our current plan is to run the merge on a web service call, however we are interested in exploring the costs of using the component in a PC program deployed to our users. It needs to work for .Net 2.0 or higher.

Does anyone have any recommendations for a good one? And/or one that isn't too costly?

Re: Seeking recommendations for PDF Merge Library

Steven J Jowett15-Apr-09 23:39

Steven J Jowett

15-Apr-09 23:39

I too would be interest in an answers, as I have a similar requirement, but does not need to a windows or web service.

Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.

Re: Seeking recommendations for PDF Merge Library

Henry Minute16-Apr-09 0:07

Henry Minute

16-Apr-09 0:07

You are correct that there is no built-in support for this in .NET.

There are several free libraries that support interaction with PDF files, so you could utilise one of those to write your own merge component. Very very steep learning curve though (Googling 'PDF Files .NET' got hits for all the ones I was aware of, and others).

At the end of the day I suppose it is a cost comparison between doing that and whatever paid-for component you eventually decide on.

open a ms word file in a richtextbox

marclenoir200515-Apr-09 3:56

marclenoir2005

15-Apr-09 3:56

Hi everybody,

i got a problem. i'm developping an vb.net application. now i want to load a word file into a richtextbox with all the formatting text from word.

Or

how can i load the whole word file into a control in vb.net that can support it?

Thanks for your help.

Marc.

0x3c015-Apr-09 4:34

15-Apr-09 4:34

Try loading an RTF file. That has most of the formatting available in Word, and can be opened by Word, Wordpad, and the RichTextBox control

Dave Kreskowiak15-Apr-09 5:32

Dave Kreskowiak

15-Apr-09 5:32

marclenoir2005 wrote:
now i want to load a word file into a richtextbox with all the formatting text from word.

Generally speaking, not possible. The RichTextBox doesn't support the Word file format. You'd have to save the document in RTF format, then load that version into the RichTextBox. Now, there's another problem. The RichTextBox doesn't support the entire RTF specification. Meaning, while Word will save all the formatting and other goodies in RTF format, the RichTextBox doesn't understand it all and will not render the document properly if the document contains formatting it doesn't support.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

0x3c015-Apr-09 5:40

15-Apr-09 5:40

Dave Kreskowiak wrote:
The RichTextBox doesn't support the entire RTF specification

That could be a problem. Is there a list anywhere which has more information about this? Some of my coursework uses this setup for convenience, and it's saved using Word, so this could be a possible problem

Luc 64801115-Apr-09 5:48

Luc 648011

15-Apr-09 5:48

Hi,

I don't know any details except this one: I have successfully been creating RTF files programmatically containing tables, which Wordpad can display but not create or drastically edit. And AFAIK Wordpad and the RichTextBox are based on the same basic control.

IMO a WebBrowser can show (not edit) a Word document, just like Internet Explorer can.

Smile | :)

Dave Kreskowiak15-Apr-09 6:02

Dave Kreskowiak

15-Apr-09 6:02

Luc 648011 wrote:
IMO a WebBrowser can show (not edit) a Word document, just like Internet Explorer can.

So long as either Word or Word Viewer is installed, this is true. If not, IE can't display the document and you'll get a Save File option for the .DOC file.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008