Showing posts with label Dispose in C#. Show all posts
Showing posts with label Dispose in C#. Show all posts

Monday 23 January 2012

Dispose in C#

dispose() method releases the memory from the variable,
we define the dispose when the variable is in not use,
this variable can be reused again.
eg:
func()
{
sqlcommand cmd=new sqlcommand()
datareader dr;

cmd=new sqlcommand("select* from emp",con)
dr=cmd.executreader;
cmd.dispose();
dr.close();

cmd=new sqlcommand("select* from dept",con)
dr=cmd.executreader;
cmd.dispose();
dr.close();

cmd=new sqlcommand("select* from salgrade",con)
dr=cmd.executreader;
cmd.dispose();
dr.close();

}
cmd.executereader();
cmd.dispose();