Visual Basic Discussion Boards

Re: Sending mail from VB.NET code error

Johan Hakkesteegt14-May-09 23:59

Johan Hakkesteegt

14-May-09 23:59

First change MsgBox(ex.Message) to MsgBox(ex.ToString)
That will tell you more about the actual error.

My advice is free, and you may get what you paid for.

Re: Sending mail from VB.NET code error

Radzivil Vladimir15-May-09 0:56

Radzivil Vladimir

15-May-09 0:56

Удаленный хост принудительно разорвал существующее подключение. = remote host has close current connection.

ex.ToString "System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Unable to read data from the transport connection: Удаленный хост принудительно разорвал существующее подключение. ---> System.Net.Sockets.SocketException: Удаленный хост принудительно разорвал существующее подключение
at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
--- End of inner exception stack trace ---
at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)
at System.Net.DelegatedStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.Net.BufferedReadStream.Read(Byte[] buffer, Int32 offset, Int32 count)
at System.Net.Mail.SmtpReplyReaderFactory.ReadLines(SmtpReplyReader caller, Boolean oneLine)
at System.Net.Mail.SmtpReplyReaderFactory.ReadLine(SmtpReplyReader caller)
at System.Net.Mail.SmtpConnection.GetConnection(String host, Int32 port)
at System.Net.Mail.SmtpTransport.GetConnection(String host, Int32 port)
at System.Net.Mail.SmtpClient.GetConnection()
at System.Net.Mail.SmtpClient.Send(MailMessage message)
--- End of inner exception stack trace ---
at System.Net.Mail.SmtpClient.Send(MailMessage message)
at Yahoo_Client.Form1.Send_Click(Object sender, EventArgs e) in C:\Documents and Settings\VLAD\Мои документы\Visual Studio 2008\Projects\Yahoo Client\Yahoo Client\Form1.vb:line 28" String

Re: Sending mail from VB.NET code error

Johan Hakkesteegt15-May-09 2:45

Johan Hakkesteegt

15-May-09 2:45

Radzivil Vladimir wrote:
System.IO.IOException: Unable to read data from the transport connection

This suggests that you should look for the problem in the connection to the smtp server.

Radzivil Vladimir wrote

Dim credential As New System.Net.NetworkCredential(Email.Text, Password.Text)

Dim mailSender As New System.Net.Mail.SmtpClient()
mailSender.Host = "smtp.mail.yahoo.com"
mailSender.Port = 465
mailSender.EnableSsl = True
mailSender.Credentials = credential

So probably the first thing to check is this code. Is the host correct, and the port. Should SSL be enabled or not. You could test commenting out mailSender.Port and/or mailSender.EnableSsl

Is there a mistake in the password maybe? Perhaps the implicit conversion between Cyrillic and Latin scripts causes a wrong password or email address?

I am sorry, I can't really say more about this. If it keeps failing, you could search the net for Yahoo related code.

Good luck,

Johan

My advice is free, and you may get what you paid for.

Re: Sending mail from VB.NET code error

Mohammed.Al-Qaisi25-May-09 6:26

Mohammed.Al-Qaisi

25-May-09 6:26

is you working within Domain ,with ISA Server?

Problem with report generation

nazimghori14-May-09 22:40

nazimghori

14-May-09 22:40

Hello every one

I want to generate my design my report in excel for that i wrote code like:-

 Me.xl = CreateObject("Excel.Application")
        Me.xl.Workbooks.Add()
        xl.Visible = True

With Me.xl.Range("A" & ii, "E" & ii)

            .ColumnWidth = 20
            .Interior.ColorIndex = 14
end with

now i want to set the width of particular cell this works properly

now i want right and left justification of cell like cell "D"

so please suggest how should i approach....

thank you..

Smile | :)

Re: Problem with report generation

Dalek Dave14-May-09 23:20

Dalek Dave

14-May-09 23:20

nazimghori wrote:
now i want to set the width of particular cell this works properly

Columns("A:E").ColumnWidth = 20

nazimghori wrote:
now i want right and left justification of cell like cell "D"

If you want it like a particular cell try this...

Range("F4").Select<br />
    Selection.Copy<br />
    Range("H4").Select<br />
    Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _<br />
        SkipBlanks:=False, Transpose:=False

------------------------------------

"Possessions make you poor, wealth is measurable only in experience."
Sun Tzu 621BC

Regarding Winsock Control

specialdreamsin14-May-09 22:37

specialdreamsin

14-May-09 22:37

Hi all,

I want to list out all the System Names connected to my system in the LAN only. Like My Network Places link on Desktop will show all systems in Windows.

Ramesh Sambari

Knowledge is like honey.
Collect it, to make life sweet.

Re: Regarding Winsock Control

Zaegra14-May-09 23:06

Zaegra

14-May-09 23:06

See the Previous[^] answer I've given you.

Motivation is the key to software development.

Re: Regarding Winsock Control

Dave Kreskowiak15-May-09 2:30

Dave Kreskowiak

15-May-09 2:30

Do not start a second thread asking the same question. It's considered very rude and you still haven't explained what you mean by "conected to my system".

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Can we make the VB6.0 Application as Macro compatible?

rakesh_grbb14-May-09 20:13

rakesh_grbb

14-May-09 20:13

I have a Visual Basic6.0 application, which uses alorithms to calculate the results for one particular device. Everytime i have a minor changes in the Algorithm to have a different device. Example a device with some added features or removed features, this cannot be generalized to have a feature selections in the GUI as there may be a different device itself.

My question is it possible to have a Algorithm as a macro in my VB 6.0 Application(such as excel marcos), this way I need not change the execuatable everytime I can only change the marco. Or Is it possible to write a algorithm in a text file which will read the file as source code and behave the application as it is written in the text file?

