BindDropDownList1(Ddltype, "Estate_TYC", "type");
protected void BindDropDownList1(DropDownList DDL, string spname, string dataTextfield)
{
using (SqlConnection conn = General.GetConnection())
{
using (SqlCommand _cmd = General.GetCommand(spname, conn))
{
_cmd.Parameters.AddWithValue("@Type1", Lblallty.Text);
_cmd.Parameters.AddWithValue("@Type2", Lblapartman.Text);
_cmd.Parameters.AddWithValue("@Type3", LblEd.Text);
_cmd.Parameters.AddWithValue("@Type4", LblMa .Text);
_cmd.Parameters.AddWithValue("@Type5", LblMo .Text);
_cmd.Parameters.AddWithValue("@Type6", LblKo.Text);
_cmd.Parameters.AddWithValue("@Type7", Lblkarg .Text);
_cmd.Parameters.AddWithValue("@Type8",Lblsoole .Text);
_cmd.Parameters.AddWithValue("@Type9", LblVi.Text);
_cmd.Parameters.AddWithValue("@Type10",LblZa .Text);
conn.Open();
SqlDataReader _dr = _cmd.ExecuteReader();
if (_dr.HasRows)
{
DDL.DataSource = _dr;
DDL.DataTextField = dataTextfield;
DDL.DataBind();
}
}
}
}
SP:
ALTER procedure [dbo].[Estate_TYC]
@Type1 nvarchar(20)
,@Type2 nvarchar(20)
,@Type3 nvarchar(20)
,@Type4 nvarchar(20)
,@Type5 nvarchar(20)
,@Type6 nvarchar(20)
,@Type7 nvarchar(20)
,@Type8 nvarchar(20)
,@Type9 nvarchar(20)
,@Type10 nvarchar(20)
as
begin
select Distinct Type
from Estate_Info
where Type=@Type1 or Type=@Type2 or Type=@Type3 or Type=@Type4 or Type=@Type5 or Type=@Type6
or Type=@Type7 or Type=@Type8 or Type=@Type9 or Type=@Type10
order by Type asc
end
according above SP I want bind dropdownlist from database but here becuse of persian language it bind some data I want it bind all data
I test it with english it worked correctly but when I change data to persian language it doesn't bind all data