switching two items in a list box/combo box - Visual Basic Discussion Boards

How to improve performance of VB.Net 2010 / Word Windows Desktop App?

QuickBooksDev11-Dec-14 8:37

11-Dec-14 8:37

We have a VB.Net 2010 Windows Desktop app that creates custom invoices for QuickBooks. The app uses the Microsoft.Office.Interop.Word reference.

For each item in the invoice we copy a row or table in Word via
MyTableRowRange.Copy()
and
pRow.Range.Paste()
etc.

Then
Word.Find.Execute(Replace... to change the variables in a Template.Docx file to the real values.

The problem is that it takes too long. Doing 2 invoices with a total of 200 items is taking over 30 minutes on a I3280 quad 3.6 with 8 threads and 16G ram. This is running from a regular exe not from the vs ide.

Any ideas?

Re: How to improve performance of VB.Net 2010 / Word Windows Desktop App?

Maciej Los11-Dec-14 10:29

Maciej Los

11-Dec-14 10:29

Accordingly to actuall description of issue, using Copy and Paste then Replace function might cause performance issues.

If you want to get more help, please, improve your question and post a bigger part of code.

Re: How to improve performance of VB.Net 2010 / Word Windows Desktop App?

QuickBooksDev11-Dec-14 10:43

QuickBooksDev

11-Dec-14 10:43

The code is scattered in out modules.

Is there a better way of doing the word copy / paste and then replace?

Also every time I paste code into this box the browser hangs up and I loose everything entered include just 1 line (i.e. CodeProject.com not responding).

Re: How to improve performance of VB.Net 2010 / Word Windows Desktop App?

Chris Quinn11-Dec-14 20:49

Chris Quinn

11-Dec-14 20:49

Look at doing a mailmerge into the Word document, with the QuickBooks DB as the data source

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Re: How to improve performance of VB.Net 2010 / Word Windows Desktop App?

QuickBooksDev12-Dec-14 0:22

QuickBooksDev

12-Dec-14 0:22

That would not work since much of the data is not in QuickBooks. The Docx Template is also very complex. (We do use mail merge that with other programs when it fits but not with QB as a source but from an extracted file). The program also will save as a PDF and email the invoice once the new Docx file is created.

Really need to know how to speed up what we have currently.

Are certain Word functions just extremely slow? Are there replacements that can be used.

Re: How to improve performance of VB.Net 2010 / Word Windows Desktop App?

Mycroft Holmes14-Dec-14 13:22

Mycroft Holmes

14-Dec-14 13:22

QuickBooksDev wrote:
Are certain Word functions just extremely slow

YES!

It is why Office should never be used in a development environment, that and the versioning nightmare it creates.

Personally I would use a proper reporting tool to generate the invoices. SSRS, Telerik, Dev Express all have excellent reporting tools that will use disparate data sources and produce the most complex output you could require.

Never underestimate the power of human stupidity
RAH

Re: How to improve performance of VB.Net 2010 / Word Windows Desktop App?

QuickBooksDev15-Dec-14 0:24

QuickBooksDev

15-Dec-14 0:24

It is a bit late to change to something else.

What Word interfaces are extremely slow and what can be done about it?

switching two items in a list box/combo box

Steve-the-elk11-Dec-14 5:04

Steve-the-elk

11-Dec-14 5:04

Hi Everyone
This is an odd one, so please bare with me. I have a list of players in a football team in a list box. I then have two combo boxes with the same list of players in.

For a player substitute I need to be able to select the player on in one combo box, player off in the other and then switch their names round so player one appears where player two was and vice versa.

To then make it more complex, I need this to be reflected in the combo box.

I tried a very basic:

Dim floatingName = SubOn.SelectedItem
               SubOn.SelectedItem = SubOff.SelectedItem
               SubOn.SelectedItem = floatingName

but its not as simple as I'd hoped. Also this wouldn't make a difference to the list box.

Can anyone give me some pointers please?
Thanks in advance.

Steve
Slowly learning... if only there was more time in the day!

Re: switching two items in a list box/combo box

Richard MacCutchan11-Dec-14 6:45

Richard MacCutchan

11-Dec-14 6:45

You need to remove each player from its ComboBox and then replace them. Just using references as above will not do it.

How to test The performance Of a Vb.Net Pc Cleaner Software?

rituz9-Dec-14 1:36

rituz

9-Dec-14 1:36

How to test The performance Of a Vb.Net Pc Cleaner Software?

Re: How to test The performance Of a Vb.Net Pc Cleaner Software?

Chris Quinn9-Dec-14 2:03

Chris Quinn

9-Dec-14 2:03

1. Design some tests
2. Run the tests
3. Examine the results

=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================

Re: How to test The performance Of a Vb.Net Pc Cleaner Software?

Dave Kreskowiak9-Dec-14 11:00

Dave Kreskowiak

9-Dec-14 11:00

You say that like we're supposed to know exactly what this app does and how it does it.

A "cleaner" app can mean anything and do anything.

Your version of "performance" needs to be defined in very specific terms.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

QuickBooksDev5-Dec-14 11:52

QuickBooksDev

5-Dec-14 11:52

I am using VB.2013.

Code :

Dim MydataStream As Stream = Nothing
MydataStream = MyWebClient.OpenWrite(address:=MySend2URL, method:="POST")
Dim postArray As Byte() = Encoding.ASCII.GetBytes(postData)
MydataStream.Write(postArray, 0, postArray.Length)
MydataStream.Close()
Dim reader As New StreamReader(MydataStream)  ' <=== Dies here with "Stream was not readable."

How can I get a response that can be used and not the Stream is not readable error.

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

Richard MacCutchan5-Dec-14 22:22

Richard MacCutchan

5-Dec-14 22:22

Your previous line of code closed the stream, so how do you expect to read it?

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

QuickBooksDev6-Dec-14 0:15

QuickBooksDev

6-Dec-14 0:15

It also happens if I do not close it.

If postData = NIL Then
                MydataStream = MyWebClient.OpenRead(address:=MySend2URL)
            Else
                'MydataStream
                MydataStream = MyWebClient.OpenWrite(address:=MySend2URL, method:="POST")
                MydataStream.Write(postArray, 0, postArray.Length)
                'MydataStream.Close()  ' "The remote server returned an error: (401) Unauthorized."
            End If
            'MySend2URL &= ":443"
            Dim ThisResponse As String = NIL ' MyWebClient.Encoding.GetString(MydataStream)
            Dim reader As New StreamReader(MydataStream) ' <=== Dies here with "Stream was not readable."

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

Richard MacCutchan6-Dec-14 0:24

Richard MacCutchan

6-Dec-14 0:24

Your stream is opened for write access, or there is nothing to read. You will need to use your debugger to collect more information.

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

QuickBooksDev7-Dec-14 5:04

QuickBooksDev

7-Dec-14 5:04

What information?

I would think that it would be normal to write and expect a response.

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

Richard MacCutchan7-Dec-14 6:41

Richard MacCutchan

7-Dec-14 6:41

QuickBooksDev wrote:
I would think that it would be normal to write and expect a response.

Of course, you are correct. But debugging is what we have to do when our applications do not behave normally.

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

QuickBooksDev7-Dec-14 8:11

QuickBooksDev

7-Dec-14 8:11

I understand that I have been coding for many years but I have never used WebClient before and do not know what to look for. I was expecting that is there is some setting or parameter that needs to be set to get the response.

Do you have any explicit things to look for? Or do you have any code that does something similar that you can provide?

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

Dave Kreskowiak7-Dec-14 8:25

Dave Kreskowiak

7-Dec-14 8:25

What kind of response are you expecting to get back from the POST? Is it a file? Just a string? Some kind of value? What?

Using (rs = MyDataStream.GetResponse().GetResponseStream())
    Using (reader = New StreamReader(rs))
        Dim content = reader.ReadToEnd()
    End Using
End Using

This might not compile. I'm translating from C# and I'm really tired right now...

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

QuickBooksDev7-Dec-14 10:47

QuickBooksDev

7-Dec-14 10:47

It doesn't compile. Please send c# code. GetResponse is not a member of io stream and rs not defined. How should MyDataStream and rs be defined?

I am not sure of the response. The doc that I have on this service is very limited and not written for .Net.

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

Dave Kreskowiak7-Dec-14 11:55

Dave Kreskowiak

7-Dec-14 11:55

http://stackoverflow.com/questions/8222092/sending-http-post-with-system-net-webclient[^]

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

Richard MacCutchan7-Dec-14 22:44

Richard MacCutchan

7-Dec-14 22:44

QuickBooksDev wrote:
I have been coding for many years

Then you should understand how to debug your code.

QuickBooksDev wrote:
I have never used WebClient before

Then the documentation is the first place to look, see http://msdn.microsoft.com/en-us/library/a3xa6ys0(v=vs.110).aspx[^].

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

QuickBooksDev8-Dec-14 0:23

QuickBooksDev

8-Dec-14 0:23

The doc is where I started and copied the code from their examples. I just does not show getting a response from OpenWrite.

There is very little of my code to actually debug.

I am not sure if I am sending the wrong data to the service or that the WebClient is coded wrong.

Re: In .Net how can I get a response to WebClient.Open write instead of Stream was not readable

Richard MacCutchan8-Dec-14 0:48

Richard MacCutchan

8-Dec-14 0:48

QuickBooksDev wrote:
I am not sure if I am sending the wrong data to the service

And all i can say in response, once again, is that you need to do some debugging to find out. There is no detail in your question that can help anyone here to guess what might be going wrong.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.