Re: Building string from many small ones (VB 6) - Visual Basic Discussion Boards

btoyer29-Jun-05 5:08

29-Jun-05 5:08

Here is a sample from my connect.vb file. It shows a testing (dev) version of a button and the real version of the button. (These are command buttons in my Excel addin) I want them both to bring up the same form with a different db connection. Is there a way to pass a variable that gets set in these subs to the form?

Private Sub MyUpload_dev_Click(ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean) Handles MyUpload_dev.Click
Dim frm As New frmGOUpload
frm.XLA = excelApp
frm.WS = excelApp.Workbooks(1).ActiveSheet
frm.Show()
End Sub

Private Sub MyUpload_Click(ByVal Ctrl As Microsoft.Office.Core.CommandBarButton, ByRef CancelDefault As Boolean) Handles MyUpload.Click
Dim frm As New frmGOUpload
frm.XLA = excelApp
frm.WS = excelApp.Workbooks(1).ActiveSheet
frm.Show()
End Sub

This is kind of what I am thinking of trying to do in the form:
If <variable> = 'dev' then
Dim wsrv As New SEOWS_dev.Service1
else
Dim wsrv As New SEOWS.Service1
end if

Re: connect to multiple DBs with same form

Dave Kreskowiak29-Jun-05 5:58

Dave Kreskowiak

29-Jun-05 5:58

Make a public Property on your saecond form. Set the property to whatever value you need to pass before the form is shown.

Dim frm As New frmGOUpload
frm.connString = "Whatever..."
frm.XLA = excelApp
frm.WS = excelApp.Workbooks(1).ActiveSheet
frm.Show()

Public Class frmGOUpload
...
Private m_ConnectionString As String
...
Public Property connString() As String
    Get
        Return m_ConnectionString
    End Get
    Public Set(ByVal Value As String)
        m_ConnectionString = Value
    End Set
End Property

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Building string from many small ones (VB 6)

peterchen29-Jun-05 3:30

peterchen

29-Jun-05 3:30

"Normal" Concatenation of many small strings seems to be very slow in VB6.
Is there a something like a "string builder" or "preallocation"?

Pandoras Gift #44: Hope. The one that keeps you on suffering.
aber.. "Wie gesagt, der Scheiss is' Therapie"
boost your code || Fold With Us! || sighist | doxygen

Re: Building string from many small ones (VB 6)

Dave Kreskowiak29-Jun-05 4:02

Dave Kreskowiak

29-Jun-05 4:02

In VB6? I seem to remember that there was a Join function somewhere. ... searching... Ah! Here we go, Join function[^]

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Building string from many small ones (VB 6)

StylezHouse29-Jun-05 5:07

StylezHouse

29-Jun-05 5:07

True, but that only joins an array...

Dim strReturn as String
Dim arrString(3) as String
arrString(0) = "This "
arrString(1) = "is "
arrString(2) = "an "
arrString(3) = "example."

strReturn = Join(arrString)

strReturn now equals "This is an example."

Re: Building string from many small ones (VB 6)

Dave Kreskowiak29-Jun-05 5:52

Dave Kreskowiak

29-Jun-05 5:52

Your point being?

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Building string from many small ones (VB 6)

StylezHouse29-Jun-05 6:20

StylezHouse

29-Jun-05 6:20

Simply stating that though you are correct, the method is clumsy due to VB6 in itself being very limiting in its string concat abilities.
(ie. Not as simple as the StringBuilder class that was mentioned)

Re: Building string from many small ones (VB 6)

Dave Kreskowiak29-Jun-05 9:51

Dave Kreskowiak

29-Jun-05 9:51

Considering this is the only function VB6 has to combine a bunch of smaller strings together into a single string, without using string concatentation, I think your point is moot. The goal of the OP was to get quicker performance out of putting the strings together, which Join will do, not to make it look pretty in code.

In VB6, you have two ways to do this. Either use string concatenation or use Join.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Building string from many small ones (VB 6)

J4amieC29-Jun-05 22:19

J4amieC

29-Jun-05 22:19

Dave Kreskowiak wrote:
In VB6, you have two ways to do this. Either use string concatenation or use Join.

Strictly, this is 100% true... but you can wrap the JOIN call into something easier (and more familiar to use)

Here's a good article:

VBScript StringBuilder[^]

Remoting - the only option?

theonewithtom29-Jun-05 2:42

theonewithtom

29-Jun-05 2:42

I would like to be able to access one appdomain from another on the same machine. This used to be easy in vb6 to access COM objects as the GetObject() method could be used.

I know it is possible to do this using remoting, however this seems a bit of an overkill as both programs are running on the same machine. More importantly when I use remoting it triggers off alerts from my firewall. As I want my application to be easy to use I feel this will confuse some users and does not appear very professional.