Re: Can we make the VB6.0 Application as Macro compatible?

Johan Hakkesteegt15-May-09 0:11

Johan Hakkesteegt

15-May-09 0:11

If it is at all possible for you to not use vb6, it is possible in .NET:
See this article[^] which does it in C#.

My advice is free, and you may get what you paid for.

Declaring a array

nishkarsh_k14-May-09 17:20

nishkarsh_k

14-May-09 17:20

Hello every one,
I am working on a Vb.net 2005 application. I came across two ways to declare a array, i just wanted to know is there any difference between them

Dim iTestArray() As Integer

and

Dim iTestArray As Integer()

Regards
Nishkarsh

Re: Declaring a array

Dave Kreskowiak14-May-09 17:58

Dave Kreskowiak

14-May-09 17:58

No, there isn't.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Declaring a array

Zaegra14-May-09 23:03

Zaegra

14-May-09 23:03

First of all, an Array isn't the same as an Integer. An Integer can't hold multiple values. To dim an array you should use the following:

Dim ArrayName As Array

Or:

Dim ArrayListName As New ArrayList

The difference between these two is (again, as far as I know Roll eyes | :rolleyes:

) that the size of the ArrayList is dynamically increased when needed, and that the (regular) Array doens't do this.

Cheers,
Zaegra

Motivation is the key to software development.

Re: Declaring a array

Dave Doknjas15-May-09 15:21

Dave Doknjas

15-May-09 15:21

Nishkarsh's original array declarations are absolutely correct.
Your method of declaring it as 'Array' (System.Array) is generally the wrong thing to do. Declaring a variable of type 'Array' is a special purpose technique that is rarely required.

David Anton
http://www.tangiblesoftwaresolutions.com
Convert VB to C#, C++, or Java
Convert C# to VB, C++, or Java
Convert C++ to C#, VB, or Java
Convert Java to C#, C++, or VB

Re: Declaring a array

Zaegra16-May-09 2:03

Zaegra

16-May-09 2:03

Then please explain to me how I can store multiple values in an Integer? Because as far as I know an integer is just a number? WTF | :WTF:

Motivation is the key to software development.

Re: Declaring a array

Dave Doknjas16-May-09 4:11

Dave Doknjas

16-May-09 4:11

You can't store multiple values in an Integer.
This is just the syntax you use when declaring arrays.
i.e.,
Dim i() As Integer
or
Dim i As Integer()

The parenthesis pair after either the identifier or the type indicates that it's an array of Integer, not a single Integer.

David Anton
http://www.tangiblesoftwaresolutions.com
Convert VB to C#, C++, or Java
Convert C# to VB, C++, or Java
Convert C++ to C#, VB, or Java
Convert Java to C#, C++, or VB

Re: Declaring a array

Johan Hakkesteegt17-May-09 20:06

Johan Hakkesteegt

17-May-09 20:06

Zaegra wrote:
how I can store multiple values

Dim MyMixedValueArray() As Object

Dim MyMixedValueArray As Object()

My advice is free, and you may get what you paid for.

Re: Declaring a array

LCARS x3225-May-09 14:29

LCARS x32

25-May-09 14:29

I agree with David Anton.

Example:

'Declare the array:
Dim myIntArray(2) as Integer


myIntArray(0) = 9

myIntArray(1) = 8

myIntArray(2) = myIntArray(0) - myIntArray(1) 'The value becomes 1 (9 - 8)

That's how it's used.

-Ray

How Do I Insert Rows into a table dynamicly?

r_mohd14-May-09 16:36

r_mohd

14-May-09 16:36

Hi all,

Currently i am facing a problem when i try to insert rows in a table dynamicly. i using vb.net 2008 with mssql express 2008.here are the details of my codes

USE [database]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE [dbo].[TestSp]
(
@name nvarchar(50),
@tb varchar(200)
)
AS
BEGIN

SET NOCOUNT ON;

execute ('insert into ' + @tb +'(xname)values(@name)')

END

exec testsp 'testtable1','Abcxyz'

Error: Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@name".

please help me.

rmshah
Developer

Re: How Do I Insert Rows into a table dynamicly?

Mycroft Holmes14-May-09 16:41

Mycroft Holmes

14-May-09 16:41

Notice how you included the table name in the SQL string, do the same for the @Name value as well.

execute ('insert into ' + @tb +'(xname)values(' + @name +')')

Also use pre tags when posting code - easier to read

Never underestimate the power of human stupidity
RAH

Re: How Do I Insert Rows into a table dynamicly?

N a v a n e e t h14-May-09 17:19

N a v a n e e t h

14-May-09 17:19

r_mohd wrote:
execute ('insert into ' + @tb +'(xname)values(@name)')

That's a poor practice. Your code is open to SQL injection attacks. You need read SQL Injection Attacks and Some Tips on How to Prevent Them[^].

Navaneeth

How to use google | Ask smart questions

prime number

edubah14-May-09 14:55

edubah

14-May-09 14:55

output the first 10 prime number

gift

Re: prime number

Luc Pattyn14-May-09 15:27

Luc Pattyn

14-May-09 15:27

I know how to do that one: Console.WriteLine("2 3 5 7 11 13 17 19 23 29")

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Re: prime number

Dalek Dave14-May-09 21:31

Dalek Dave

14-May-09 21:31

OK, now do the first ten Happy Primes!

All Right, I will...

7, 13, 19, 23, 31, 79, 97, 103, 109, 139

------------------------------------

"Possessions make you poor, wealth is measurable only in experience."
Sun Tzu 621BC

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