Hi Vasanth057,
You can also make it by using connected architecture by DataReader concept.
string constring = ConfigurationManager.ConnectionStrings["ConStr1"].ConnectionString;
SqlConnection con = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand("sp_attach", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@id", Emp_id);
cmd.Parameters.AddWithValue("@Name", Task);
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
sdr.Read();
txtOrderID.Text = Convert.ToString(sdr["EmployeeName"]);
txtCustomerID.Text = Convert.ToString(sdr["Task_Time"]);
con.Close();