Performance issues.. - Visual Basic Discussion Boards

Raghvendra Kumar Roy10-Jul-07 23:53

10-Jul-07 23:53

Hi all

I Want to run ppt(powerpoint) in half screen and show picture in another half screen.
is it possible from ActivexControl.
I am working in VB 6.0. Plz help Me

Raghvendra Kumar

Raghvendra Kumar Roy

Re: run ppt(powerpoint) in VB

DanB198311-Jul-07 0:01

DanB1983

11-Jul-07 0:01

Hi
Is can you not add a reference to ppt object then open it up from there (it is a COM object):

http://msdn2.microsoft.com/en-us/library/aa220907(office.11).aspx

to create the application. Then use this resource to get the desired effects:

http://msdn2.microsoft.com/en-us/library/aa213568(office.11).aspx

This provides a complete overview of the power point object model so you can use its functionality to get what you want.

I am sure there will be an activex control but I have only ever done it this way so can only offer this help.

Hope it is of use

Dan

Re: run ppt(powerpoint) in VB

Raghvendra Kumar Roy11-Jul-07 0:08

Raghvendra Kumar Roy

11-Jul-07 0:08

Is any other Way?

Raghvendra Kumar Roy

Re: run ppt(powerpoint) in VB

Christian Graus11-Jul-07 0:44

Christian Graus

11-Jul-07 0:44

If you're not willing to do it the way that has been suggested, then I'd recommend black magic, it's as likely to work as anything else, once you've excluded the right way of doing things.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

IN clause in parameterized query

Johan Hakkesteegt10-Jul-07 22:54

Johan Hakkesteegt

10-Jul-07 22:54

Hi,

I am using an SQLDataadapter in my app, with a query. Something along the lines of:
SELECT * FROM MyTable WHERE MyTable.MyField IN ('ABC', 'DEF', 'GHI')
The number of items in the IN bit is variable as well as their respective values.

Usually with a parameterized query I would use @MyParameter in the query and then
SDA_MyAdapter.SelectCommand.Parameters("@MyParameter").Value = "ABC"
This doesn't work however when I try:
SDA_MyAdapter.SelectCommand.Parameters("@MyParameter").Value = "ABC, DEF, GHI"

Can I use this principle at all in this case, and if yes, then how?
If not, then how else can I do it using good VB.NET practices?

All help and suggestions appreciated,

Johan

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

Re: IN clause in parameterized query

Paul Conrad13-Jul-07 12:27

Paul Conrad

13-Jul-07 12:27

Not sure, but is the problem occurring in any other test cases, such as ones without the , being used...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: IN clause in parameterized query

Johan Hakkesteegt15-Jul-07 20:11

Johan Hakkesteegt

15-Jul-07 20:11

Hi Paul,

I have tried the following variants:
- "ABC,DEF,GHI"
- "ABC, DEF, GHI"
- "'ABC','DEF','GHI'"
- "'ABC', 'DEF', 'GHI'"
In all cases the hard coded query will return results but not the parameterized one.

How would you propose to do it without commas?

Best Regards,

Johan

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

Performance issues..

ne0h10-Jul-07 22:36

ne0h

10-Jul-07 22:36

Hi,
I have coded a small desktop based windows app which parses a flat text file and generate a word document with some values from the said file. The code contains lots of loops and huge string manipulation and its 438 lines of code. The problem is when I checked task manager, its eating memory worth 20MB !!

So, any ideas, suggestions, checklists in this situation how to decrese occupied memory by the program from string manipulation perspective?

--------------------------------
**** JOB23743 Submitted ****

Re: Performance issues..

Colin Angus Mackay10-Jul-07 23:37

Colin Angus Mackay

10-Jul-07 23:37

Arindam Giri wrote:
The problem is when I checked task manager, its eating memory worth 20MB !!

And.... If it was eating 20Gb I'd be worried, but 20Mb is nothing. Also, remember that what you seen in the task manager is the amount of memory the application has reserved from the OS. Not what is actually used.

Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...

"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."

Ready to Give up - Your help will be much appreciated.

My website

Re: Performance issues..

ne0h11-Jul-07 0:01

ne0h

11-Jul-07 0:01

Thanks Colin.

--------------------------------
**** JOB23743 Submitted ****

Re: Performance issues..

The ANZAC10-Jul-07 23:52

The ANZAC

10-Jul-07 23:52

intensive programs use 150 +, you've got nothing to worry about, if it was that i'de be worried, but 20 is ok. Task manager also isn't always accurate, as was said, it is what is eserved and often a little extra as a buffer.

Posted by The ANZAC : "WWBD, What Would Buffy Do?" : "I don't know man, she's stronger than me"

Re: Performance issues..

ne0h11-Jul-07 0:02

ne0h

11-Jul-07 0:02

Thanks.

--------------------------------
**** JOB23743 Submitted ****

Re: Performance issues..

