How to save data from textbox after finish typing

Question

1.00/5 (1 vote)

See more:

Hi guys i have problem i write update statement in text changed event.but repeated changed when any character changed
example
user name text box and has name ahmed and i need to change to ahmedsalah
it save in database as
ahmeds
ahmedsa
ahmedsal
ahmedsala
ahmedsalah
it save 5 times
how please to allow text box to save after finish typing
I have sql 2005
visual studio 2008
if possible help me

Posted 5-Apr-15 19:33pm

ahmed_sa

Add a Solution

Comments

King Fisher 6-Apr-15 1:46am

Is this about Asp.net?

Sascha Lefèvre 6-Apr-15 1:49am

Don't save the input on each textchange, have a button "Save"/"Save changes" instead.

[no name] 6-Apr-15 1:56am

you can use client side event on blur if this related to web development.

Suvendu Shekhar Giri 6-Apr-15 1:58am

Really? As far I remember, textchanged event gets fired only when focus is shifted from the textbox and if so, it should do your job by default. If I am wrong, still I'll ask "what do you mean by save after finish typing ? how application come to know that you have finished typing ?"

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)

OriginalGriff · Answer 1 · 2015-04-05T19:59:00

Solution 1

The easiest way if to move the code from your TextChanged event to the Leave[^] event - as the user has finished input by then.

Alternatively, store it only when the login is successful - that way "amhedsalah" doesn't get stored either because the username isn't found in the login DB.

Posted 5-Apr-15 19:59pm

OriginalGriff

Sergey Alexandrovich Kryukov · Answer 2 · 2015-04-05T20:56:00

It makes no sense at all, just the dreadful UI idea. You should not do any active action on text changing event, as you make the user life a nightmare, and bloat Internet traffic and so on. Only the user knows when she/he finishes the entry, so only the user can trigger handling of the input string, with some click or keyboard hit (such as Enter).

Of course, there are some exclusions, such as the search in a dictionary. But this is a very specific case; moreover, it can only be applied to a local dictionary, not online.

—SA