Hi,
I'm using a dataset to manage an access db... How can I search for values inside that db
How can I do this kind of search, example:
[Table]
Name
John Lewis Stewart
If the user writes 'John' or 'John Lewis' or 'John Stewart', I want to get the record 'John Lewis Stewart'...
Any help
Thanks
searching access db...
Hot Topic
- Visual Stuido Push-Pin Panel
- Opening new IE windows
- If you can answer this Overrides Question... you're brilliant and probably way underpaid
- datagrdiview columnnames
- Immediate Window bug with Enumeration
- Getting the current website address Internet explorer in VB.Net
- How to use MsgBox in c# for a class library
- How to disable select all (corner-button) DataGridView?
- Click Once - How to get version
- No empty rows in DataGrid for Data Insertion
Windows Forms
- Activation Key
- How to obtain the focus?
- Getting raw visibility of a control not based on parent form visibility.
- Listbox in Groupbox
- Arranging the controls in the toolstrip one on top of each other
- How do I get clients machine to automatically register .application file type?
- Input Validation on Windows Forms
- Sort a DatagridviewColumImage
- in arrays...
- Run-time,design-time component
searching access db...
Magesh20355
You mean search within the dataset or within the database I think you mean the dataset....
The easiest way is to create a DataView based on the DataTable in the data set. A data view lets you set row filters, then you can access whatever rows pass the filter. The issue is going to be whether the filter is flexible enough for what you want to do.
Don
simonmango
you also can make a search to the database like this way:
Dim sqlCommand1 As String
sqlCommand1 = "Select * from Adressen where " & strgSearchParam & " Like '" & strgSearchString & "%'"
*** the % is a placeholder for the unknown parameters
*** You have to replace strgSearchParam & strgSearchString with your varibles
hope that help a bit :-)
mfg
sheimann