Solved

SEARCH TABLE incremental search

Posted on 2014-10-10
1
200 Views
Last Modified: 2014-10-16
incremental search
Hi Experts
I have a large customer table and I would to part text search like
I have filled a table with all the data called dtCUSTFull
every time  a key is pressed in a  textbox1
I would like to display all the customers.codes that has left part of the code same as textbox1.text
my code
codex = textbox1.text
codeLenx = Microsoft.VisualBasic.LEn(codex)
 
     Dim rows() As DataRow = dtCustFull.Select("Microsoft.VisualBasic.LEFT(ccode,codelenx)=codex)
please help
0
Comment
Question by:b001
1 Comment
 
LVL 20

Accepted Solution

by:
ElrondCT earned 500 total points
ID: 40374687
I've written an article about how to do this using a DataGridView:

http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/A_2210-Progressive-search-in-DataGridView.html

If you define the DataGridView to use dtCustFull as its DataSource, that should do what you want.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: jpaulino
XML Literals are a great way to handle XML files and the community doesn’t use it as much as it should.  An XML Literal is like a String (http://msdn.microsoft.com/en-us/library/system.string.aspx) Literal, only instead of starting and ending with w…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now