Populate DropDownList with Persian value from Database using C# in ASP.Net

nedash says:

(Transfer=@Transfer OR @Transfer = N'همه')

You above statement are correct. You need to use every time 'N' prefix unicode character. Because your characters are Persian language therefore without the N prefix the string is converted to the default code page of the database. This default code page may not recognize certain characters.

Indresh says:

You above statement are correct. You need to use every time 'N' prefix unicode character. Because your characters are Persian language therefore without the N prefix the string is converted to the default code page of the database. This default code page may not recognize certain characters.

 ok now how I can do above code for below SP becuse I have same problem in below SP:

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

nedash says:

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

Please explain in more detail on above statement. What you are trying to achieve.

   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

Hi nedash,

Please refer the below code.Use NVARCHAR data type in table fields and stored procedure parameters.

 C#

_cmd.Parameters.AddWithValue("@Type1", SqlDbType.NVarChar).Value = Lblallty.Text;
_cmd.Parameters.AddWithValue("@Type2", SqlDbType.NVarChar).Value = Lblapartman.Text;
_cmd.Parameters.AddWithValue("@Type3", SqlDbType.NVarChar).Value = LblEd.Text;
_cmd.Parameters.AddWithValue("@Type4", SqlDbType.NVarChar).Value = LblMa.Text;
_cmd.Parameters.AddWithValue("@Type5", SqlDbType.NVarChar).Value = LblMo.Text;
_cmd.Parameters.AddWithValue("@Type6", SqlDbType.NVarChar).Value = LblKo.Text;
_cmd.Parameters.AddWithValue("@Type7", SqlDbType.NVarChar).Value = Lblkarg.Text;
_cmd.Parameters.AddWithValue("@Type8", SqlDbType.NVarChar).Value = Lblsoole.Text;
_cmd.Parameters.AddWithValue("@Type9", SqlDbType.NVarChar).Value = LblVi.Text;
_cmd.Parameters.AddWithValue("@Type10", SqlDbType.NVarChar).Value = LblZa.Text;