private void btnSeek_Click(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection("user id=1234;data source=FX11;password=1234");
OracleCommand comm = new OracleCommand("SELECT * FROM MYTABLE WHERE EMP_NUMBER = '" + txtSeek.Text + "'");
comm.Connection = conn;
conn.Open();
OracleDataReader dr = comm.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
txtEmpID.Text=dr.GetString(0);
txtLname.text=dr.GetString(1);
txtFname.text=dr.GetString(2);
}
dr.Close();
}
conn.Close();
}

there is a problem on the above codes, can some one help me?
if the user searches for employee's ID, the data will show on txtEmpID, txtLname and txtFname.

in VB6 simply as these:
txtEmpID.Text=rs(0)
txtLname.text=rs(1)
txtFname.text=rs(2)

tnx.