为什么每刷新一次页面,从服务器的进程中都可以看到内存增加?

Question

主页代码如下:protected void Page_Load(object sender, EventArgs e)
    {      try 
      {
          if (!IsPostBack)
          {              Sp mysp = new Sp();
              SqlDataReader sdr = mysp.Getinf("select burl,bext,bheight,blink from binner_list where bpath='首页' and bvisiable=1");  //生成首页flash              titleurl = new StringBuilder();
              if (sdr.Read())
              {
                  if (sdr[1].ToString().Trim() == ".swf")
                  {
                      titleurl.Append("<table width=" + "\"950\"" + " border=" + "\"0\"" + " align=" + "\"center\"" + " cellpadding=" + "\"0\"" + " cellspacing=" + "\"0\"" + ">");
                      titleurl.Append(" <tr>");
                      titleurl.Append("<td><object classid=" + "\"clsid:D27CDB6E-AE6D-11cf-96B8-444553540000\"" + " codebase=" + "\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0\"" + " width=" + "\"950\"" + " height=" + "\"" + sdr[2].ToString() + "\"" + ">");
                      titleurl.Append(" <param name=" + "\"movie\"" + " value=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + ">");
                      titleurl.Append(" <param name=" + "\"quality\"" + " value=" + "\"high\"" + ">");
                      titleurl.Append(" <embed src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " quality=" + "\"high\"" + " pluginspage=" + "\"http://www.macromedia.com/go/getflashplayer\"" + " type=" + "\"application/x-shockwave-flash\"" + " width=" + "\"950\"" + " height=" + "\"" + sdr[2].ToString() + "\"" + "></embed>");
                      titleurl.Append("</object></td>");
                      titleurl.Append("</tr>");
                      titleurl.Append("<tr>");
                      titleurl.Append(" <td height=" + "\"6\"" + "></td>");
                      titleurl.Append(" </tr>");
                      titleurl.Append("</table>");
                  }
                  else
                  {                      titleurl.Append("<table width=" + "\"950\"" + " border=" + "\"0\"" + " align=" + "\"center\"" + " cellpadding=" + "\"0\"" + " cellspacing=" + "\"0\"" + ">");
                      titleurl.Append("<tr>");
                      if (sdr[3].ToString().Trim() == "#")
                          titleurl.Append("<td><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"950\"" + "></td>");
                      else
                          titleurl.Append("<td><a target=" + "\"_blank\"" + " href=" + "\"" + sdr[3].ToString().Trim() + "\"" + "><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"950\"" + " border=" + "\"1\"" + "height=" + "\"100\"" + "></a></td>");
                      titleurl.Append("</tr>");
                      titleurl.Append("<tr>");
                      titleurl.Append("<td height=" + "\"6\"" + "></td>");
                      titleurl.Append("</tr>");
                      titleurl.Append("</table>");                  }              }
              sdr.Close();
              mysp.conn.Close();              sdr = mysp.Getinf("select burl,blink from binner_list where bpath='首页1' and bvisiable=1");  //生成首页1
              s1 = new StringBuilder();
              if (sdr.Read())
              {                  s1.Append("<table width=" + "\"950\"" + " border=" + "\"0\"" + " align=" + "\"center\"" + " cellpadding=" + "\"0\"" + " cellspacing=" + "\"0\"" + ">");
                  s1.Append("<tr>");
                  if (sdr[1].ToString().Trim() == "#")
                      s1.Append("<td><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"950\"" + "></td>");
                  else
                      s1.Append("<td><a target=" + "\"_blank\"" + " href=" + "\"" + sdr[1].ToString().Trim() + "\"" + "><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"950\"" + " border=" + "\"0\"" + "></a></td>");
                  s1.Append("</tr>");
                  s1.Append("<tr>");
                  s1.Append("<td height=" + "\"6\"" + "></td>");
                  s1.Append("</tr>");
                  s1.Append("</table>");              }
              sdr.Close();
              mysp.conn.Close();
              sdr = mysp.Getinf("select burl,blink from binner_list where bpath='首页右中' and bvisiable=1");  //生成首页右中
              yz = new StringBuilder();
              if (sdr.Read())
              {
                  if (sdr[1].ToString().Trim() == "#")
                      yz.Append("<img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"198\"" + " border=" + "\0\"" + ">");
                  else
                      yz.Append(
"<a target=" + "\"_blank\"" + " href=" + "\"" + sdr[1].ToString() + "\"" + "><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"198\"" + " border=" + "\0\"" + "></a>");
              }
              sdr.Close();
              mysp.conn.Close();

Answer 1

 sdr = mysp.Getinf("select burl,blink from binner_list where bpath='首页2' and bvisiable=1");  //生成首页2
              s2 = new StringBuilder();
              if (sdr.Read())
              {                  s2.Append("<table width=" + "\"950\"" + " border=" + "\"0\"" + " align=" + "\"center\"" + " cellpadding=" + "\"0\"" + " cellspacing=" + "\"0\"" + ">");
                  s2.Append("<tr>");
                  if (sdr[1].ToString().Trim() == "#")
                      s2.Append("<td><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"950\"" + "></td>");
                  else
                      s2.Append("<td><a target=" + "\"_blank\"" + " href=" + "\"" + sdr[1].ToString() + "\"" + "><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"950\"" + " border=" + "\"0\"" + "></a></td>");
                  s2.Append("</tr>");
                  s2.Append("<tr>");
                  s2.Append("<td height=" + "\"6\"" + "></td>");
                  s2.Append("</tr>");
                  s2.Append("</table>");              }
              sdr.Close();
              mysp.conn.Close();
              sdr = mysp.Getinf("select burl,blink from binner_list where bpath='首页3' and bvisiable=1");  //生成首页3
              s3 = new StringBuilder();
              if (sdr.Read())
              {                  s3.Append("<table width=" + "\"950\"" + " border=" + "\"0\"" + " align=" + "\"center\"" + " cellpadding=" + "\"0\"" + " cellspacing=" + "\"0\"" + ">");
                  s3.Append("<tr>");
                  if (sdr[1].ToString().Trim() == "#")
                      s3.Append("<td><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"950\"" + "></td>");
                  else
                      s3.Append("<td><a target=" + "\"_blank\"" + " href=" + "\"" + sdr[1].ToString() + "\"" + "><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"950\"" + " border=" + "\"0\"" + "></a></td>");
                  s3.Append("</tr>");
                  s3.Append("<tr>");
                  s3.Append("<td height=" + "\"6\"" + "></td>");
                  s3.Append("</tr>");
                  s3.Append("</table>");              }
              sdr.Close();
              mysp.conn.Close();
              sdr = mysp.Getinf("select datediff(d,getdate(),'2008-08-08'),month(getdate()),day(getdate()),year(getdate())");
              odate = new StringBuilder();
              oyd = new StringBuilder();
              if (sdr.Read())
              {
                  odate.Append(sdr[0].ToString());
                  oyd.Append(sdr[3].ToString() + " 年" + sdr[1].ToString() + '月' + sdr[2].ToString() + '日');
              }
              sdr.Close();
              mysp.conn.Close();              sdr = mysp.Getinf("select * from head_inf");
              headurl = new StringBuilder();
              footurl = new StringBuilder();
              if (sdr.Read())
              {
                  headurl.Append(sdr[1].ToString());
                  footurl.Append(sdr[2].ToString());              }
              sdr.Close();
              mysp.conn.Close();

Answer 2

              sdr.Close();   //新闻
              mysp.conn.Close();
              DataSet nds = mysp.Getdateset("select top 10 ntitlehtml,ndate,id from new_list order by nsort asc,ndate desc");
              Repeater1.DataSource = nds;
              Repeater1.DataBind();
              nds.Dispose();              // 就业明星
              sdr = mysp.Getinf("select top 1 * from jobok_list where jtop='(本)' order by jdate desc ");
              jimage = new StringBuilder();
              jname = new StringBuilder();
              jtitle = new StringBuilder();
              jdesire = new StringBuilder();
              jcompany = new StringBuilder();
              if (sdr.Read())
              {
                  jimage.Append(sdr[6].ToString());
                  jname.Append(sdr[1].ToString());
                  jtitle.Append(sdr[2].ToString());
                  jdesire.Append(sdr[5].ToString());
                  jcompany.Append(setstr(sdr[4].ToString(), 13));
              }
              sdr.Close();
              mysp.conn.Close();
              //成功就业
              DataSet jds = mysp.Getdateset("select top 8 * from jobok_list order by jdate desc");
              Repeater2.DataSource = jds;
              Repeater2.DataBind();
              jds.Dispose();              //招聘信息
              DataSet jjds = mysp.Getdateset("select top 5 * from job_list order by jdate desc");
              Repeater3.DataSource = jjds;
              Repeater3.DataBind();
              jjds.Dispose();
              jjds.Dispose();
              //评价
              DataSet pds = mysp.Getdateset("select top 3 * from pj_list order by psort desc");
              Repeater4.DataSource = pds;
              Repeater4.DataBind();
              pds.Dispose();
              pds.Dispose();
              //考试认证
              DataSet eds = mysp.Getdateset("select top 3 * from exam_list order by edate desc");
              Repeater5.DataSource = eds;
              Repeater5.DataBind();
              eds.Dispose();              //新生答疑
              DataSet ads = mysp.Getdateset("select top 5 atitle,id,ainf from answer_list order by asort desc");
              Repeater6.DataSource = ads;
              Repeater6.DataBind();
              ads.Dispose();              //校园生活
              DataSet lds = mysp.Getdateset("select top 7 * from live_list order by lsort asc,ldate asc");
              Repeater7.DataSource = lds;
              Repeater7.DataBind();
              lds.Dispose();
              // 历史专题
              DataSet hds = mysp.Getdateset("select top 2 * from history_list order by hsort asc");
              Repeater8.DataSource = hds;
              Repeater8.DataBind();
              hds.Dispose();

Answer 3

   //学员作品
              sdr = mysp.Getinf("select top 8 wurl4,usoft,id,usoft   from work_list where ustatus='是' order by udate desc  ");
              int i = 0;
              // worklist = new String[8];
              //worktitle = new String[8];              worklist = new StringBuilder[8];
              worktitle = new StringBuilder[8];
              while (sdr.Read())
              {
                  //worklist[i] = "<td bgcolor=" + "\"#FFFFFF\"" + "><a target=" + "\"_blank\"" + " href=" + "\"studentworklist-" + sdr[2].ToString() + ".html\"" + "><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"160\"" + " height=" + "\"120\"" + " border=" + "\"0\"" + "></a></td>";
                  //worktitle[i] = sdr[3].ToString();                  worklist[i] = new StringBuilder("<td bgcolor=" + "\"#FFFFFF\"" + "><a target=" + "\"_blank\"" + " href=" + "\"studentworklist-" + sdr[2].ToString() + ".html\"" + "><img src=" + "\"asdimnino/" + sdr[0].ToString() + "\"" + " width=" + "\"160\"" + " height=" + "\"120\"" + " border=" + "\"0\"" + "></a></td>");
                  worktitle[i] = new StringBuilder(sdr[3].ToString());                  i++;
              }              sdr.Close();
              mysp.conn.Close();              //  精彩图片
              sdr = mysp.Getinf("  select top 10 pic_type.id,pic_list.psort,padr,pic_list.ptype from pic_type,pic_list where pic_type.pname=pic_list.ptype order by pic_list.psort desc,pic_type.psort asc");
              i = 0;
              //piclist = new String[10];
              //pictitle = new String[10];
              piclist = new StringBuilder[10];
              pictitle = new StringBuilder[10];
              while (sdr.Read())
              {
                  //piclist[i] = "<td><a href=" + "\"tedian_all-" + sdr[0].ToString() + ".html\"" + "><img src=" + "\"asdimnino/" + sdr[2].ToString() + "\"" + " width=" + "\"120\"" + " height=" + "\"90\"" + " border=" + "\"0\"" + "></a></td>";
                  //pictitle[i] = sdr[3].ToString();                  piclist[i] = new StringBuilder("<td><a href=" + "\"tedian_all-" + sdr[0].ToString() + ".html\"" + "><img src=" + "\"asdimnino/" + sdr[2].ToString() + "\"" + " width=" + "\"120\"" + " height=" + "\"90\"" + " border=" + "\"0\"" + "></a></td>");
                  pictitle[i] = new StringBuilder(sdr[3].ToString());
                  i++;
              }              sdr.Close();
              mysp.conn.Close();
              // 新课快弟
              DataSet zzs = mysp.Getdateset("select top 6 id,htitle,hlink from newlesson_list order by hsort asc");
              Repeater9.DataSource = zzs;
              Repeater9.DataBind();
              zzs.Dispose();              //取得ip地址               if (Session["vp"] == null)
              {                  //    mysp.Execsql("insert into visit_log (vip,ubrowser,vsee,vos) values('" + Request.UserHostAddress.ToString() + "','" + Request.Browser.Browser.ToString() + "','" + System.Windows.Forms.Screen.PrimaryScreen.Bounds.Right.ToString() + "*" + System.Windows.Forms.Screen.PrimaryScreen.Bounds.Bottom.ToString() + "','" + Request.Browser.Platform.ToString() + "')");
                  IPAccess ipaccess = new IPAccess();
                  string[] ip = ipaccess.GetCustomCity();
                  StringBuilder pp = new StringBuilder(ip[1].ToString() + ip[0].ToString());
                  mysp.Execsql("insert into visit_log (vip,ubrowser,vsee,vos) values('" + Request.UserHostAddress.ToString() + "','" + Request.Browser.Browser.ToString() + "','" + pp + "','" + Request.Browser.Platform.ToString() + "')");
                  Session["vp"] = "zxp";
                  ipaccess = null;
              }
              
              mysp = null;
          }
      }
      catch
      {
          Response.Redirect("index.aspx");
      }    }

Answer 4

 引用的基类如下:    public SqlDataReader Getinf(string mysql)
    {
        if (Conndb())
        {            SqlCommand cmd = new SqlCommand(Newtext(mysql),conn);           
            return cmd.ExecuteReader();
                                             
        
        }
        else
            return null;
        
    }  public DataSet  Getnewlist()
    {
        try
        {
            if (Conndb())
            {
                SqlDataAdapter sdr = new SqlDataAdapter("select * from new_list order by nsort asc,ndate desc", conn);
                DataSet ds = new DataSet();
                sdr.Fill(ds, "new_list");
                conn.Close();
                return ds;            }
            else
            {
                conn.Close();
                return null;
           }        }
        catch
        {
          //  conn.Close(); 
            return null;
        
        }
    
    
    }

Answer 5

不知道StringBuilder每次用完都把里面内容remove掉会不会好点，猜得

Answer 6

stringbuilder 如何释放?需要释放吗?