New operator (trying to understand)

[Morten Snedker]

As I understand the New operator is used to create a new instance of
an object, e.g:

Imports ss = System.data.sqlclient
....

Dim sCon As String, sql As String, dbCon As ss.SqlConnection
Dim dbCmd As ss.SqlCommand, dbReader As ss.SqlDataReader

sCon = "Server=blah;Database=bluh;Integrated Security=SSPI;"
sql = "SELECT bbr FROM SagsAktivitet ORDER BY bbr"

Try
dbCon = New ss.SqlConnection(sCon)
dbCon.Open()
dbCmd = New ss.SqlCommand(sql, dbCon)
dbReader = dbCmd.ExecuteReader
....


New is used on SqlConnection and on SqlCommand.

Why isn't it used on dbReader? Isn't dbReader an object that is
created?

Thanx for any enlightment!


/Snedker

 

[Chris]

As I understand the New operator is used to create a new instance of
an object, e.g:

Imports ss = System.data.sqlclient
...

Dim sCon As String, sql As String, dbCon As ss.SqlConnection
Dim dbCmd As ss.SqlCommand, dbReader As ss.SqlDataReader

sCon = "Server=blah;Database=bluh;Integrated Security=SSPI;"
sql = "SELECT bbr FROM SagsAktivitet ORDER BY bbr"

Try
dbCon = New ss.SqlConnection(sCon)
dbCon.Open()
dbCmd = New ss.SqlCommand(sql, dbCon)
dbReader = dbCmd.ExecuteReader
...


New is used on SqlConnection and on SqlCommand.

Why isn't it used on dbReader? Isn't dbReader an object that is
created?

Thanx for any enlightment!


/Snedker

The line dbCmd.ExecuteReader returns an instance of SqlDataReader for
you. So somewhere inside ExecuteReader they do the "new" for you
basically.

Chris

 

[_AnonCoward]

"Morten Snedker" <morten_spammenot_ATdbconsult.dk> wrote in message
:
: As I understand the New operator is used to create a new instance of
: an object, e.g:
:
: Imports ss = System.data.sqlclient
: ...
:
: Dim sCon As String, sql As String, dbCon As ss.SqlConnection
: Dim dbCmd As ss.SqlCommand, dbReader As ss.SqlDataReader
:
: sCon = "Server=blah;Database=bluh;Integrated Security=SSPI;"
: sql = "SELECT bbr FROM SagsAktivitet ORDER BY bbr"
:
: Try
: dbCon = New ss.SqlConnection(sCon)
: dbCon.Open()
: dbCmd = New ss.SqlCommand(sql, dbCon)
: dbReader = dbCmd.ExecuteReader
: ...
:
:
: New is used on SqlConnection and on SqlCommand.
:
: Why isn't it used on dbReader? Isn't dbReader an object that is
: created?
:
: Thanx for any enlightment!
:
:
: /Snedker


The new instance of the SQL data reader is created by the SQL command
object and the reference of that newly created object is assigned to the
dbReader variable.


Ralf
--