Visual Basic

Tools for Office, install help, please...

1-Mar-06 0:59

abhinish wrote:
takes the CPU usage to 100 percent while it is starting..

abhinish wrote:
m using a while loop to check the current time

There's your problem. You're loop is not giving control of the CPU back to the rest of the system. The startup code in a service is expected to launch a seperate thread to do its processing, not block itself in an endless loop.

You don't need to be checking the current time every couple of milliseconds. All you need to do is start a Threading.Timer that calls a function once a second. In that Timer Elapsed handler, you check for the current time, and if needed, do your processing, then reset the Timer. Using this method, your CPU usage should fall to just about 0.

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

hertz_j28-Feb-06 23:41

hertz_j

28-Feb-06 23:41

Hi,

I tried to install visual studio tools for office now for about two hours and I have failed miserably.
What I did was
1 Installed visual studio 2005
2 Installed office (with the .Net things for word, excel, outlook etc.)
3 Installed vstor.exe

Now if I understand things correctly this is supposed to be enough. Also this would give me some office options under the new project tab in Visual studio but no. And when I tried to open a sample project visual studio was kind enough to inform me that it did not have all required components installed.

So does any one know what I need to do? A quick (and clear) response would be much appreciated since I’m about to run a screwdriver through my hard drive.

dll in vb

Paritos28-Feb-06 23:23

Paritos

28-Feb-06 23:23

hi
I amnew to vb.

please help me how to make a dll and registering and unregistering dll..

Send any link for that...is available.

Wheather registering dll is required in Microsoft windows 2000/XP.

thanks and bye

Paritosh

Re: dll in vb

sathish s1-Mar-06 0:11

sathish s

1-Mar-06 0:11

I suppose you use vb and not vb.net..
Start you vb IDE - Select ActiveX dll - Write down the functions, you want to expose. Function should be declared as Public if you need to make a call.
Select make projectname.dll from file menu.

How to register
regsvr32 "dllpath\dllname.dll"
How to unregister
regsvr32 "dllpath\dllname.dll" /u

You need to register in w2k or xp, if it is not machine where you have developed it.

Treeview problem in vb.net

pankajgarg1228-Feb-06 22:53

pankajgarg12

28-Feb-06 22:53

Hi,
I want to expand the current drive node at the form load
Please help me.

Thanks and Regards
Pankaj Garg

-- modified at 4:55 Wednesday 1st March, 2006

Re: Treeview problem in vb.net

besah1-Mar-06 4:10

besah

1-Mar-06 4:10

hello Pankaj,

i think you can refer to this link http://www.codeproject.com/vb/net/VbNetExpTree.asp

hope that i can help u to solve the problem...

besah

Can a listbox do this?

KaKa'28-Feb-06 22:41

KaKa'

28-Feb-06 22:41

Hi,

Is this possible for a listbox?

When the listitems of the listbox are selected and right-clicked, a context menu appears.
Then, when the user right clicks on the empty space inside the listbox, the context menu will not appear even though an item is still selected.

If possible, what listbox event is used?

Re: Can a listbox do this?

noshaba mariam1-Mar-06 17:31

noshaba mariam

1-Mar-06 17:31

Hi,

U need to create menu on the form and make it invisible. Then on Mouse Down event of listbox check the value of button.
in this way

Private Sub List1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

If Button = vbPopupMenuRightButton Then
Me.PopupMenu Me.file, vbPopupMenuCenterAlign
End If

End Sub

Noshaba

file association

andylimjp28-Feb-06 19:36

andylimjp

28-Feb-06 19:36

Hi All!
How do I associate the documents I save using my program to the program itself? Can't seem to do it. I right click the file and then open with... then I click on the vb.net program exe file that I have created but nothing seems to happen...

Thanks for any reply!

Dave Kreskowiak1-Mar-06 1:15

1-Mar-06 1:15

What do you mean "nothing happens"?? Nothing happens what you double click the document? Does your app launch, but no document is loaded??

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

andylimjp1-Mar-06 6:02

andylimjp

1-Mar-06 6:02

Hello Dave,

When I try to open the document that I saved using my program, the "windows cannot open this file" dialog pops up. It does not know which program to use to open up my document. But I can actually open the document only when I open through the program.

Dave Kreskowiak1-Mar-06 9:18

1-Mar-06 9:18

It sounds like the association is messed up. Open Explorer and click on the Tools menu, Folder Options. Click on the File Types tab. Find your file extension in the list and click on it. Then click on the Advanced button. You should have an open item in the Actions box. Click that, then click Edit. The command line under Application used to perform action: box should look something like this (with the quotes!):

"C:\Program Files\someFolder\myApp.exe" "%1"

If the quotes are not there, the file paths will not get processed correctly and your app will get a list of command-line parameters like this:

myApp.exe C:\Documents and Settings\userId\File To Open.txt

The list of 5 parameters will look like this:

C:\Documents
and
Settings\userId\File
To
Open.txt

Depending on how you coded your app, the filename it'll try to open will be C:\Documents.

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

Dave Kreskowiak1-Mar-06 9:19

1-Mar-06 9:19

"C:\Program Files\someFolder\myApp.exe" "%1"

If the quotes are not there, the file paths will not get processed correctly and your app will get a list of command-line parameters like this:

myApp.exe C:\Documents and Settings\userId\File To Open.txt

