What is using?

[Paulo]

using (OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStr ings["Access"].ConnectionString))
{
using (OleDbCommand command = new OleDbCommand(strSQL, connection))
{
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...
}
}

What is diference? Any performance improvement? I found the code above on a
starter kit

OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStr ings["Access"].ConnectionString)
OleDbCommand command = new OleDbCommand(strSQL, connection)
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
....

VS 2005 asp.net 2.0 C#

Thanks!

[Mark Fitzpatrick]

Using in this context allows for automatic displosal and garbage collection
of the objects.
--

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - Expression

"Paulo" <pr*****@uol.com.brwrote in message
news:ef*************@TK2MSFTNGP04.phx.gbl...

using (OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStr ings["Access"].ConnectionString))
{
using (OleDbCommand command = new OleDbCommand(strSQL, connection))
{
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...
}
}

What is diference? Any performance improvement? I found the code above on
a starter kit

OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStr ings["Access"].ConnectionString)
OleDbCommand command = new OleDbCommand(strSQL, connection)
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...

VS 2005 asp.net 2.0 C#

Thanks!

[George Ter-Saakov]

http://davidhayden.com/blog/dave/arc...01/13/773.aspx

George

"Paulo" <pr*****@uol.com.brwrote in message
news:ef*************@TK2MSFTNGP04.phx.gbl...

using (OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStr ings["Access"].ConnectionString))
{
using (OleDbCommand command = new OleDbCommand(strSQL, connection))
{
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...
}
}

What is diference? Any performance improvement? I found the code above on
a starter kit

OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionStr ings["Access"].ConnectionString)
OleDbCommand command = new OleDbCommand(strSQL, connection)
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...

VS 2005 asp.net 2.0 C#

Thanks!

[IfThenElse]

Very good.
"George Ter-Saakov" <gt****@cardone.comwrote in message
news:O%****************@TK2MSFTNGP03.phx.gbl...

>
http://davidhayden.com/blog/dave/arc...01/13/773.aspx

George

"Paulo" <pr*****@uol.com.brwrote in message
news:ef*************@TK2MSFTNGP04.phx.gbl...

>using (OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionSt rings["Access"].ConnectionString))
{
using (OleDbCommand command = new OleDbCommand(strSQL, connection))
{
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...
}
}

What is diference? Any performance improvement? I found the code above on
a starter kit

OleDbConnection connection = new
OleDbConnection(ConfigurationManager.ConnectionSt rings["Access"].ConnectionString)
OleDbCommand command = new OleDbCommand(strSQL, connection)
command.CommandType = CommandType.Text;
command.Parameters.Add(new OleDbParameter("@AlbumID", albumid));
command.Parameters.Add(new OleDbParameter("@Size", (int)size));
...

VS 2005 asp.net 2.0 C#

Thanks!