Visual Basic

17-Dec-02 16:51

You should close the connection only after you are done with the data reader. Fortunately, there is a way to automatically close the connection when you close the data reader, that is by supplying the following argument in the ExecuteReader Function:-

cmd.ExecuteReader(CommandBehavior.CloseConnection)

Notorious SMC

The difference between the almost-right word & the right word is a really large matter - it's the difference between the lightning bug and the Lightning
Mark Twain

Get your facts first, and then you can distort them as much as you please
Mark Twain

Application Path

SuperGeek15-Dec-02 15:21

SuperGeek

15-Dec-02 15:21

Here is what I hope will be a simple question. In the old VB6, we could use the app.path to get the application path. What do I used to do this in VB.NET?

Wayne Phipps15-Dec-02 18:48

15-Dec-02 18:48

Is this is what your looking for...

The following example gets this property and displays its value in a text box. The example assumes that textBox1 has been placed on a form.

Private Sub PrintStartupPath()<br />
   textBox1.Text = "The path for the executable file that " & _<br />
      "started the application is: " & _<br />
      Application.StartupPath<br />
End Sub

Nick Seng17-Dec-02 16:11

17-Dec-02 16:11

Application.StartupPath only works in Vb6

In vb.net, you have 2 choices that work:

1) System.Reflection.Assembly.GetExecutingAssembly.Location

2) System.IO.Directory.GetCurrentFolder

I hope this helps

Notorious SMC

Wayne Phipps17-Dec-02 21:55

17-Dec-02 21:55

If Application.StartupPath is only applicable to VB6 then why did that sample come from the .Net Framework class library? I ask this question because I have just upgraded from Visual Studio 6 to Visual Studion .Net Pro and this sample came from the .Net help. Visual Studio 6 is now not installed.

Here is the complette sample...

.NET Framework Class Library

Application.StartupPath Property [Visual Basic]

Public Shared ReadOnly Property StartupPath As String

Property Value
The path for the executable file that started the application.

Example
[Visual Basic, C#] The following example gets this property and displays its value in a text box. The example assumes that textBox1 has been placed on a form.

Private Sub PrintStartupPath()<br />
   textBox1.Text = "The path for the executable file that " & _<br />
      "started the application is: " & _<br />
      Application.StartupPath<br />
End Sub

Requirements
Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows .NET Server family

.NET Framework Security:

FileIOPermission for reading and writing files. Associated enumeration: FileIOPermissionAccess.Read

See Also
Application Class | Application Members | System.Windows.Forms Namespace

Wayne Phipps17-Dec-02 22:35

17-Dec-02 22:35

I just tried it in VB.Net by the following:

TextBox1 = Application.StartupPath

Worked fine
Poke tongue | ;-P

Nick Seng17-Dec-02 23:13

17-Dec-02 23:13

BusterG wrote:
TextBox1 = Application.StartupPath

This is really weird coz Application.StartupPath doesn't work for me! Is there some other namespace or something that i'm suppose to add??? Unsure | :~

Notorious SMC

Wayne Phipps18-Dec-02 0:06

18-Dec-02 0:06

I didn't add any Imports to the code, just added a TextBox to the form and added TextBox1.Text = Application.StartupPath to the Form1_Load.

That should be all you need!

Nick Seng18-Dec-02 14:36

18-Dec-02 14:36

That's weird coz this doesn't work for me! The IDE doesn't even recognizes the Application keyword (i.e. there are squigly blue lines underneath the word saying it that 'Application' is not declared)

Does anyone know why this happens?

Notorious SMC

Wayne Phipps18-Dec-02 21:42

18-Dec-02 21:42

The VB.Net help file states:

Requirements
Namespace: System.Windows.Forms

I guess thats why it works without any other namespace declarations if you place the code in a form. So needless to say, if you declare Imports System.Windows.Forms it should work fine.

Nick Seng18-Dec-02 23:07

Recieve UDP non-blocking in VB.NET

18-Dec-02 23:07

OMG!!!

This is really embarassing.It works now. It didn't work before coz i was testing the code in a class library project ( which doesn't include system.windows.forms). I can't believe I was so blind/stupid!! Smile | :)

Notorious SMC

Wayne Phipps15-Dec-02 6:33

Looking for a free FTP class library for .NET

15-Dec-02 6:33

Does anyone know how to recieve a UDP packet without blocking. The udpClient appears to block. I was using the Winsock control in VB6 but have just upgraded to VB.NET.

gicio15-Dec-02 5:53

gicio

15-Dec-02 5:53

HI!

Is there an free FTP class library for .NET available?

OR an open source project that write a FTP class?

gcio

Re: Looking for a free FTP class library for .NET

rohancragg17-Dec-02 4:12

rohancragg

17-Dec-02 4:12

Have you tried searching:

http://www.planetsourcecode.com

On first attempt I found this which might help:

http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=341&lngWId=10

hth, Wink | ;)

Rohan.

services and UI

kasturirawat13-Dec-02 8:42

kasturirawat

13-Dec-02 8:42

I know that services and UI are No-No and Microsoft says that it is not recommended ( But their SQL server service does the same and so a lot of other third party services….Where can I find explanation for this).
I’m trying to display user interface from my VB.Net service. I can run my service under system account and check “allow to interact with desktop”, however my Form hangs. What are my options?
(1) Can I start another UI application from my service have them talk i.e. service can talk to application?

Thank you for helping me with this
Kasturi

how to debug Visual Com Dll

Leesen13-Dec-02 5:09

Leesen

13-Dec-02 5:09

hi,all
I write a COM Dll in Visual ATL . And I refer the COM dll in VB environment. The vb program runs well except when the program exit, the error dialog occur. The error info are such as "the address can't read ..." . Is it concerns with
the c++ pointer ??? But how can I find the actuall false??

Are there any tools to help to debug the com dll??
The problem disturb me for very long time .

Ask for your help , please !

Regards.

deselecting items in list view control

r i s h a b h s13-Dec-02 0:29

r i s h a b h s

13-Dec-02 0:29

dear all,

i'm using listview control in vb6.
how do i deselect a listview item (report view with full row select) by clicking. Confused | :confused:

can somebody come to rescue? Rose | [Rose]

rishabhs

Re: deselecting items in list view control

Richard Deeming13-Dec-02 4:01

Richard Deeming

13-Dec-02 4:01

Hold down Ctrl when you click the item.

"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

Using old com objects

Nick Seng12-Dec-02 17:15

Re: Using old com objects

12-Dec-02 17:15

I was previously developing an application using vb6 with some third party COMS. Now that I plan to upgrade to vb.net, I find that these COMs no longer works. Is there any way to make them work, short of looking for updated versions of these COMs( some of these third party companies are no longer operational)
Thanx

Notorious SMC

Jonathan [Darka]12-Dec-02 22:08

Jonathan [Darka]

12-Dec-02 22:08

Hi,

yes you can reuse them,you need to create a COM runtime wrapper for them which can then be used as a proxy to your original COM objects.

Use the "tlbimp.exe" tool which comes with Visual Studio .NET like this,

tlbimp oldcom.dll /out:oldcom.asm.dll

then you add a reference to the oldcom.asm.dll file to your .NET app.

regards,

DarkAngel

Re: Using old com objects

Nick Seng12-Dec-02 22:51