在C#中开发怎样按拼音查找到

存储时把拼音存进去：http://hi.baidu.com/sohighthesky/blog/item/d2842a1f66e3ef174134172d.html
然后查询时顺便查下那个字段

试试这个，应该可以的http://blog.sina.com.cn/s/blog_3e57cefa0100d0ud.html

网上的取拼音代码很垃圾，稍微不常用的字就取不到!SIGNATURE:----------------------------------------------------------------------------------------

将汉字拼音首字母一起保存至数据库中.如何得到拼音首字母, 如下:添加命名空间
using System.Text.RegularExpressions;

///   <summary>
///   判断是否为汉字
///   </summary>
///   <param   name="chrStr">待检测字符串</param>
///   <returns>是汉字返回true</returns>
public bool IsChineseCharacters(string chrStr)
{
    Regex CheckStr = new Regex("[\u4e00-\u9fa5]");
    return CheckStr.IsMatch(chrStr);
}/// <summary>
/// 得到每个汉字的字首拼音码字母(大写)
/// </summary>
/// <param name="chrStr">输入字符串</param>
/// <returns>返回结果</returns>
public string GetHeadCharacter(string chrStr)
{
    string strHeadString = string.Empty;    Encoding gb = System.Text.Encoding.GetEncoding("gb2312");
    for (int i = 0; i < chrStr.Length; i++)
    {
        //检测该字符是否为汉字
        if(!IsChineseCharacters(chrStr.Substring(i, 1)))
        {
            strHeadString += chrStr.Substring(i, 1);
            continue;
        }        byte[] bytes = gb.GetBytes(chrStr.Substring(i, 1));
        string lowCode = System.Convert.ToString(bytes[0] - 0xA0, 16);
        string hightCode = System.Convert.ToString(bytes[1] - 0xA0, 16);
        int nCode = Convert.ToUInt16(lowCode, 16) * 100 + Convert.ToUInt16(hightCode, 16);      //得到区位码
        strHeadString += FirstLetter(nCode);
    }
    return strHeadString;
}/// <summary>
/// 通过汉字区位码得到其首字母(大写)
/// </summary>
/// <param name="nCode">汉字编码</param>
/// <returns></returns>
public string FirstLetter(int nCode)
{
    if (nCode >= 1601 && nCode < 1637) return "A";
    if (nCode >= 1637 && nCode < 1833) return "B";
    if (nCode >= 1833 && nCode < 2078) return "C";
    if (nCode >= 2078 && nCode < 2274) return "D";
    if (nCode >= 2274 && nCode < 2302) return "E";
    if (nCode >= 2302 && nCode < 2433) return "F";
    if (nCode >= 2433 && nCode < 2594) return "G";
    if (nCode >= 2594 && nCode < 2787) return "H";
    if (nCode >= 2787 && nCode < 3106) return "J";
    if (nCode >= 3106 && nCode < 3212) return "K";
    if (nCode >= 3212 && nCode < 3472) return "L";
    if (nCode >= 3472 && nCode < 3635) return "M";
    if (nCode >= 3635 && nCode < 3722) return "N";
    if (nCode >= 3722 && nCode < 3730) return "O";
    if (nCode >= 3730 && nCode < 3858) return "P";
    if (nCode >= 3858 && nCode < 4027) return "Q";
    if (nCode >= 4027 && nCode < 4086) return "R";
    if (nCode >= 4086 && nCode < 4390) return "S";
    if (nCode >= 4390 && nCode < 4558) return "T";
    if (nCode >= 4558 && nCode < 4684) return "W";
    if (nCode >= 4684 && nCode < 4925) return "X";
    if (nCode >= 4925 && nCode < 5249) return "Y";
    if (nCode >= 5249 && nCode < 5590) return "Z";
    return "";
    }
}

