Hi Dipika,
You can use
Close method for SqlDataReader object to close the current datareader, and this should be very next when you complete your process.
e.g
reader.Close();
in the above comment you mention to check
if(connect.State == ConnectionState.Closed)
{
connect.Open();
}
could you please let me know object "connect" is the object for your SqlConnection class. if so then you are doing right checking for connection.
to close the current open connection for SqlConnection Class use
if(connect.State== ConnectionState.Open)
{
connect.Close();
}