// Create the connection and connect then execute sql statement
string str = "SELECT EmployeeID, FirstName, LastName FROM Employees";
SqlCommand myDataReader = new SqlCommand(str, con);
myDataReader.Read();
if (myDataReader.HasRows)
{
while (myDataReader.Read())
{
txtFName.Text = myDataReader.GetString("FName").ToString();
txtLName.Text = myDataReader.GetString("LName").ToString();
txtNName.Text = myDataReader.GetString("EmployeeID").ToString();
}
}
else
{
MessageBox.Show("No matches were found, try again.");
}
myDataReader.Close();
Regards.