USE [Taxon]
GO
/****** Object:  StoredProcedure [dbo].[up_SearchByMask]    Script Date: 08/06/2010 09:47:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:			<...>
-- Create date:	<2010-08-04>
-- Description:	<Поиск по маске>
-- =============================================
ALTER PROCEDURE [dbo].[up_SearchByMask]
								@Op int = 0,
								@SearchMask varchar(400) = NULL,
								@SearchType int = 0,
								@TownID int = 0,
								@StreetID int = 0
AS
BEGIN
	declare @SearchMaskLocal varchar(400)
	
	select @SearchMaskLocal = case
					when @SearchType = 0 then @SearchMask + '%'
					when @SearchType = 1 then '%' + @SearchMask
					else '%' + @SearchMask + '%'
				end

	--Street search
	if(@Op = 0)
	begin
		select	sd.StreetID, sd.StreetName
		from		StreetDict sd
		where	sd.StreetName like @SearchMaskLocal
					and sd.TownID = @TownID
	end
	
	--Building search
	if(@Op = 1)
	begin	
		select	bd.BuildingID, bd.BuildingNo
		from		BuildingDict bd
		where	bd.BuildingNo like @SearchMaskLocal
					and bd.StreetID = @StreetID
	end
	
	--Poi search
	if(@Op = 2)
	begin	
		select	sd.StreetID, sd.StreetName, bd.BuildingID, bd.BuildingNo
		from		PoiDict pd
		join		BuildingDict bd on pd.BuildingID = bd.BuildingID
		join		StreetDict sd on sd.StreetID = bd.StreetID
		where	pd.PoiName like @SearchMaskLocal
	end	
END

 private void txtAdressFrom_TextChanged(object sender, EventArgs e)
        {
            txtAdressFrom.DataSource = SearchStreet(txtAdressFrom.Text);//тут вызывается ХП
            txtAdressFrom.ValueMember = "ID";
            txtAdressFrom.DisplayMember = "Name";
        }

 par = new SqlParameter("@SearchMask", txtFastAdressFrom.Text);