Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   Search query using search term from user input into TextBox (http://www.go4expert.com/forums/search-query-using-search-term-user-t5497/)

Mendoza 27Jul2007 20:30

Search query using search term from user input into TextBox
 
Hi everyone, thank you for the help you provide on this forum, I've learned a lot so far.

Right now I'm making a simple Access-Visual Basic 2005 .NET database. I want to make a Search Query that will search the Database for text similar to what the user inputs into TextBox1.Text on the form where the datagrid is displayed.

I've created a query that works if:

SELECT...
FROM...
WHERE mycolumn = 'oxygen'

for example. It will retrieve and display all matches for oxygen, so the query itself works. But it does not work with the variations I have tried on:

SELECT...
FROM...
WHERE mycolumn = ' "TextBox1.Text" '

The query is:

SELECT FirstName, LastName, City, Major, StudentID FROM Students
WHERE FirstName LIKE ...

I want to be able to search the column <FirstName> for the text that the user inputs in TextBox1.Text and then display the parts of the datagrid that match that.

A blank datagrid appears. I don't think the query is able to see what TextBox1.Text contains.

What do you recommend I do to make this work? Or what alternatives exist to making a robust search button with search terms?

Thanks,

Mendoza

shabbir 27Jul2007 21:59

Re: Search query using search term from user input into TextBox
 
Print the Query just before executing and see what is the value of the query string.

Mendoza 30Jul2007 20:34

Re: Search query using search term from user input into TextBox
 
The code is now:

Code:

Dim connection As New OleDbConnection

("Provider=Microsoft.Jet.OLEDB.4.0;Source=C:\MSDS\MSDS DATABASE DATA\MSDS.mdb;")

Dim [command] As New OleDbCommand("SELECT * FROM Students WHERE FirstName LIKE ?", connection)

[command].Parameters.AddWithValue("@FirstName", Me.TextBox1.Text & "%")

        connection.Open()

        Dim rdr As OleDbDataReader = command.ExecuteReader()

        Dim tbl As New DataTable()
        tbl.Load(rdr)
        Me.StudentsDataGridView.DataSource = tbl

        rdr.Close()
        connection.Close()

And there is a crash due to connection.Open() stating: Could not find installable ISAM.

I tried to fix the problem through this:

http://support.microsoft.com/kb/209805

But all registry references were correct and files were found.



EDIT: Probably has something to do with the fact that I don't have Microsoft Access installed. Tho that hasn't stopped me up to this point.

shabbir 31Jul2007 08:57

Re: Search query using search term from user input into TextBox
 
You don't need the MS Access but you need the Database Engine to establish the connection.

rosewitter 28Jul2010 17:56

Re: Search query using search term from user input into TextBox
 
:thinking:
How can I get the data into a text box (eg. Text1.Text) which is selected in a Datagrid1.


All times are GMT +5.5. The time now is 05:43.