Anyone got any suggestions?

Many Thanks

~ Tom ~

StackOverFlow Exception with XpathNavigator

Madhu.A29-Jun-05 1:05

Madhu.A

29-Jun-05 1:05

Hi All,

Could you please help me in the below problem?

I am getting the exception 'StackOverFlow' while executing the below code.

Dim nodeIter As XPathNodeIterator<br />
nodeIter = thisXMLNav.Select(thisXPQuery)

I am using .net framework 1.0. But in some other machines I am not finding this exception.

Thanks in Advance.
Madhu Cry | :((

Re: StackOverFlow Exception with XpathNavigator

toxcct29-Jun-05 1:55

toxcct

29-Jun-05 1:55

i don't know what thisXMLNav.Select() is doing, but in general, stack overflow exceptions are thrown when a function calls itself, in an "infinite loop", until the stack have not enough memory to perform another function call...

is it a function of your own, or does it com from a library ?

TOXCCT >>> GEII power
[toxcct][VisualCalc]

Any suggestions for good interface designs

mian rashed29-Jun-05 0:53

mian rashed

29-Jun-05 0:53

Although I have studied a lot about user interfaces but i havent got a clue what r they saying. i mean i m a beginner so any.. Confused | :confused:

..kind suggestions.
thanks.

Mian Rashed Inam Khattak

Re: Any suggestions for good interface designs

toxcct29-Jun-05 1:57

toxcct

29-Jun-05 1:57

what do you want to know about interfaces ?

hum, let be accorded together, you talk about "user interfaces", or "VB interfaces" (in reference to the language keyword) ?

TOXCCT >>> GEII power
[toxcct][VisualCalc]

Re: Any suggestions for good interface designs

mian rashed29-Jun-05 5:20

mian rashed

29-Jun-05 5:20

i think it should be like the gui interfaces in vb.

i think it is good enough now.
thanks

Mian Rashed Inam Khattak

treeview node click event question

aimar_2029-Jun-05 0:22

aimar_20

29-Jun-05 0:22

Hello, I have a doubt:

I have a vb.net treeview, and I want that when I select one node, if I press the child of this node, then show a msgbox.

How I can capture the click event for the child of the node.

Thanks

Re: treeview node click event question

Purple Monk29-Jun-05 5:46

Purple Monk

29-Jun-05 5:46

Surely you can just get the click event of the treeview, record the id of the node clicked. Then when they click the next node check if the parent is the same as the one you recorded before then hey presto it's the child and then you can msgbox gallore

Hope that makes sense and fits the problem.

"If i was king cigarettes would be free."

Component to retrieve 10 records from oracle table

28-Jun-05 21:07

Hi Iam new to .NET i want to develop a component to
retrieve first 10 records from a oracle table pls just dont mail sql query

Thanks in advance

Regards

Lion Heart
Software Engineer
Bangalore

Re: Component to retrieve 10 records from oracle table

Dave Kreskowiak29-Jun-05 1:14

Dave Kreskowiak

29-Jun-05 1:14

Dropping the same question in multiple forums is considered very rude...

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Drag & Drop problem

nidhishri28-Jun-05 20:01

nidhishri

28-Jun-05 20:01

Hi,

I wanted to know how to drag an image from the word and drop it in RichTextBox or in Picture Box ? It's an windows application.

Thanks in advance.

Regards,
Shri

Re: Drag & Drop problem

Purple Monk29-Jun-05 5:48

Purple Monk

29-Jun-05 5:48

vb6 or vb.net?

"If i was king cigarettes would be free."

Have combobox in the listview

vincentkhoosiongleng28-Jun-05 17:02

vincentkhoosiongleng

28-Jun-05 17:02

Hi all professional friends, anybody know how to code a "Combobox" in the some column of listview? I don't want to use with dataset. Because I need to add some item into combobox myself and let customer select the combobox item in the listview.

Re: Have combobox in the listview

Purple Monk29-Jun-05 5:58

Purple Monk

29-Jun-05 5:58

Dim oCom As New ComboBox
oCom.Visible = True

With ListView1
.Controls.Add(oCom)
End With

Worked for me!

"If i was king cigarettes would be free."

Re: Have combobox in the listview

vincentkhoosiongleng29-Jun-05 19:46

vincentkhoosiongleng

29-Jun-05 19:46

Thank you. But this not I want.
Is like this....
If I have three columns, and each column item I need to have a combobox.

Closing From

lespaul3628-Jun-05 14:29

lespaul36

28-Jun-05 14:29

I remember that in vb6 there was a way to get where a form close was called from (ie. clicked x, computer shut down etc.) Is there a way to get this in .net.

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