做过类似功能，参考这个类！using System;
using System.Collections.Generic;
using System.Web;namespace PimSmsWeb.WebCommon
{
    public class PinYing
    {
        private int[] pyvalue = new int[]
{
-20319,-20317,-20304,-20295,-20292,-20283,-20265,-20257,-20242,-20230,-20051,-20036,-20032,-20026,
　　 -20002,-19990,-19986,-19982,-19976,-19805,-19784,-19775,-19774,-19763,-19756,-19751,-19746,-19741,-19739,-19728,
　　 -19725,-19715,-19540,-19531,-19525,-19515,-19500,-19484,-19479,-19467,-19289,-19288,-19281,-19275,-19270,-19263,
　　 -19261,-19249,-19243,-19242,-19238,-19235,-19227,-19224,-19218,-19212,-19038,-19023,-19018,-19006,-19003,-18996,
　　 -18977,-18961,-18952,-18783,-18774,-18773,-18763,-18756,-18741,-18735,-18731,-18722,-18710,-18697,-18696,-18526,
　　 -18518,-18501,-18490,-18478,-18463,-18448,-18447,-18446,-18239,-18237,-18231,-18220,-18211,-18201,-18184,-18183,
　　 -18181,-18012,-17997,-17988,-17970,-17964,-17961,-17950,-17947,-17931,-17928,-17922,-17759,-17752,-17733,-17730,
　　 -17721,-17703,-17701,-17697,-17692,-17683,-17676,-17496,-17487,-17482,-17468,-17454,-17433,-17427,-17417,-17202,
　　 -17185,-16983,-16970,-16942,-16915,-16733,-16708,-16706,-16689,-16664,-16657,-16647,-16474,-16470,-16465,-16459,
　　 -16452,-16448,-16433,-16429,-16427,-16423,-16419,-16412,-16407,-16403,-16401,-16393,-16220,-16216,-16212,-16205,
　　 -16202,-16187,-16180,-16171,-16169,-16158,-16155,-15959,-15958,-15944,-15933,-15920,-15915,-15903,-15889,-15878,
　　 -15707,-15701,-15681,-15667,-15661,-15659,-15652,-15640,-15631,-15625,-15454,-15448,-15436,-15435,-15419,-15416,
　　 -15408,-15394,-15385,-15377,-15375,-15369,-15363,-15362,-15183,-15180,-15165,-15158,-15153,-15150,-15149,-15144,
　　 -15143,-15141,-15140,-15139,-15128,-15121,-15119,-15117,-15110,-15109,-14941,-14937,-14933,-14930,-14929,-14928,
　　 -14926,-14922,-14921,-14914,-14908,-14902,-14894,-14889,-14882,-14873,-14871,-14857,-14678,-14674,-14670,-14668,
　　 -14663,-14654,-14645,-14630,-14594,-14429,-14407,-14399,-14384,-14379,-14368,-14355,-14353,-14345,-14170,-14159,
　　 -14151,-14149,-14145,-14140,-14137,-14135,-14125,-14123,-14122,-14112,-14109,-14099,-14097,-14094,-14092,-14090,
　　 -14087,-14083,-13917,-13914,-13910,-13907,-13906,-13905,-13896,-13894,-13878,-13870,-13859,-13847,-13831,-13658,
　　 -13611,-13601,-13406,-13404,-13400,-13398,-13395,-13391,-13387,-13383,-13367,-13359,-13356,-13343,-13340,-13329,
　　 -13326,-13318,-13147,-13138,-13120,-13107,-13096,-13095,-13091,-13076,-13068,-13063,-13060,-12888,-12875,-12871,
　　 -12860,-12858,-12852,-12849,-12838,-12831,-12829,-12812,-12802,-12607,-12597,-12594,-12585,-12556,-12359,-12346,
　　 -12320,-12300,-12120,-12099,-12089,-12074,-12067,-12058,-12039,-11867,-11861,-11847,-11831,-11798,-11781,-11604,
　　 -11589,-11536,-11358,-11340,-11339,-11324,-11303,-11097,-11077,-11067,-11055,-11052,-11045,-11041,-11038,-11024,
　　 -11020,-11019,-11018,-11014,-10838,-10832,-10815,-10800,-10790,-10780,-10764,-10587,-10544,-10533,-10519,-10331,
　　 -10329,-10328,-10322,-10315,-10309,-10307,-10296,-10281,-10274,-10270,-10262,-10260,-10256,-10254
};        private string[] pystr = new string[]
{
"a","ai","an","ang","ao","ba","bai","ban","bang","bao","bei","ben","beng","bi","bian","biao",
　　 "bie","bin","bing","bo","bu","ca","cai","can","cang","cao","ce","ceng","cha","chai","chan","chang","chao","che","chen",
　　 "cheng","chi","chong","chou","chu","chuai","chuan","chuang","chui","chun","chuo","ci","cong","cou","cu","cuan","cui",
　　 "cun","cuo","da","dai","dan","dang","dao","de","deng","di","dian","diao","die","ding","diu","dong","dou","du","duan",
　　 "dui","dun","duo","e","en","er","fa","fan","fang","fei","fen","feng","fo","fou","fu","ga","gai","gan","gang","gao",
　　 "ge","gei","gen","geng","gong","gou","gu","gua","guai","guan","guang","gui","gun","guo","ha","hai","han","hang",
　　 "hao","he","hei","hen","heng","hong","hou","hu","hua","huai","huan","huang","hui","hun","huo","ji","jia","jian",
　　 "jiang","jiao","jie","jin","jing","jiong","jiu","ju","juan","jue","jun","ka","kai","kan","kang","kao","ke","ken",
　　 "keng","kong","kou","ku","kua","kuai","kuan","kuang","kui","kun","kuo","la","lai","lan","lang","lao","le","lei",
　　 "leng","li","lia","lian","liang","liao","lie","lin","ling","liu","long","lou","lu","lv","luan","lue","lun","luo",
　　 "ma","mai","man","mang","mao","me","mei","men","meng","mi","mian","miao","mie","min","ming","miu","mo","mou","mu",
　　 "na","nai","nan","nang","nao","ne","nei","nen","neng","ni","nian","niang","niao","nie","nin","ning","niu","nong",
　　 "nu","nv","nuan","nue","nuo","o","ou","pa","pai","pan","pang","pao","pei","pen","peng","pi","pian","piao","pie",
　　 "pin","ping","po","pu","qi","qia","qian","qiang","qiao","qie","qin","qing","qiong","qiu","qu","quan","que","qun",
　　 "ran","rang","rao","re","ren","reng","ri","rong","rou","ru","ruan","rui","run","ruo","sa","sai","san","sang",
　　 "sao","se","sen","seng","sha","shai","shan","shang","shao","she","shen","sheng","shi","shou","shu","shua",
　　 "shuai","shuan","shuang","shui","shun","shuo","si","song","sou","su","suan","sui","sun","suo","ta","tai",
　　 "tan","tang","tao","te","teng","ti","tian","tiao","tie","ting","tong","tou","tu","tuan","tui","tun","tuo",
　　 "wa","wai","wan","wang","wei","wen","weng","wo","wu","xi","xia","xian","xiang","xiao","xie","xin","xing",
　　 "xiong","xiu","xu","xuan","xue","xun","ya","yan","yang","yao","ye","yi","yin","ying","yo","yong","you",
　　 "yu","yuan","yue","yun","za","zai","zan","zang","zao","ze","zei","zen","zeng","zha","zhai","zhan","zhang",
　　 "zhao","zhe","zhen","zheng","zhi","zhong","zhou","zhu","zhua","zhuai","zhuan","zhuang","zhui","zhun","zhuo",
　　 "zi","zong","zou","zu","zuan","zui","zun","zuo"
};        private string convert(string chrstr)
        {
            byte[] array = new byte[2];
            string returnstr = "";
            int chrasc = 0;
            int i1 = 0;
            int i2 = 0;
            char[] nowchar = chrstr.ToCharArray();
            for (int j = 0; j < nowchar.Length; j++)
            {
                array = System.Text.Encoding.Default.GetBytes(nowchar[j].ToString());
                i1 = (short)(array[0]);
                i2 = (short)(array[1]);                chrasc = i1 * 256 + i2 - 65536;
                if (chrasc > 0 && chrasc < 160)
                {
                    returnstr += nowchar[j];
                }
                else
                {
                    for (int i = (pyvalue.Length - 1); i >= 0; i--)
                    {
                        if (pyvalue[i] <= chrasc)
                        {
                            returnstr += pystr[i];
                            break;
                        }
                    }
                }
            }
            return returnstr;
        }

        public string WordToPingYin(string chineseWord)
        {
            string pinYing = "";
            if ("abcdefghijklmnopqrstuvwxyz".IndexOf(chineseWord.Trim().ToLower().Substring(0, 1)) != -1)
            {
                pinYing = chineseWord.Trim().ToLower().Substring(0, 1);
            }
            else if ("0123456789".IndexOf(chineseWord.Trim().Substring(0, 1)) != -1)
            {
                switch (chineseWord.Trim().Substring(0, 1))
                {
                    case "0":
                        pinYing = "l";
                        break;
                    case "1":
                        pinYing = "y";
                        break;
                    case "2":
                        pinYing = "e";
                        break;
                    case "3":
                        pinYing = "s";
                        break;
                    case "4":
                        pinYing = "s";
                        break;
                    case "5":
                        pinYing = "w";
                        break;
                    case "6":
                        pinYing = "l";
                        break;
                    case "7":
                        pinYing = "q";
                        break;
                    case "8":
                        pinYing = "b";
                        break;
                    case "9":
                        pinYing = "j";
                        break;
                }
            }
            else if (char.GetUnicodeCategory(Convert.ToChar(chineseWord.Trim().Substring(0, 1))).ToString() == "OtherLetter")
            {
                pinYing = convert(chineseWord.Trim().Substring(0, 1)).Substring(0, 1).ToString();
            }
            else
            {
                pinYing = string.Empty;
            }
            return pinYing;
        }
    }
}

