Please Help me HOW TO GET RESULT SEARCH IN PAGING DataList CONTROL

See more:

C#

ASP.NET

I have Database called mygroup , and I have three tables
* Cataloges table .. columns (CatalogeId int, CatalogeName nvarchar)
* Brand table .. columns (BrandId int, BrandName nvarchar)
* Products table, it is consists of these columns :


ProductId int
ProductNO nvarchar
CatalogeId int
BrandId int
MainSpecification nvarchar
DetailsSpecification ntext
Image image


I want to desgin form for products, and this form contain these ToolBox
* DropDownList for CatalogeId
* DropDownList for BrandId
* DataList Control for displaying the Result Search
* Button

When the user visite Product Page for Example (productpage.aspx), then he see the two DropDownList , then choose one of Cataloge Name (Laptop , Printer, ....) , and choose one of the Brand Name (Sony, Toshiba, ....) , then Click the Button, and get the
Result Search in Paging DataList help me in this with Design and Programming in (C#)


By the way if there is no data available so the DataLis is Invisible, and
Label show Message "Sorry no Data Available"