再次！“连接未关闭。连接的当前状态为已打开。”

再次求助！“连接未关闭。连接的当前状态为已打开。”
下边是全部代码，我实在整不了了
[code=C#][/code]using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page
{
  SqlConnection sms_conn;
  string sms_sqlstr;
  protected void Page_Load(object sender, EventArgs e)
  {
  string sms_connstr = "Data Source=20110721-1509\\sqlexpress;Initial Catalog=find;Integrated Security=True";
  sms_conn = new SqlConnection(sms_connstr);
  }


  protected void LinkButton1_Click(object sender, EventArgs e)
  {


  string sqlstr = "select * from ziliao where taname='" + TextBox1.Text + "'and taname='" + TextBox2.Text + "'and myname='" + TextBox4.Text + "'and mycity='" + TextBox5.Text + "'";

  SqlCommand cmd = new SqlCommand(sqlstr, sms_conn);
  sms_conn.Open();
  SqlDataReader dr = cmd.ExecuteReader();
   
  if (dr.Read() == true)
  {
  Response.Write("here");
  sms_conn.Close();
  }
   
  else
  {
  sms_sqlstr = "insert into ziliao(myname,mycity,email,taname,tacity)values(" + TextBox1.Text + "," + TextBox2.Text + "," + TextBox3.Text + "," + TextBox4.Text + "," + TextBox5.Text + ")";
  SqlCommand cmd2 = new SqlCommand(sms_sqlstr, sms_conn);
  sms_conn.Open();
  cmd2.ExecuteNonQuery();
  sms_conn.Close();

  };

  }
   
   
   
}

[解决办法]
很混乱，sms_conn.Open应该只在一个地方调用，sms_conn.Close也是，

这个提示应该是在else分支内产生的，在SqlDataReader dr = cmd.ExecuteReader()之前就已经open过一次了，然后在else里又open一次，当然会出这个错误，

[解决办法]

C# code

using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.WebControls.WebParts;using System.Web.UI.HtmlControls;using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page{    SqlConnection sms_conn;    string sms_sqlstr;    protected void Page_Load(object sender, EventArgs e)    {        string sms_connstr = "Data Source=20110721-1509\\sqlexpress;Initial Catalog=find;Integrated Security=True";        sms_conn = new SqlConnection(sms_connstr);    }    protected void LinkButton1_Click(object sender, EventArgs e)    {        sms_conn.Open();        string sqlstr = "select * from ziliao where taname='" + TextBox1.Text + "'and taname='" + TextBox2.Text + "'and myname='" + TextBox4.Text + "'and mycity='" + TextBox5.Text + "'";        SqlCommand cmd = new SqlCommand(sqlstr, sms_conn);        SqlDataReader dr = cmd.ExecuteReader();        bool hd = dr.Read();        dr.Dispose();        if (hd)        {            Response.Write("here");        }        else        {            sms_sqlstr = "insert into ziliao(myname,mycity,email,taname,tacity)values(" + TextBox1.Text + "," + TextBox2.Text + "," + TextBox3.Text + "," + TextBox4.Text + "," + TextBox5.Text + ")";            cmd.CommandText = sms_sqlstr;            cmd.ExecuteNonQuery();        }        cmd.Dispose();        sms_conn.Close();    }}