Im trying to write some simple code that will allow me to search an access database by the primary key and display the record. For the life of me I can't work out why every time I run the code and do a search it says that the record cannot be found, even though I know I'm searching an existing customer number (primary key).

I have very limited knowledge of programming so any help would be great.

The code I have is:

Code:
protected void searchClicked(object sender, EventArgs e)
    {
        OleDbConnection con = null;
        OleDbCommand myCommand = null;
        OleDbDataReader myReader=null;
        string connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("amazonia280.mdb")+";";
            if (SCust_No.Text.Length>0)
            {
                con=new OleDbConnection(connectionString);
                try
                {
                    con.Open();
                }
                catch (Exception exc)
                {
                    Console.WriteLine("Problem opening connection");
                }
                myCommand = new OleDbCommand("Select Cust_No, Cust_Name, Address, email, telno From Customer where Cust_No like '%<SCust_No.Text>%'", con);
                myReader = myCommand.ExecuteReader();
                if (myReader.Read())
                {
                    Cust_No.Text = myReader.GetString(0);
                    Cust_Name.Text = myReader.GetString(1);
                    Address.Text = myReader.GetString(2);
                    email.Text = myReader.GetString(3);
                    telno.Text = myReader.GetString(4);
                    myReader.Close();
                    con.Close();
                    SCust_NoError.Text="";
                    enableSearch(false);
                }
                else
                {
                    myReader.Close();
                    con.Close();
                    SCust_NoError.Text="Customer Number not Found!!";
                }
}
}