OleDb problems returning single records

Question

Hi guys, hopefully someone can help me with this one. I have no problems getting a table of data into a dataGrid. My problem is that i can't get a SELECT statement to return just one record.
I think my problem lies with the dataAdapter because i can successfully add,delete and update records BUT they don't appear, added,deleted or updated until i close and reopen the program and reload the table into the datagrid. Therefore i feel it's something to do with updating the dataSet????

I'm trying to return a single record from a search using a textBox. Can anyone confirm that this
code should work...

string select =
"SELECT Name,Address1,Address2,Address3,PostCode FROM Churches "+
"WHERE PostCode = '" + txtPostCode.Text +"'";

updateCmd.CommandText = select;

updateCmd.Connection = updateConn;

updateCmd.Parameters.Add("name",OleDbType.Char,255,"Name").Value = "";
updateCmd.Parameters.Add("address1",OleDbType.Char,255,"Address1").Value = "";
updateCmd.Parameters.Add("address2",OleDbType.Char,255,"Address2").Value = "";
updateCmd.Parameters.Add("address3",OleDbType.Char,255,"Address3").Value = "";
updateCmd.Parameters.Add("postCode",OleDbType.Char,255,"PostCode").Value =txtPostCode.Text;

updateConn.Open();

try

{

cmd.ExecuteNonQuery();
//is there some i should have here to get the new single record displayed onto the dataGrid????

}

catch (OleDbException e1)

{

MessageBox.Show(e1.ToString());

}
updateConn.Close();
updateCmd.Parameters.Clear();
}

It would solve so many headaches if i knew the missing code. I get no errors by the way, so i know the query is passing, i've even had the query pass returned to check it.

Any help is appreciated very much, thanks guys