[RESOLVED] Alphabetic Paging

Hi, Could you please help me on the issue of using the ASCII value of Georgian language characters. How can I change the english alphabet? I cannot retrive data since my contact list is in Georgian language. Here is the code:

public partial class alfabet : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                ViewState["CurrentAlphabet"] = "ALL";
                this.GenerateAlphabets();
                this.BindDataList();
            }
        }

        public class Alphabet
        {
            private string _value;
            private bool _isNotSelected;

            public string Value
            {
                get
                {
                    return _value;
                }
                set
                {
                    _value = value;
                }
            }

            public bool isNotSelected
            {
                get
                {
                    return _isNotSelected;
                }
                set
                {
                    _isNotSelected = value;
                }
            }
        }

        private void GenerateAlphabets()
        {
            List alphabets = new List();
            Alphabet alphabet = new Alphabet();
            alphabet.Value = "ALL";
            alphabet.isNotSelected = !alphabet.Value
                        .Equals(ViewState["CurrentAlphabet"]);
            alphabets.Add(alphabet);
            for (int i = 65; i <= 90; i++)
            {
                alphabet = new Alphabet();
                alphabet.Value = Char.ConvertFromUtf32(i);
                alphabet.isNotSelected = !alphabet.Value
                        .Equals(ViewState["CurrentAlphabet"]);
                alphabets.Add(alphabet);
            }
            rptAlphabets.DataSource = alphabets;
            rptAlphabets.DataBind();
        }

        private void BindDataList()
        {
            string conStr = ConfigurationManager
                    .ConnectionStrings["CompanyInfoEventsConnectionString"].ConnectionString;
            SqlConnection con = new SqlConnection(conStr);
            SqlCommand cmd = new SqlCommand("spx_GetContacts");
            cmd.Connection = con;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Alphabet", ViewState["CurrentAlphabet"]);
            con.Open();
            dlContacts.DataSource = cmd.ExecuteReader();
            dlContacts.DataBind();
            con.Close();

            if (ViewState["CurrentAlphabet"].ToString().Equals("ALL"))
                lblView.Text = "all Contacts.";
            else
                lblView.Text = "Contacts whose name starts with "
                            + ViewState["CurrentAlphabet"].ToString();
        }

        protected void Alphabet_Click(object sender, EventArgs e)
        {
            LinkButton lnkAlphabet = (LinkButton)sender;
            ViewState["CurrentAlphabet"] = lnkAlphabet.Text;
            this.GenerateAlphabets();
            this.BindDataList();
        }



    }

Hi,

The ASCII value of the alphabets A-Z is 65 - 90 same way for Georgian language you need to set appropriate value.

#The ASCll Table:

http://www.asciitable.com/ . 

And I think this article may help you:

http://www.c-sharpcorner.com/uploadfile/satyapriyanayak/alphabetic-paging-using-gridview-control/ .

Best Regards,

Amy Peng