显示、调用：private void FirstNameSelect()
        {
            for (int i = 0; i < 26; i++)
            {
                char temp = (char)(i + 65);
                LinkButton lb = new LinkButton();
                lb.Text = " " + temp.ToString() + " ";
                lb.Click += new EventHandler(lb_Click);                ASPxPanel1.Controls.Add(lb);
            }
        }        private void lb_Click(object sender, EventArgs e)
        {
            LinkButton lb = (LinkButton)sender;
            //Response.Write(lb.Text);
            string word = lb.Text.Replace(" ", "").Trim().ToLower();
            BindData(word);
        }private void BindData(string word)
        {
            Word = word;            PimSmsWeb.WebCommon.PinYing py = new PimSmsWeb.WebCommon.PinYing();            string userName = Session["UserName"].ToString();
            DataSet ds = (new PimSmsWeb.Business.GroupInfo()).GetAllFriend(userName);
            DataTable dt = ds.Tables[0].Clone();            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                string trueName = ds.Tables[0].Rows[i]["TrueName"].ToString();
                if (trueName == string.Empty)
                    continue;                string temp = py.WordToPingYin(trueName);
                if (temp == word)
                {
                    DataRow dr = ds.Tables[0].Rows[i];
                    dt.ImportRow(dr);
                }
            }            ASPxGridView1.DataSource = dt;
            ASPxGridView1.DataBind();
        }

一般需要这种的话都要加一个字段输入码，用英文的
然后输入提示的时候，用like检索这个字段
但是没有这个字段
要加的话可以用我下面的方法，获取对应的英文名
但是有个问题是你得有这个字典表。create FUNCTION [dbo].[split](@str nvarchar(100))
RETURNS varchar(100)
AS
BEGIN
declare @results varchar(100)
declare @count   int
declare @chinese varchar(2)
set @results = ''
set @count = 1
while(len(@str)+1<>@count)
begin
set @chinese = (select top 1 PinyinFirst from DicChinese where Chinese = substring(@str,@count,1))
    set @results = @results +@chinese
set @count=@count+1;
end
return @results
END

数据表再加个拼音字段，到时候根据输入的拼音来查询，用IndexOf来判断是否存在，若存在就把相关的中文显示出来

恩，不用这么麻烦了，微软自己出了一个汉字2拼音的类 Microsoft Visual Studio International Pack
使用方法，老孟的blog有例子http://dotnet.aspx.cc/article/47aa2fc3-ff55-4a57-9491-cc05f555ea3c/read.aspx

http://download.csdn.net/source/834450

调试易

在C#中开发怎样按拼音查找到

解决方案 »