detailsview没有使用join填充 [英] 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

这是我的存储过程

和代码。

this is my stored procedure
and code.

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"];
       }

这里详细信息视图没有填满我不知道为什么..

here the detailsview is not getting filled i don''t know why..

推荐答案

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
					 
WHERE       registration.user_id = @user_id
	End

这篇关于detailsview没有使用join填充的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！