总是提示“Connection 属性尚未初始化”，什么原因，谢谢

Question

public class ConnectionToDB
{
   public static SqlConnection conn;
   public static SqlConnection getConnection()             
   { 
      try
      {
 conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=Shop");
        conn.Open();
      }
      catch(Exception e)
      {
        e.Message.ToString();
      }
      return conn;
   }
}
---------------------------------------------------------------------
public void updateSomeInfo(string strValueName)            
{
   try
   {
      conn=ConnectionToDB.getConnection();
      SqlCommand cmd=new SqlCommand("update_proc");
      cmd.CommandType=CommandType.StoredProcedure;      cmd.Parameters.Add("@valueName",SqlDbType.NVarChar,90);
      cmd.Parameters["@valueName"].Value=strValueName;      cmd.ExecuteNonQuery();          //这里开始出错
   }
   catch(Exception e)
   {
      e.Message.ToString();
   }
   conn.Close();
}
总是报“ExecuteReader:Connection属性尚未初始化”这个错误，帮忙看看，谢谢大家了

Answer 1

conn=ConnectionToDB.getConnection();
改为
SqlConnection conn=ConnectionToDB.getConnection();试试看

Answer 2

感觉楼主写的有点麻烦，ConnectionToDB类无所谓有无
SqlConnection conn=new SqlConnection("..");就好了啊

Answer 3

conn.Open(); //打开连接对象前加个判断试试
if(conn.State==ConnectionState.Close) //好象是这样写的?
{
    conn.Open();
}

Answer 4

SqlCommand cmd=new SqlCommand("update_proc", conn);--是否漏了连接对象