how to get value in textboxes from database through datareader

string str1 = "Select Name from Login where Login='" + EmpID.Text + "'";
SqlCommand cmd1 = new SqlCommand(str1, con1);

cmd1.ExecuteNonQuery();

SqlDataReader dr;
dr = cmd1.ExecuteReader();
if (dr.HasRows)
{
dr.Read();

txtEmpName.Text = Convert.IsDBNull(dr["EmpName "]) ? "" : Convert.ToString(dr["EmpName "]);
}

string str="select LastName,FirstName from Employee";
SqlCommand cmd=new SqlCommand(str);
con.Open();
SqlDataReader dr=cmd.ExecuteReader();
while(dr.Read())
{
textbox1.Text=dr[0].ToString();
}
con.Close();

string strEmpName = TextBox1.Text;
cmd = new SqlCommand("SELECT empname FROM emptable WHERE id ='"+id+"'", sqlcon);
con.Open();
cmd.ExecuteNonQuery();
SqlDataReader dr;
dr = cmd1.ExecuteReader();
if (dr.HasRows)
{
dr.Read();

txtEmpName.Text = Convert.IsDBNull(dr["empname "]) ? "" : Convert.ToString(dr["strEmpName"]);
}
con.Close();