Searching by first letter textbox and mysql

Question

2.50/5 (2 votes)

See more:

Hi, I have a datagird and a textbox. Also I have member in MySql Database. So which is the code when I write a first letter of any member of database to show in datagird.

C# code is like that :

C#

_strQuery = "SELECT * FROM tblBibloteka WHERE Emri Like '%" + txtKerko.Text + "%'";

But I have problem with MySql...Some code with MySqlconnection and MySqlAdapter....
Can anyone help me?

--- Update from comments ---
Ok here we are.
I have a datagridview in my application(windows form)and I have a database with some members in mysql. In my windows form I also have a textbox. All what I need is code that when I write the character example 'L' in a textbox then in datagirdview to be listed all names with 'L'. So this textbox must be related with mysql .... I need a code for that.

Posted 13-Jun-12 6:32am

h5h5

Updated 13-Jun-12 10:34am

Kschuler

v3

Add a Solution

Comments

AmitGajjar 13-Jun-12 14:42pm

what problem with mysql ?

h5h5 13-Jun-12 16:21pm

problem is how to connect what I need. so when i write for ex. first letter of any name that is in mysql to show me in datagridview

Tim Corey 13-Jun-12 14:53pm

It is unclear what you are asking for here. Can you please explain what you are attempting to do and where you are stuck?

h5h5 13-Jun-12 16:10pm

Ok here we are.
I have a datagridview in my application(windows form)and I have a database with some members in mysql. In my windows form I also have a textbox. All what I need is code that when I write the character example 'L' in a textbox then in datagirdview to be listed all names with 'L'. So this textbox must be related with mysql .... I need a code for that.

1 solution

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)

Kschuler · Answer 1 · 2012-06-13T10:45:00

If you are looking for just how to make the SQL statement work, you should try this:

C#

_strQuery = "SELECT * FROM tblBibloteka WHERE Emri Like '" + txtKerko.Text + "%'";

The percent sign is a wildcard character, which means that if you are looking for data that STARTS with the letter, you want the wildcard to only appear AFTER that letter.

However, depending upon how your program works and how much data your database has, I'm guessing that it might function quicker and cleaner if you grab everything and instead of hitting the database each time you want to filter, you can just filter the data you already have. If you've connected your data to the DataGrid using a DataTable, you can just set the DataTable's .DefaultView.RowFilter property[^]
You can use the .RowFilter much like the WHERE portion of an SQL statement. For example you could set it to "Emri Like'" + txtKerko.Text + "%'"

And if you're actually wondering about how to connect to MySQL...you can check out http://www.connectionstrings.com/mysql[^] for info on what the connection string needs to be set to. You can also search on google[^] for articles on how to connect. Some of the ones listed there are even CodeProject articles.

Hope this helps.