C#如何实现智能提示
C# winform下,textbox怎么能输入姓名的首字母，给出姓名提示的列表啊，数据库已有。 C# 数据库 智能提示 WinForm
[解决办法]

CREATE FUNCTION [dbo].[fun_getPY]   
(   
    @str NVARCHAR(4000),
    @len int
)   
RETURNS NVARCHAR(4000)   
AS  
BEGIN  
    DECLARE @word NCHAR(1),@PY NVARCHAR(4000)   
    SET @PY=''  
    WHILE len(@str)>0   
    BEGIN  
        SET @word=left(@str,1)   
        SET @PY=@PY+(CASE WHEN unicode(@word) BETWEEN 19968 AND 19968+20901   
        THEN (SELECT TOP 1 PY FROM (   
        SELECT 'A' AS PY,N'' AS word   
        UNION ALL SELECT 'B',N'簿'  
        UNION ALL SELECT 'C',N''  
        UNION ALL SELECT 'D',N''  
        UNION ALL SELECT 'E',N''  
        UNION ALL SELECT 'F',N''  
        UNION ALL SELECT 'G',N''  
        UNION ALL SELECT 'H',N''  
        UNION ALL SELECT 'J',N''  
        UNION ALL SELECT 'K',N''  
        UNION ALL SELECT 'L',N''  
        UNION ALL SELECT 'M',N''  
        UNION ALL SELECT 'N',N''   
 
        UNION ALL SELECT 'O',N''  
        UNION ALL SELECT 'P',N'曝'  
        UNION ALL SELECT 'Q',N''  
        UNION ALL SELECT 'R',N''  
        UNION ALL SELECT 'S',N''  
        UNION ALL SELECT 'T',N''  
        UNION ALL SELECT 'W',N''  
        UNION ALL SELECT 'X',N''  
        UNION ALL SELECT 'Y',N''  
        UNION ALL SELECT 'Z',N''  
        ) T    
        WHERE word>=@word COLLATE Chinese_PRC_CS_AS_KS_WS    
        ORDER BY PY ASC) ELSE @word END)   
        SET @str=right(@str,len(@str)-1)   
    END  
    RETURN substring(@PY,1,@len)
END