Using VB (VS 7.0) to dev Excel macros etc. - Visual Basic Discussion Boards

Urgently need help for inserting value from .net CF to SQL CE database

19-Jul-05 8:38

Hi, I currently faced a problem on inserting decimal value from vb .net into SQLCE which declared as money data type. ANyone know how to solve this??

Thanks in advance!

Help: System.Reflection.TargetInvocationException

Anonymous19-Jul-05 7:22

Anonymous

19-Jul-05 7:22

Hi all,

I'm working with the SoapFormatter class and I can serialize my TreeNode with no problems. But I get the following error when I try to deserialize my content.

System.Reflection.TargetInvocationException
Exception has been thrown by the target of an invocation.

The exception is thrown at the bolded line below:

            <br />
Dim lSoapFormatter As New SoapFormatter<br />
Dim lReader As Stream = File.Open(asFilePath, FileMode.Open, fileAccess.Read)<br />
<br />
'deserialize the content<br />
Dim lTreeNode As TreeNode = CType(lSoapFormatter.Deserialize(lReader), TreeNode)<br />
<br />
'close reader<br />
lReader.Close()

The InnerException indicates that I have an InvalidCastException.
System.InvalidCastException: Specified cast is not valid.
at System.Windows.Forms.TreeNode..ctor(SerializationInfo si, StreamingContext context)

The thing that doesn't make any sense is that it is working fine on my machine (the one I developed my application on) but when I attempt to run it on another person's machine it throws this cast exception!? Confused | :confused:

I transferred my source code to this machine which is how I found out it was throwing this InvalidCastException in debug mode, but I have no clue how to resolve this!

Any ideas?! Please help!

Populating Dropdown list

macca2419-Jul-05 5:27

macca24

19-Jul-05 5:27

I have a dropdown list called ddlstat and I want to populate it with values from a database table called status. The value I want to get from Status table is Status name.

here is the code for ddlstat:
Private Sub ddlStat_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlStat.SelectedIndexChanged

End Sub

Does anyone have the code to use to populate a ddl.

Thanks
macca

Re: Populating Dropdown list

StealthMaker19-Jul-05 10:14

StealthMaker

19-Jul-05 10:14

im not sure if this is what your looking for but...

<br />
<br />
Private Sub ddlStat_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ddlStat.SelectedIndexChanged<br />
<br />
ddlstat.items.clear<br />
dim i as integer<br />
<br />
For i = 0 To (DataSet11.Tables("status").Rows.Count - 1)<br />
ddlstat.items.add(DataSet11.Tables("employee").Rows(i).Item("Status_Name")) 'status_name = column name in table<br />
next<br />
<br />
end sub<br />

Combo Box row selected

directred19-Jul-05 1:14

directred

19-Jul-05 1:14

I have a list of records in a combo box.

How do I get the selected row number e.g.

In combo box have the following

A
B
C
D

If I select C then that is the 3rd row. How do I display that I selected the 3rd row.

Thanks in advance

Re: Combo Box row selected

toxcct19-Jul-05 1:23

toxcct

19-Jul-05 1:23

see SelectedItem() and SelectedIndex()
hey, did you search a bit?

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

Re: Combo Box row selected

StealthMaker19-Jul-05 10:16

StealthMaker

19-Jul-05 10:16

combobox1.selectedindex + 1 = the row number

its +1 cause combobox index starts at 0 so the first item is at index 0 and the last is at count-1

in other words assuming the combobox is called combobox1 and the output is going to be in label1

<br />
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged<br />
<br />
Label1.Text = "You Clicked On row " & (ComboBox1.SelectedIndex + 1).ToString<br />
<br />
    End Sub

Using VB (VS 7.0) to dev Excel macros etc.

CreepingFeature19-Jul-05 0:55

CreepingFeature

19-Jul-05 0:55

Hi Guys,

Currently I use Office 2003 VBA to develop macros userforms etc for my Excel sheets. I was wondering if it is possible to use vb.net that comes with VS 7 to develop all of the above.

The reason I am asking is that in VBA the controls etc are not as 'nice' as the ones in vb.net and there are more features and so on. Also I realy want to learn VB.net (as I am told the syntax is different and it is more powerful than VBA).

Anyway if someone could give me some basic pointers on the whole issue that would be great.

Re: Using VB (VS 7.0) to dev Excel macros etc.

Kevin McFarlane19-Jul-05 9:27

Kevin McFarlane

19-Jul-05 9:27

You need Visual Studio Tools for Office. http://msdn.microsoft.com/vstudio/office/officetools.aspx[^]

Kevin

hallow only one instance of a winform

fuel2run18-Jul-05 23:50

fuel2run

18-Jul-05 23:50

hi,
i'm actually using a second winform ("info-form") to show some information after the user clicks on a picturebox.
if i click more than once, several "info-form" will show. i'd like to update the info showed in the "info-form" if it exists instead of creating new ones.

moreover, the info-form topmost option to true and i would like to get it topmost only when my app is active, but this is not really important.

any advice?
thancks in advance
Cheers!
Paolo

