I have created an Autocomplete Textbox in ASP.NET using C# and SQL SERVER 2005 as Database,(if i type a letter N then all the words with starting letter N will appear) and its working perfectly.
Now my requirement is if a particular word which does not exist in that particular collection of words starting from the letter N,
for ex:NISHAD does not exist in Table in Database and so it won't be in the collection of words,Now if i am writing the word in that textbox and at the end of a button click event i want that the word NISHAD should get saved in the Table in Database.
And from next time whenever i type the letter N in that textbox this word NISHAD should also appear.
NOw tell me how can i do this,i am little bit confused of to do this logically,culd you please help me with any ideas.
Thank you
Regards
Nishad