How to handle the TextChanged event only when the user stops typing?

Question

I have a TextBox with a TextChanged event wired up. In the end it is making a query to a SQL database, so I want to limit the number of queries.

I only want to make the query if the user hasn't pressed a key in say .. 300 milliseconds or so. If for some reason the previous query is still executing, I would need to cancel that, and then issue a new query.

score 9 · Accepted Answer · answered Jun 24 '10 at 18:17

9

Create a System.Windows.Forms.Timer and reset it (e.g. stop then start it) after every keypress. If the timer event is triggered, disable the timer.

answered Jun 24 '10 at 18:17

Brian

25,523
18
82
173

This is the method I used and it worked perfectly. Surprisingly I am not getting any exceptions about the UI being updated by another thread? – esac Jun 24 '10 at 18:40
See http://msdn.microsoft.com/en-us/magazine/cc164015.aspx#S1 . The short answer is that the event is executed in the UI thread. Which makes sense, considering that it is in the `System.Windows.Forms` namespace. – Brian Jun 24 '10 at 18:43

score 1 · Answer 2 · answered Jun 24 '10 at 17:59

Use the Reactive Framework to trigger on a sequence of events. I'm not sure exactly how this would work, but you can read up on it here (Reactive Extensions for .NET) and see if it will fulfill your needs. There are a bunch of examples here too: Examples. The "Throttling" example may be what you're looking for.

Kyra · Answer 3 · 2010-06-24T19:07:00.073

0

Add a second actionlistener that gets called whenever the user presses any key and when it gets called save the current time to a global variable. Then whenver your TextChanged event gets called it checks to see the time difference between the global variable and the current time.

If the difference is less than 300 milliseconds then start a timer to execute the query after 300 milliseconds. Then if the user presses another key it resets the timer first.

edited Jun 24 '10 at 19:07

answered Jun 24 '10 at 17:57

Kyra

5,129
5
35
55

This requires the user to wait 300ms and then type another character if they want to submit results. – Brian Jun 24 '10 at 18:10

score 0 · Answer 4 · answered Jun 24 '10 at 18:17

1) Create a timer.

2) Create a handler for the Tick event of your timer. On each tick, check to see if enough idle time has elapsed, and if it has, STOP the timer and execute the query.

3) Whenever a keypress occurs on that textbox, RESTART the timer.

score 0 · Answer 5 · edited May 23 '17 at 11:53

Thanks to @Brian's idea and this answer , I came up with my own version of using a timer to handle this issue. This worked fine for me. I hope it helps the others as well:

private Timer _tmrDelaySearch;
private const int DelayedTextChangedTimeout = 500;
private void txtSearch_TextChanged(object sender, EventArgs e)
{
    if (_tmrDelaySearch != null)
    _tmrDelaySearch.Stop();

    if (_tmrDelaySearch == null)
    {
        _tmrDelaySearch = new Timer();
        _tmrDelaySearch.Tick += _tmrDelaySearch_Tick;
        _tmrDelaySearch.Interval = DelayedTextChangedTimeout;
    }

    _tmrDelaySearch.Start();
}

void _tmrDelaySearch_Tick(object sender, EventArgs e)
{
    if (stcList.SelectedTab == stiTabSearch) return;
    string word = string.IsNullOrEmpty(txtSearch.Text.Trim()) ? null : txtSearch.Text.Trim();

    if (stcList.SelectedTab == stiTabNote)
    FillDataGridNote(word);
    else
    {
        DataGridView dgvGridView = stcList.SelectedTab == stiTabWord ? dgvWord : dgvEvent;
        int idType = stcList.SelectedTab == stiTabWord ? 1 : 2;
        FillDataGrid(idType, word, dgvGridView);
    }

    if (_tmrDelaySearch != null)
    _tmrDelaySearch.Stop();
}

How to handle the TextChanged event only when the user stops typing?

5 Answers5

Linked