You want to use a 'like' query on your database which allows you to search through string which 'looks like' your string... the syntax is easy select field1, field2 from table where field1 like '%demo%' this returns all rows where field1 contains the string 'demo'. However, you may consider using and/or functionality in your websearch, for example when a visitor enters demo+csharp in the textbox. Your query should look like this select field1, field2 from table where field1 like '%demo%' and field1 like '%csharp%' If the user enters 'demo csharp' as search text, you want select field1, field2 from table where field1 like '%demo%' or field1 like '%csharp%' This makes searching complicated. Afterwards you want to sort the result set having the most relevant match on top. For example you can count the number of matches for each result in the result set and order the result set depending on that number of matches having the most matches on top. You can make search functionality as easy or as complicated as you want... ;) I love it when a plan comes together http://www.zonderpunt.nl[^]

You need to set a criteria for how a particular thing will be searched out in your database. Like is a keyword that tells the query look for something that i am passing in the parameter. Like keyword is different than Equal or ==. As Obvisouly, equal mean look exactly what I need to search. SELECT * FROM QUESTION_PARENT WHERE (PTYPE LIKE 'searchCriteria')

thank you. You helped me alot.

Thank you very much but I want to use datagrid not datalist ...its better I think. any other ideas about direction of datagrid as I asked above?

Hello friend, You cannot do this using asp.net textbox but u can take a look at this link. http://freetextbox.com/default.aspx[^] Mehedi Hasan