HI pal,
This is one way try it
concatenate and trim the data into where you want keep it .........
SqlCommand cmd = new SqlCommand("Select distinct Branch,Emp_id,UPPER(First_name+' '+Last_name) from Userinfo where User_name = '" + Session["userName"].ToString() + "'", con);
while (dr.Read())
{
tbbranch.Text = dr["Branch"].ToString().Trim();
tbempid.Text = dr["Emp_id"].ToString().Trim();
tbempname.Text = tbbranch.Text +" "+ tbempid.Text ;
}.