WPF 搜索数据

输入搜索的内容便能查询到有关联的数据，如图

数据库查询的代码

IF(@type='DataBanks_Loaded_SelectDataBanks')
BEGIN
SELECT  
      ROW_NUMBER () over(order by PW_File.FileID) as number,
      PW_File.FileID,
      PW_FileClass.FileClassID,
      PW_VendorProject.VendorProjectID, 
      RTRIM(PW_File.Filename) AS Filename, 
      RTRIM(PW_File.FileType) AS FileType, 
      RTRIM(PW_File.SubmitNot) AS SubmitNot, 
      RTRIM(CONVERT(varchar(20),FiledateChanged,20)) AS FiledateChanged, 
      RTRIM(PW_File.size) AS size,    
      RTRIM(PW_FileClass.FileClass) AS FileClass          
FROM    PW_File    INNER JOIN
        PW_FileClassON PW_File.FileClassID= PW_FileClass.FileClassID INNER JOIN
        PW_VendorProject ON PW_File.VendorProjectID= PW_VendorProject.VendorProjectID
WHERE   PW_File.FileClassID=12
ORDER BY    PW_File.FileID DESC --倒叙
END