Re: multiple controls firing one event from usercontrol - Visual Basic Discussion Boards

Re: Importing data from Excel to Database by program?

Christian Graus12-Jan-06 10:55

12-Jan-06 10:55

With regard to your email - no, I won't send you any code. You will need to write it yourself.

I don't have code to do this, what makes you think I do ?

Christian Graus - Microsoft MVP - C++

Re: Importing data from Excel to Database by program?

shiroamachi12-Jan-06 15:08

shiroamachi

12-Jan-06 15:08

No no no. I'm not asking for any code. I'm asking about an "efficient way" or "best practice" or etc.
Thank you

WiL

Re: Importing data from Excel to Database by program?

Christian Graus12-Jan-06 15:11

Christian Graus

12-Jan-06 15:11

I apologise. Someone ELSE sent me an email that said 'please send me code for this problem'. I assumed it was you.

I don't see any terribly efficient way of doing this, unless your users all use a new enough version of Excel that they can save as XML.

Christian Graus - Microsoft MVP - C++

Re: Importing data from Excel to Database by program?

shiroamachi12-Jan-06 15:28

shiroamachi

12-Jan-06 15:28

Thanks CG. Looking foward for more helps from you in future Big Grin | :-D

WiL

multiple controls firing one event from usercontrol

Fu Manchu11-Jan-06 15:31

Fu Manchu

11-Jan-06 15:31

hi there,

I need to access an unknown number of controls, that may be added by a user to my a usercontrol and each control must fire the same event!

i think this is the only way possible that i can do it!

for example..imagine a panel and add three buttons to it...then on each mouse enter of each button the same event is triggered, i have tried a number of ways but all failed.

please help

thanks

Re: multiple controls firing one event from usercontrol

Christian Graus11-Jan-06 15:53

Christian Graus

11-Jan-06 15:53

Create a single method in your code, and tie the event of each control to that method.

Christian Graus - Microsoft MVP - C++

Re: multiple controls firing one event from usercontrol

Dave Kreskowiak11-Jan-06 16:56

Dave Kreskowiak

11-Jan-06 16:56

Or, if your adding these controls dynamically, look into AddHandler[^]. Don't forget to lookup it's opposite, RemoveHandler.

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

Re: multiple controls firing one event from usercontrol

Fu Manchu23-Jan-06 10:36

Fu Manchu

23-Jan-06 10:36

Hi, i have been quite busy lately due to exams at uni, but i would just like to say thanks for your advice....

The following code is exactly what i needed

Add this code and some controls to a form and on each Mouse_Enter of any control the main event is triggered..excellent Big Grin | :-D

'Every control added to the form cause this event to be raised<br />
    WithEvents MyDummyControl As Button<br />
    Public Event MyEvent()   ' Declare an event.<br />
    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load<br />
        Try<br />
            Dim mycontrol As Control<br />
            'count number of controls<br />
            For x As Integer = 0 To Me.Controls.Count - 1<br />
                'Associate controls<br />
                mycontrol = Me.Controls.Item(x)<br />
                ' Associate an event handler with an event.<br />
                AddHandler mycontrol.MouseEnter, New EventHandler(AddressOf TriggerMyEvent)<br />
            Next<br />
            RaiseEvent MyEvent()   ' Raise an event.<br />
<br />
        Catch MyError As Exception<br />
            'dont do event<br />
        End Try<br />
    End Sub<br />
