How to display all records from ASP site

Following site contains EDV result and to check result we should provide three initial characters. for example if we provide SUS it displays
1 Sushma Bhattarai Siddharhanagar-9, Rupandehi 2
2 Sushma Dhakal Makawanpur, Narayani 2
3 Sushma Gautam Banepa-6, Kavre 2
4 Susma Subedi Chhaimale-3, Kathmandu 2

http://www.gpo.gov.np/DvSearchform.aspx?y=2009&letter=1st


i've to check nearly 1000 records and its really anowing

how can we display all the records

waiting for replay.

I have no idea what you're asking, sorry.

Please be more clear otherwise you'll be waiting a lot longer than planned

http://www.gpo.gov.np/DvSearchform.aspx?y=2009&letter=1st

above mentioned link contains records of the EDV first letter recipaints list. Suppose, if i wanted to check whether my name is listed or not i've to type starting three characters of my name eg. SUS and search. I want to display all the records from the database. how can i do that?

If it was PHP site that can be obtained by typing %%% in the search box which display all the results but i don't know how to do in ASP.

Your solution is probably a database question, not an asp question. Check your db documentation and look over query options.

Also, your link is to an asp.NET page, if you come up with an actual coding question try the NET forum.

Definately database

WHERE table.firstname LIKE '%"&namesearch&"%'"

Hello, All

I've already solved this issue but i forget to write here. Today i got reply from Frumph my question was not related to backend. I was asking how to see many record i've solved by using wildcard.

thanks