The list of 5 parameters will look like this:

C:\Documents
and
Settings\userId\File
To
Open.txt

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

andylimjp1-Mar-06 13:52

andylimjp

1-Mar-06 13:52

I have actually done what you said before. I am unable to find my file extension in the list. I added manually and after that went to the advance section and configured the actions myself. I also change the icon. After I click OK I got back to the Folder option dialog. When I click the advance tab again, everything I edited and configured will haf disappeared...

Dave Kreskowiak2-Mar-06 2:21

2-Mar-06 2:21

I have no idea what you're doing wrong. Other than when you go back into the list, it's resorted alphabetically. You could attempt to create a New association and try to use the same extension and see what happens.

You might also want to try it using an admin account.

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

Dave Kreskowiak1-Mar-06 5:51

Dataset.Table.RemoveAuthorsRow(variable)

1-Mar-06 5:51

After reading your post again, it would seem that your app is not written to handle command-line arguments. You might want to read up on the

<a href="http://msdn2.microsoft.com/en-us/library/system.environment.getcommandlineargs.aspx" rel="nofollow">Environment.GetCommandLineArgs</a>[<a href="http://msdn2.microsoft.com/en-us/library/system.environment.getcommandlineargs.aspx" target="_blank" rel="nofollow" title="New Window">^</a>]

method.

When you launch a documnet in the way you described, the associated process (or the one you pick in that dialog) is launched using a command line similar to:

C:\Program Files\SomeFolder\MyApp.exe C:\Path\To\SomeDocument.ext

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

Scott341528-Feb-06 19:20

28-Feb-06 19:20

I'm using the RemoveTableRow method in the following code, which updates the dataset, however it doesn't ever update the database via the data adapter. Any one have any idea why? Much appreciative

(code generalized)
'Module level declaration
Dim mdrRow As DataSet.TableRow

'Retrieve datarow from dataset
mdrRow = DataSet.Table.FindByTableID(txtfield.Text)
with mdrRow
txtfield1.text = .field1
etc
end with

'Activated by a btnDelete
Dataset.Table.RemoveTableRow(mdrRow)

SQLDataAdapter.Update(DataSet)
DataSet.AcceptChanges()

When I attempt to retrieve from the dataset the row is no longer there, however it never updates to the database, so when the program terminates and the dataset is refilled the row is then back.

Dave Kreskowiak1-Mar-06 1:14

1-Mar-06 1:14

Perhaps you never really deleted the row? Check the RowState of the row in question before you attempt to write the data back to the database with the Update call. I get the feeling your code never really returns a DataRow object when it calls FindByTableID. There's no such method in the .NET Framework, so you had to write it somewhere. ...Or is this not a Copy and Paste version of your code???

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

Scott34151-Mar-06 2:04

1-Mar-06 2:04

Dave,

First, I thank you for your response.

Second, forgive me, I am new at VB.Net programming. I believe the row has to be deleted in the dataset. I'm using the FindByTableID method to populate a form when the program is first loaded, which also assigns the TableRow to the variable "mdrRow". At this time the row is retrieved to the form (successfully). If then, I click on the delete button the code DataSet.Table.RemoveTableRow(mdrRow) is then fired. At that point, if I attempt to retrieve that record using, again, the FindByTableID method the record is no longer found, which leaves me to believe it is indeed being removed from the dataset. However, when I close the program and then rerun it, thus refilling the dataset at form_load the record is now there (in the dataset) again. Can you tell me an example of how I would implement the RowState in this scenario, as I'm unfamiliar with that method.

Maybe my theory on this is all wrong. If you would like, and I would tremendously appreciate it, I can send you the exact code offline.

Dave Kreskowiak1-Mar-06 2:19

1-Mar-06 2:19

Each DataRow object has a RowState property. All you have to do is set a breakpoint on the code where you're deleting the Row, Dataset.Table.RemoveTableRow(mdrRow), then look at the mdrRow object in the Watch window. Find the RowState property, then watch what happens to it when you hit F10 to single step through the code and run that one statement. If the RowState doesn't change to something like Deleted, the Adapter.Update statement won't know that is has to call the SQL delete statement for that row.

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

-- modified at 8:19 Wednesday 1st March, 2006

Scott34151-Mar-06 2:36

1-Mar-06 2:36

Not sure if I'm doing this correctly;

I inserted a Breakpoint on the dataset.table.removetablerow(mdrRow) statement, then when I run the program a messagebox is displayed that states "There is no source code available for the current location." I then have a choice to look at the disassembly? I do see the Watch area but there is no name, values or types. Thank You.

Dave Kreskowiak1-Mar-06 5:42

1-Mar-06 5:42

Try setting the breakpoint to the first line at the beginning of the Sub where this code is, then stepping through it one line at a time.

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

Doctor Nick1-Mar-06 3:00

Doctor Nick

1-Mar-06 3:00

After you delete the row from the dataset are you updating the table on the database? Datasets are disconnected from the database so you need to run some type of delete stored procedure to get the data out of the database. Otherwise you're just emptying your dataset without really doing anything. Sorry if that's a dumb question but I didn't see anything to this effect in the code you've provided.

-------------------------------------
Do not do what has already been done.
Absolute power corrupts absolutely.. but it ROCKS absolutely, too.

Scott34151-Mar-06 3:05