using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()))
        {
            if (conn.State == ConnectionState.Closed) conn.Open();            SqlDataAdapter oleda = new SqlDataAdapter("telephoneCheck", conn);
            SqlParameter spt = new SqlParameter("@telepHoneNumber", SqlDbType.VarChar, 50);
            spt.Direction = ParameterDirection.Input;
            spt.Value = telepHoneNumber;
            oleda.SelectCommand.Parameters.Add(spt);
            DataTable dt = new DataTable();        
             oleda.Fill(dt);
      
            if (dt.Rows.Count < 1)
                    {
                        conn.Close();
                        return false;
                    }
                 conn.Close();
                 return true;       
        
        }
CREATE PROCEDURE telephoneCheck
@telepHoneNumber varchar(50)
AS
select city,cardtype from list2 where num=@telepHoneNumber;
GO那里出错了!!为什么提示附近有语法错误啊!!!如果不用存储过程就可以啊!!