473,413 Members | 1,731 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,413 software developers and data experts.

Paging data and highlight closest match

I have created an ASP.NET using page that allows the user to page through a
result set. I need to expand on this. On that same page I have a field where
the user can type in a search string. When they click a button ALL the
results will be returned and the closest match to the search string will be
highlighted. I found some interesting ways to page through the data, but I
need to determine what page the closest match is on. In the old version of
ADO there was a FIND method. Regardless of how I page my data, what is the
best way to do what I need. Thanks
Apr 21 '06 #1
2 1383
Daniel,

Does the data have to remain in any particular order? If not you may want to
take a look at a search object I built. It gives all items a search score
and orders them by that score so the closest match is moved to the top...

I give away the component for free, including full source, on my website:
www.aboutfortunate.com just go to the code library page and click on
"Search" in the menu on the left.

Regards,

--
S. Justin Gengo
Web Developer / Programmer

Free code library:
http://www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"Daniel Di Vita" <Da**********@discussions.microsoft.com> wrote in message
news:18**********************************@microsof t.com...
I have created an ASP.NET using page that allows the user to page through a
result set. I need to expand on this. On that same page I have a field
where
the user can type in a search string. When they click a button ALL the
results will be returned and the closest match to the search string will
be
highlighted. I found some interesting ways to page through the data, but I
need to determine what page the closest match is on. In the old version of
ADO there was a FIND method. Regardless of how I page my data, what is the
best way to do what I need. Thanks

Apr 21 '06 #2
The data has to be ordered by any of the column headings.

"S. Justin Gengo" wrote:
Daniel,

Does the data have to remain in any particular order? If not you may want to
take a look at a search object I built. It gives all items a search score
and orders them by that score so the closest match is moved to the top...

I give away the component for free, including full source, on my website:
www.aboutfortunate.com just go to the code library page and click on
"Search" in the menu on the left.

Regards,

--
S. Justin Gengo
Web Developer / Programmer

Free code library:
http://www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"Daniel Di Vita" <Da**********@discussions.microsoft.com> wrote in message
news:18**********************************@microsof t.com...
I have created an ASP.NET using page that allows the user to page through a
result set. I need to expand on this. On that same page I have a field
where
the user can type in a search string. When they click a button ALL the
results will be returned and the closest match to the search string will
be
highlighted. I found some interesting ways to page through the data, but I
need to determine what page the closest match is on. In the old version of
ADO there was a FIND method. Regardless of how I page my data, what is the
best way to do what I need. Thanks


Apr 22 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: David Morgan | last post by:
Hello I have a little function to highlight text if it exists. Function Highlight(vFind, vSearch) Dim RegEx Set RegEx = New RegExp RegEx.Pattern = vFind RegEx.IgnoreCase = True Highlight =...
0
by: Chan | last post by:
I have about 1,000 records in my XML to be shown. It's too much to display all of them at once. So, paging is a good implementation. I'm doing all this at client side, that is, - xml dataisland...
13
by: mike | last post by:
I have ListArray with number in Eg: 1, 1.456, 2.43, 4, 6.78 next i have a decimal variable containing one number EG: 1.786 Could someone please tell me how i find the "closest match" number...
6
by: Shawn | last post by:
Hi. I already have a datagrid where I'm using paging. I have a stored procedure that fills a temp table with 200-500 rows and then sends back 10 records at the time. When I go to page 2 the SP...
2
by: asad | last post by:
Hello friends, i am designing a ASP.NET page where i want to use custom paging bcoz data is too heavy so pls tell me how can i use custom paging in ASP.NET Thanks
0
by: dnphamus13 | last post by:
I'm new to this and drowning right now. I would like to put my database online for viewing. I managed to do the filtering but i need to do PAGING as the XML doc get bigger. From what i understand...
2
by: farhad13841384 | last post by:
Hi , I Hope You fine. I have some problem with this code for paging in asp.net this bottom code work correctly without any error but when I try to place separate code in .VB file then error is...
5
by: Donald Adams | last post by:
Hi, I will have both web and win clients and would like to page my data. I could not find out how the datagrid control does it's paging though I did find some sample code that says they do it...
1
by: CatherineA | last post by:
I need help writing an SQL statement in Access 2007 to select the closest date/time. I have Spot Time (the date/time commercials ran) and Call Time (the date/time we received calls). I need to...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.