SP
CREATE procedure [dbo].[storeInfo]
@BehCode nvarchar(10)
as
begin
select Name,Image_Behcode,Tell,Description,address,about,(Keyword1+','+Keyword2+','+Keyword3+','+Keyword4) as keyword
from House_Info
where BehCode=@BehCode
end
Code
protected void Page_Load(object sender, EventArgs e)
{
string data = Server.UrlDecode(Request.QueryString["BehCode"]);
SqlCommand _cmd = new SqlCommand("storeInfo", _cn);
_cmd.CommandType = CommandType.StoredProcedure;
_cmd.Parameters.AddWithValue("@BehCode",data);
_cn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
while (_dr.Read())
{
this.Page.Title = _dr["Name"].ToString();
}
}