Re: hallow only one instance of a winform

Anonymous19-Jul-05 3:42

Anonymous

19-Jul-05 3:42

Are you working with an MDI application? Or two completely separate forms?

Re: hallow only one instance of a winform

fuel2run19-Jul-05 5:05

fuel2run

19-Jul-05 5:05

thanks for answering me,
it's a SDI application,
actually i can manage this issue declaring the name of the second form and verifying if Info_Form "is nothing" or if "Info_Form.IsDisposed" and then creating it.
do you think it's correct?

thanks again!

Re: hallow only one instance of a winform

Anonymous19-Jul-05 5:45

Anonymous

19-Jul-05 5:45

Sounds about right. Here's a link that should be helpful:

http://www.devcity.net/Articles/94/multipleforms.aspx[^]

Re: hallow only one instance of a winform

fuel2run19-Jul-05 20:21

fuel2run

19-Jul-05 20:21

i took a look at the article you linked to, very interesting.
thanks once again!
Cheers!
Paolo

.NET & Crystal Report

hung_ngole18-Jul-05 23:37

hung_ngole

18-Jul-05 23:37

I wrote a VB.NET program and I want to run report as follow :
When users click on the "Run report" button, the crystal report will open.
code:
shell("crw32.exe /r .\crystalReport1.rpt /id=1 /run",AppWinStyle.NormalFocus)
but the program justopens the report in design mode.
Now I want the report will be opened directly with the parameters id=1 ( not in design mode) when users click on the "Run Report" button.

Hung

google like taskbar for my application

shinay18-Jul-05 21:30

shinay

18-Jul-05 21:30

Does anyone know how to create a textbox in the toolbar
like google search tool with VB6?

I am also interested in the
Shin

Re: google like taskbar for my application

shinay18-Jul-05 21:41

shinay

18-Jul-05 21:41

I just googled and found out that i need to use band object.
If some has seen the sample code let me know

Thanks
Shin

Re: google like taskbar for my application

[Marc]18-Jul-05 22:08

[Marc]

18-Jul-05 22:08

There's an article here on CP[^]
But it's in C#, not VB6. Maybe it can help you with some ideas or something?

Hope this helps! Cool | :cool:

Re: google like taskbar for my application

shinay18-Jul-05 23:00

shinay

18-Jul-05 23:00

Thanks,
I will have a look at it.
Do you happen to know how to create some of application
docked on the top of desktop and hide/show depending on
how close the mouse pointer from the application?

Shin

Re: google like taskbar for my application

[Marc]19-Jul-05 8:30

[Marc]

19-Jul-05 8:30

I'm afraid not Cry | :((

I was just reading your post and remembered the article, but i don't know how the stuff in the article works. I just vagely read it, but didn't do anything with it.
Sorry i can't help you any further... Sigh | :sigh:

how to identify .msi setup installed with everyone / just for me

NarayanVl18-Jul-05 21:24

NarayanVl

18-Jul-05 21:24

How to find that, the installed application is installed with the option everyone or just for me (.msi file). Identify programatically the user selected option (everyone/just for me) in Installation to decide copying of data files to userpath or commondata path (eg. user logged in profile path or commondata folder)

Re: how to identify .msi setup installed with everyone / just for me

rwestgraham19-Jul-05 13:19

rwestgraham

19-Jul-05 13:19

Achieving what you describe is very difficult. You would have to checkl the property, then run a custom action (a C++ dll, not an installer class) that modified the msi database itself to change the target folder for the files. A much simpler approach would be to simple disable the option, always install for all users, and just fix the target folder as commondata.

Either way you'll have to download the Windows Installer SDK and modify the setup msi with the editing tool Orca. It's too complicated to attempt to explain. You'll have to spend considerable time studying the table design of an MSI.

Robert

Problem comn bw samba and vb.net

kaleem_khan200118-Jul-05 19:55

kaleem_khan2001

18-Jul-05 19:55

hi.

i am trying to make connection between a vb.net desktop application with the samba (linux server). my application reads files from linux server. but this it happends if i manullay go to start->run->"\\192.0.0.20" and when login password screen pop up i provide it the details, and then i can reads files from my applicatoin with out any authentication, else i just get the exception,

can any one help me how can i provide the login and password to remote ip from my application.

i am working in vb.net. please refer free api (no trial ver, or traing api)

regards.
kaleemullah
(Software engineer)

kaleem_khan2001@yahoo.com
kaleem.khan2001@gmail.com

Textfile

ADY00718-Jul-05 11:14

ADY007

18-Jul-05 11:14

Hello, can somebody tell me how to read from a textfile from line number 4?? PLEASE SEND ME FEEDBACK ON THIS!! THANKS!!

Re: Textfile

Christian Graus18-Jul-05 13:03

Christian Graus

18-Jul-05 13:03

Sorry for the C++ answer....

Are you using VB.NET or VB6 ? VB.NET has an excellent class library, including classes for text files, which allow you to read line by line ( so you can keep line 4 ). VB6 kind of sucks, I don't know what you'd do there.

Christian Graus - Microsoft MVP - C++

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