<br />
<br />
    Private Sub TriggerMyEvent(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyDummyControl.MouseEnter<br />
<br />
    End Sub

Thanks again

Remote Access

soltec11-Jan-06 15:11

soltec

11-Jan-06 15:11

I'm a non-profit organization and I'm trying to develop a remote access desktop application either in VB 6 or VB.NET that will allow remote control of a computer, so that a tech can troubleshoot problems, similar to Netmeeting, allowing the tech to control the mouse, keyboard strokes and see the screen of the remote computer as close to real time as the Internet connection will allow. We have looked into products from other companies, but the repetative costs are too much. Any help would be greatly appreciated. If it can't be done in VB.NET or VB 6, can someone point us in a direction to go to get this done. We refurbish computers for the developmentally disabled and need remote access troubleshooting. We've looked at some of the open GNU product and it's either full of spyware or not in a language we code in currently.

Michael Bragg, President
eSolTec, Inc.
a 501(c)(3) organization
http://www.esoltec.org

Re: Remote Access

Dave Kreskowiak11-Jan-06 15:23

Dave Kreskowiak

11-Jan-06 15:23

Google around for VNC. You'll find just what you're looking for. I would suggest dropping the VB6 version though and going with VB.NET. Much easier to do with greater flexibility.

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

Re: Remote Access

soltec6-Feb-06 4:49

soltec

6-Feb-06 4:49

David,

thank you for your tip, however, VNC has spyware in it and it's also written in C++ I believe. I need something in VB6 or .NET so that I'm able to edit it for use in our company.

Any Free solution to read pdf in application form?

cylix200011-Jan-06 13:51

cylix2000

11-Jan-06 13:51

As the title,
I know it can be done if using Adobe Acrobat SDK,
and SDK 5.0 is free.
But the Adobe does not provide 5.0 SDK(Win) any more...
Any good idea for the same perpose?
Thank you!

Re: Any Free solution to read pdf in application form?

Curtis Schlak.11-Jan-06 14:01

Curtis Schlak.

11-Jan-06 14:01

Do you just want to parse the contents of the PDF document, or do you want to actually render the document on a Form?

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Re: Any Free solution to read pdf in application form?

cylix200011-Jan-06 17:22

cylix2000

11-Jan-06 17:22

In My case, I need to render the document on a form.

Re: Any Free solution to read pdf in application form?

Curtis Schlak.12-Jan-06 2:01

Curtis Schlak.

12-Jan-06 2:01

You're in luck! Right here on CodeProject is the 100% .NET component for rendering PDF documents[^] by Frank Rem[^].

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

Re: Any Free solution to read pdf in application form?

cylix200012-Jan-06 14:47

cylix2000

12-Jan-06 14:47

It sounds so good, but it is not free.
anyway, Thanks for your advice.

Re: Any Free solution to read pdf in application form?

Curtis Schlak.13-Jan-06 1:39

Curtis Schlak.

13-Jan-06 1:39

Oh, I apologize. Free. That makes it more difficult. Many libraries out there exist to create/read/convert PDF documents; however, displaying them requires a lot of work (a lorry's load, depending on how you do it). Because of that, I don't think that we'll find any free libraries to do that. I'm sorry.

"we must lose precision to make significant statements about complex systems."
-deKorvin on uncertainty

event handler & textbox problem

andrewke111-Jan-06 12:36

andrewke1

11-Jan-06 12:36

i am trying to write a character that is received from the the serial port to a textbox but the received character never shows up in the textbox. the serialdata received event handler fires and using debug you can step through the code & follow the character as it is written to textbox1.text but it never actually shows or is visible in the textbox on the form. all the serialport setup etc is done in module1 - open(), isopen(), getportnames()etc & write the returned information into textbox1 with no problems.

Public Class Form1

Public Sub MyRxData(ByVal intRxData As Integer)

Dim strAscChar As String

strAscChar = Chr(intRxData)
TextBox1.Text &= strAscChar

End Sub
End Class

Module Module1

Dim WithEvents _Rs232 As New SerialPort()

Public Sub _Rs232_DataReceived(ByVal sender As Object, ByVal e As System.IO.Ports.SerialDataReceivedEventArgs) Handles _Rs232.DataReceived

If _Rs232.BytesToRead > 0 Then
Do
Form1.MyRxData(_Rs232.ReadByte)
If _Rs232.BytesToRead = 0 Then
Exit Do
End If
Loop
End If
End Sub
End Module

when all the code is lumped into Form1 it all works with no problems, it is only when i put all the serial port code into it's own module that the problem occurs. i have had no formal training in vb etc as i am involved in hardware design, FPGA & micros etc so i suspect i am doing something stupid or doing it in a way that it is not meant to be done, so any help & suggestions would be greatly appreciated. Thanks

Re: event handler & textbox problem

Christian Graus11-Jan-06 13:08

Christian Graus

11-Jan-06 13:08

andrewke1 wrote:
TextBox1.Text &= strAscChar

Should that be += ? Have you debugged to make sure that strAscXhar is the character you want ?

Christian Graus - Microsoft MVP - C++

Re: event handler & textbox problem

Joshua Quick11-Jan-06 13:21

Joshua Quick

11-Jan-06 13:21

Christian Graus wrote:
Should that be += ?

&= is correct. VB uses the ampersand '&' to append strings.

Re: event handler & textbox problem

Christian Graus11-Jan-06 13:23

Christian Graus

11-Jan-06 13:23

I knew that VB6 did, I thought that may have been fixed in VB.NET.

Christian Graus - Microsoft MVP - C++

Re: event handler & textbox problem

Joshua Quick11-Jan-06 13:30

Joshua Quick

11-Jan-06 13:30

Christian Graus wrote:
I knew that VB6 did, I thought that may have been fixed in VB.NET.

Fixed? You make it sound like it was a bug. Big Grin | :-D

Anyways, I just looked it up and it turns out that VB.NET supports + for string concatenation too.

Re: event handler & textbox problem

andrewke111-Jan-06 13:38

andrewke1

11-Jan-06 13:38

thanks for quick reply
using += does not make any difference
i have added a breakpoint at the line "strAscChar = Chr(intRxData)"
if i send a message "H" and step through the program i get intRxData &H48.
after the line is executed strAscChar is "H" - which is correct.
after the final line " TextBox1.Text &= strAscChar" is run and the yellow highlight cursor has moved to End Sub if i hover the mouse cursor over the
"TextBox1.Text" part of that line it shows that "H" has been written, so VS thinks that everything is ok but nothing is visible in the textbox on the form

Re: event handler & textbox problem

Christian Graus11-Jan-06 13:43

Christian Graus

11-Jan-06 13:43

A word of advice - if Dave K says anything on the VB forum, ignore anything I might have said. He's obviously spotted the problem, which is apparently that you're not using the actual form that is being displayed.

Dave K is the king of the VB.NET forum, I am but a clown prince Smile | :)

Christian Graus - Microsoft MVP - C++

-- modified at 19:43 Wednesday 11th January, 2006

Re: event handler & textbox problem

Dave Kreskowiak11-Jan-06 15:20

Dave Kreskowiak

11-Jan-06 15:20

Christian Graus wrote:
Dave K is the king of the VB.NET forum, I am but a clown prince

Oh come on! I respect you far more than a lowly court jester!

Honestly, I think you're better at this than I am. You've got far more experience than I do in major applications, patterns, and many other things. I put you right up there with Heath.

My primary job isn't development. I'm just a completely self-taught, don't know it all, but know where to look and know how to test, kind of guy. My primary job is keeping the damn place running 24x7. I just write system utils, manangement apps, data collection agents, automation tools, SQL databases to backend 'em, ... [beep] [beep] [beep] Crap! Now what's busted?

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

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