ASP.NET

public static void LoadData(string connectionString, string procedure)
{
	SqlDataReader reader = null;
	SqlConnection conn = null;

	try
	{
		//instantiate dbc
		conn = new SqlConnection(connectionString);
		conn.Open();

		//build command
		SqlCommand sqlCmd = new SqlCommand(procedure, conn);
		sqlCmd.CommandType = CommandType.StoredProcedure;

		//run command
		reader = sqlCmd.ExecuteReader();

		//here will use the data in the reader
		while (reader.Read())
		{
			//
		}
	}
	catch (Exception e)
	{
		throw e;
	}
	finally 
	{
		if (reader != null)
		{
			reader.Close();
		}
		if (conn != null)
		{
			conn.Close();
			conn.Dispose();
		}
	}
}

Cannot drop the database 'TestDatabase' because it is currently in use.

CheckBox ch = new CheckBox ();<br />
        int count=0;<br />
        foreach ( GridViewRow r in gw.Rows )<br />
        {<br />
            if(((CheckBox)r.FindControl( "ch1" )).Checked)<br />
                count++;<br />
        }