ASP.NET - using(sqlcommand cmd=new sqlcommand)

hii all,
  
  can u tel me the difference between
sqlcommand cmd=new sqlcommand();
and
using(sqlcommand cmd=new sqlcommand());

same as for sqldataadapter also

hi,

using(SqlCommand cmd = new SqlCommand())

{

    ...

}

is equivalent to writing,

SqlCommand cmd = new SqlCommand();

try

{

    ...

}

 

finally

{

    cmd.Dispose();

}

 

Object.Dispose()

Actually Using statement defines a scope, outside of which an object or objects will be disposed.
So its avoid overhead of disposing the object manually in finally block or end of working with object.

Great post! informative and useful sharing.