Accesing aSQL view from C#

When I try to access a SQL Saved view calleed FilteredLead I do not get 
anythin back on asp.net if I run same SQL command on the SQL Editor I get 
all my results. Is it any way to use views in C# diffrent than tables ?

See my code



        MyString = "SELECT * from FilteredLead";
        //where fullname like '%ja%'
        SqlConnection myConnection = new 
SqlConnection("server=TEST;database=CRMTEST_MSCRM;UID=Joe;PWD=xxxx");

        SqlCommand myCommand = new SqlCommand(MyString, myConnection);
        SqlDataReader reader;

        string tempTotal = "";

        try
        {
            myConnection.Open();
            reader = myCommand.ExecuteReader();
            while (reader.Read())
            {
                Response.Write(reader[0].ToString());
            }
        }
        catch (SqlException ex)
        {
            Response.Write(ex.ToString());
        }





Thanks