Hi,

Code:
private void btnGEtDetails_Click(system event....)
{
if (txtAcctID.Text != "")
{

myConnection1.Open();

sqlDataAdapter1.SelectCommand.CommandText = "("SELECT (Name, ICNO) FROM Patient WHERE ACCTID ='"+txtAcctID.Text+"'")";

sqlDataAdapter1.SelectCommand.ExecuteNonQuery();

//fill in the txtName and txtICNO  with info from the Database

myConnection1.Close();
}
else
{
MessageBox.Show("Please fill in the Account ID text box","Reminder");
}
what id like the function to do is to get the NAME and Identity Card NO(ICNO) according to the ACCT ID and put the information into their respective textboxes...(txtName and txtICNO)

i havent compile this code yet....if there's a mistake pls show me where and the solution? (hope im not askin for much...just a beginner)

thx a million