SqlDataReader 应用

public   void  GetProductName()
     ... {
        string sql = "select * from tblPage where id='" + guid +"'";
        
        // String ConnStr = "Server=(local);User id=sa;Pwd=;Database=xinwen";
        SqlConnection SqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["yaoconn"].ConnectionString);
        SqlConn.Open();
        SqlCommand comm = new SqlCommand(sql, SqlConn);
        SqlDataReader rdr = comm.ExecuteReader();
        while (rdr.Read())
        ...{
           ProductName= rdr["Product"].ToString();
        }
        rdr.Close();
        SqlConn.Close();
      
      
    }