This code does not function. What's wrong?

Question

1.00/5 (2 votes)

See more:

I have a C# Windows form that uses a MS Access database as the data source. The code that does not work is

C#

private void txtSearchName_TextChanged(object sender, EventArgs e)
        {
            string srch = txtSearchName.Text + "%";
            MessageBox.Show(srch);
            this.contactsTableAdapter.FillByName(this.contact_management_databaseDataSet.Contacts, srch, srch);

        }

Nothing is triggered from the textbox change. Can someone show me how to correct this? The query works correctly in the query designer.
I use the same code with MySql and it works as it should.

What I have tried:

I've tried everything I know without success.

Posted 17-Aug-21 6:30am

BobbyStrain

Updated 17-Aug-21 6:46am

PIEBALDconsult

v2

Add a Solution

2 solutions

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)

Richard Deeming · Answer 1 · 2021-08-17T06:37:00

Solution 1

If nothing is triggered - including the message box - then your event handler is not wired up properly.

If the message box shows, but the query doesn't execute, then there's something wrong in the table adapter, which we can't see.

If the query executes but doesn't return any records, then there's something wrong with your query, or there are no matching records. We can't tell you which, because we can't see your query or your input value, and we don't have access to your database.

Posted 17-Aug-21 6:37am

Richard Deeming

Comments

BobbyStrain 17-Aug-21 12:42pm

Nothing is triggered. The message does not show. But the query is good. I'll delete the textbox and code, and rebuild. Maybe that will work. I added the textbox to the form, but pasted the code from a working application. So, maybe it didn't get wired properly.

Richard Deeming 17-Aug-21 12:43pm

You need to use the "events" tab of the properties window for the textbox to wire up the event handler.
How to add or remove an event handler - Windows Forms .NET | Microsoft Docs[^]

OriginalGriff · Answer 2 · 2021-08-17T06:46:00

Quote:
Nothing is triggered. The message does not show.

Then the event handler is not correctly hooked up to the TextBox, or you are entering data in the wrong textbox (or wrong instance of the right textbox)

Start with the debugger: put a breakpoint on the first lien of the handler and check if it is hit. If it isn't, find every reference to the TextBox and put a breakpoint on all of those too. When you find out which reference isn't working as expected you can start fixing teh problem.

But we can't do any of that for you!