VB.NET Equivalent of C#

[BG12424]

Is there a VB.NET equivalent (More of a work-around) to the C# using keyword in the ability to return execution to the original routine. I know that VB.NET does not have this ability, but wondering what is recommended for VB.NET.

For example if I want to return a DataReader and once I'm done looping through the reader, return execution back to the method which gave me the reader object:

public static OleDbDataReader LendReader(string sql)
{
  using (OleDbConnection conn = CreateConnection())
  {
    conn.Open()
    OleDbCommand c = new OleDbCommand(sql,conn);
    OleDbDataAdapter r = c.ExecuteReader();
    return r;
  }
}

regards,
Brian

http://www.gainesconsulting.com

The problem with doing something right the first time is that nobody appreciates how difficult it was.

 

[BoulderBum]

The VB.NET "equivalent" is a Try Catch Finally block that disposes of the objects in Finally. There's nothing quite so clean as the "using" construct in VB.NET currently, though as I understand VS 2005 will have "Using" for the language.

 

[BG12424]

Thank you.

regards,
Brian

http://www.gainesconsulting.com

The problem with doing something right the first time is that nobody appreciates how difficult it was.

 

[BG12424]

Sounds like I need to add the reader to the method which lends itself out..

regards,
Brian

http://www.gainesconsulting.com

The problem with doing something right the first time is that nobody appreciates how difficult it was.