Search in database problem

Question

0.00/5 (No votes)

See more:

hi experts.
i have a database with one table named books so i want to make a search box for a column and show . so after watching this video http://msdn.microsoft.com/en-us/vstudio/bb643828.aspx
i did every part accurately but problem is :
when i made following query :

SQL

SELECT         Bookname, quantity, publisher, author,
FROM            books
WHERE        (Bookname LIKE '@bookname' + '%')

a toolbar control appears in my form but has no textbox so i made it manually

and editing my search_BTN click code to this :

VB

Try
            Me.BooksTableAdapter.BooknameQuery(Me.Book_listDataSet.books, ToolStripTextBox1.Text)
        Catch ex As System.Exception
            System.Windows.Forms.MessageBox.Show(ex.Message)
        End Try

here i get error that say :Too many arguments to 'Public Overridable Overloads Function BooknameQuery(dataTable As Book_listDataSet.booksDataTable) As Integer
please help me i am a beginner.

Posted 25-May-13 20:28pm

Dr_miti

Updated 27-May-13 2:14am

Aarti Meswania

v2

Add a Solution

3 solutions

Solution 1

I guess the @bookname is a variable in which you pass the name of the book to be searched.
But you have used it like a string. So, try changing it like below.

SQL

SELECT Bookname, quantity, publisher, author,
FROM books
WHERE (Bookname LIKE @bookname + '%')

Posted 25-May-13 21:11pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Dr_miti 26-May-13 5:01am

thanx for reply but not works
when i simply make query like this :
SELECT Bookname, quantity, publisher, author,
FROM books
WHERE (Bookname = ?)
it works but just accepts exact string and i dont know how to add ( like '%' ) to my query.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 26-May-13 6:10am

Can you post the code of that function where you are querying to Database ?

Dr_miti 26-May-13 7:07am

my search_BTN click code is :

Try
Me.BooksTableAdapter.BooknameQuery(Me.Book_listDataSet.books, ToolStripTextBox1.Text)
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
this code takes user searched string and fill datagrid control in my winform.

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 26-May-13 7:21am

And where is that select query ?

You have referred a video before doing this. I guess I have to see that.
Then I will reply to you after I watch that video.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dr_miti · Accepted Answer · 2013-05-27T02:11:00

Hi all...
thanx for yuor help . my prblem solved by doing this :

1- Query

SQL

SELECT Bookname, quantity, publisher, author,
FROM books
WHERE (Bookname LIKE @param1)

2- search BTN code :

Try
dim Myparam as string = "%" & ToolStripTextBox1.Text & "%"
Me.BooksTableAdapter.BooknameQuery(Me.Book_listDataSet.books, Myparam)
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try

Murali0195 · Accepted Answer · 2013-05-27T02:23:00

Solution 3

Hi...
see this,its may helpful to u.
use ur cmd like this.

cmd = new mysqlcommand("select Bookname, quantity, publisher, author,
FROM books where bookname Like +@name+'%'",con);

thank u.

Posted 27-May-13 2:23am

Murali0195