detailsview is not getting filled using join

ALTER PROCEDURE dbo.usp_profile
	@user_id int
AS
	Begin
	SELECT     registration.user_id, registration.firstname, registration.lastname, registration.username, registration.state_id, registration.city_id, registration.pincode, 
                      registration.mobile_no, registration.phone_no, registration.e_mail, registration.address, registration.reg_date, state.state_name, city.city_name
FROM         registration INNER JOIN
                      state ON registration.state_id = state.state_id INNER JOIN
                      city ON registration.city_id = city.city_id AND state.state_id = city.state_id
					 
WHERE       registration.user_id = @user_id
	End

if (!IsPostBack)
       {
           SqlCommand cmd = new SqlCommand();
           cmd.CommandText = "usp_profile";
           cmd.CommandType = CommandType.StoredProcedure;
           cmd.Connection = con;
           cmd.Parameters.AddWithValue("@user_id",1);
           //Convert.ToInt16(Session["user_id"]));
           SqlDataAdapter da = new SqlDataAdapter(cmd);
           da.Fill(dt);
           ViewState["dt"] = dt;
           dvprofile.DataSource = dt;
           dvprofile.DataBind();
       }
        else
       {
          dt = (DataTable)ViewState["dt"];
       }