C Programming to connect to access database
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!!";
}
}
}