Christian Graus11-Jul-07 0:46

Christian Graus

11-Jul-07 0:46

Make sure you use stringbuilder instead of string where-ever it makes sense ( like when you're building a big string out of lots of little ones ). But, as the others said, 20 MB is not a whole lot.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Performance issues..

ne0h11-Jul-07 3:22

ne0h

11-Jul-07 3:22

Thanks Chris for the info.

--------------------------------
**** JOB23743 Submitted ****

Scrolling in Panels

Mark0610-Jul-07 22:18

Mark06

10-Jul-07 22:18

Hi,
I have a control, which contains a flow panel, with textboxes being added dynamically at runtime.
The flow panel docking is set to fill the control, and its flow direction is set to TopDown.

I want the control to be scrollable, incase there are more textboxes added at runtime than fit the original size.

So I enable Autoscroll for the FlowPanel.
However, I get both updown and leftright scrollbars.
I simply just want the updown scrolling.

Anyone know how I can force this, or find a way around it?

Any response gratefully appreciated

Re: Scrolling in Panels

MidwestLimey12-Jul-07 5:20

MidwestLimey

12-Jul-07 5:20

If the contents of the panel fit within the width of the panel then the horizontal scrollbar shouldn't appear. I just tested this out of curiosity.
Are you sure the contents aren't being clipped horizontally? Perhaps an overhanging label?
Otherwise you could expand the panel until all contents fit.

I'm largely language agnostic  
     After a while they all bug me  

how to copy only one row ?

Mr.Kode10-Jul-07 22:09

Mr.Kode

10-Jul-07 22:09

my application should copy specfic row at click event
and i used find method to search rows
my code as follows:

for each dr as datarow in sourcetable.rows
dr=sourcetable.rows.find(textbox1.text)
r=destinationtable.newrow
r("column1")=dr("column1")
r("column2")=dr("column2")
r("column3")=dr("column3")

destinationtable.rows.add(r)
next

but when the code executed the destinationtable rows exceeds according to the source table rows count .

all i need is to copy the displayed row (one row at time)

many regards

Re: how to copy only one row ?

Johan Hakkesteegt10-Jul-07 23:10

Johan Hakkesteegt

10-Jul-07 23:10

The reason for this behavior is quite simple. In your code you loop through all the lines in the source table, and you always add a new line.
dr=sourcetable.rows.find(textbox1.text) seems a bit strange to me. dr already represents a row from sourcetable (because of the loop), but you try to assign it a value from that same table.

If the line dr=sourcetable.rows.find(textbox1.text) even works at all you need to forget about the loop. Otherwise try something like:

For Each dr as DataRow in sourcetable.Rows<br />
If dr.Item("Name_of_the_column_you_are_searching") = textbox1.Text Then<br />
'create the new row according to you code<br />
'so a new row only gets created when<br />
'textbox1.Text is found in the sourcetable<br />
next

Hope this helps,

Johan

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

Re: how to copy only one row ?

Mr.Kode10-Jul-07 23:23

Mr.Kode

10-Jul-07 23:23

thanx johan
i'll try your code

regards

can i able to use ms flexgrid with xml in vb.net ?

babusat10-Jul-07 21:01

babusat

10-Jul-07 21:01

i want to grid control for a form for backend of xml can i able to do ?
pls explain if yes means how ?

sathish

Re: can i able to use ms flexgrid with xml in vb.net ?

Christian Graus11-Jul-07 0:46

Christian Graus

11-Jul-07 0:46

Why would you want to use msflexgrid ? .NET is full of grids, which can take XML as a data source.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: can i able to use ms flexgrid with xml in vb.net ?

babusat11-Jul-07 20:25

babusat

11-Jul-07 20:25

I want to multiple entries like record type and i want to store it in xml that only i want to use flexgrid with xml

sathish

Re: can i able to use ms flexgrid with xml in vb.net ?

Dave Kreskowiak12-Jul-07 1:45

Dave Kreskowiak

12-Jul-07 1:45

That made absolutely no sense at all. MsFlexGrid doesn't handle XML and neither does the DataGrid or the DataGridView in the .NET Framework. The XML is handled by the DataSet and DataTable classes, which are bindable datasources for the DataGrid and DataGridView classes. They won't work with the older-than-dirt FlexGrid.

A guide to posting questions on CodeProject[^]

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

notepad connection

p_10-Jul-07 20:58

10-Jul-07 20:58

hi all
i am using notepad to make a web page
so please tell me how i can connect to database mysql from notepad
thanks Rose | [Rose]

Re: notepad connection

Guffa10-Jul-07 21:33

Guffa

10-Jul-07 21:33

You can't connect to a database from notepad.

If you mean how to write code to connect to the database, there are thousands of examples out there. Just google for something like "vb.net connect mysql". When you have looked at some of the examples, you can come here with more specific questions that are more suited to be answered in a forum.

---
single minded; short sighted; long gone;

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