DataTable search alternatives?

pagates

Hi All,

I have a DataTable in a Windows Forms project that I would like to use a
Select statement. The problem is, I'd like to be able to do wildcard
searches (including single charcater searches).

What are my alternatives? I'd rather not have to go back to the database,
unless that is the best way. The DataTable was a performance enhancement.

Thanks,
pagates

Mar 8 '06 #1

Subscribe Post Reply

2635

Michael Nemtsev

Hello pagates,

Why not iterate through the DataTable manually, looking for string that conforms
the Regexp pattern?
p> Hi All,
p> I have a DataTable in a Windows Forms project that I would like to
p> use a Select statement. The problem is, I'd like to be able to do
p> wildcard searches (including single charcater searches).
p>
p> What are my alternatives? I'd rather not have to go back to the
p> database, unless that is the best way. The DataTable was a
p> performance enhancement.
p>
p> Thanks,
p> pagates
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

Mar 8 '06 #2

pagates

Hi Michael,

That is certainly one possibility. However, I was trying to avoid doing
that, as there could be tens of thousands of rows in the DataTable. The
reason for the DataTable was to simplify the process and enhance the
performance.

What I may have to do, if nobody has a better idea, is to combine this with
an answer I got elsewhere, which was to change the search criteria to break
apart the tags (for instance, if aaa*bbb is what I want, then change it to
aaa* and *bbb). Then, with those results, apply the regex filtering you
suggested.

Thanks for the help,
PAGates

"Michael Nemtsev" wrote:

Hello pagates,

Why not iterate through the DataTable manually, looking for string that conforms
the Regexp pattern?
p> Hi All,
p> I have a DataTable in a Windows Forms project that I would like to
p> use a Select statement. The problem is, I'd like to be able to do
p> wildcard searches (including single charcater searches).
p>
p> What are my alternatives? I'd rather not have to go back to the
p> database, unless that is the best way. The DataTable was a
p> performance enhancement.
p>
p> Thanks,
p> pagates
---
WBR,
Michael Nemtsev :: blog: http://spaces.msn.com/laflour

"At times one remains faithful to a cause only because its opponents do not
cease to be insipid." (c) Friedrich Nietzsche

Mar 8 '06 #3

by: VMI | last post by:

We have this huge application that's based on storing tons of data on a dataTable. The only problem we're having is that storing LOTS of data (1 million records) into a datatable will slow down the...

C# / C Sharp

Alternatives to DataTable

by: Guadala Harry | last post by:

The current implementation (that works) retrieves data from a SS2K db via stored procedure that returns 40-60 rows and 6 columns (one string and five int columns), and places that result set into a...

C# / C Sharp

Why is DataTable.Clear() so slow?

by: Brett Romero | last post by:

I fill a DataTable with search results, which take a very long time if I first clear it. The values come from an object and I map them into the corresponding table columns. I may have 65000...

C# / C Sharp

how to search a datatable-can I use sql on a vb2005 datatable?

by: Rich | last post by:

Hello, I need to store various values that I will need to look up later on. I have been using hashtables and arraylists. But I can only store 2 items per row in a hashtable - key, value, and...

Visual Basic .NET

How To Insert DataTable Into MS Access (Record at a time too slow)

by: oopman2002 | last post by:

I have created a DataSet DataTable which is comprised of data from a number of sources. The resultant datatable is about 500,000 records and writing them out one at a time takes forever. Does...

C# / C Sharp

DataTable search performance

by: Larry Smith | last post by:

Hi there, Can anyone comment on the performance issues of "DataTable.Select()" vs "DataView.Find()" (or "DataView.FindRows()"). I have to conduct repeated searches using the same index and I'm...

C# / C Sharp

Community Approach to business object using DataTable.

by: jehugaleahsa | last post by:

Hello: I am trying to find what is the very best approach to business objects in Windows Forms. Windows Forms presents an awesome opportunity to use DataTables and I would like to continue doing...

C# / C Sharp

Same question - Why use a DataTable in ASP .NET?

by: jehugaleahsa | last post by:

Hello: What is the point of using a DataTable in ASP .NET? We are unsure how you can use them without 1) rebuilding them every postback, or 2) taking up precious memory. We are not sure how to...

C# / C Sharp

DataTable in Thread

by: =?Utf-8?B?anAybXNmdA==?= | last post by:

I've got a routine that builds a table using different queries, different SQL Tables, and adding custom fields. It takes a while to run (20 - 45 seconds) so I wrote a thread to handle the table...

C# / C Sharp

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

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...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

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...

Computer Hardware

What is ONU?

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,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

DataTable search alternatives?

Similar topics