This is a migrated thread and some comments may be shown as answers.

Spell checking SQL Databases

5 Answers 101 Views
Spell
This is a migrated thread and some comments may be shown as answers.
Paul
Top achievements
Rank 1
Paul asked on 15 Jul 2008, 01:30 PM
Hi,

Scenario:
 A user enters details in many text boxes in many web pages which is stored into a SQL database. On one of the web pages I have a spreadsheet application that allows the user to enter text and select from drop down boxes not just on one sheet. I have to use just one spell check button on the final web page to spell check every piece of text entered. This means retrieving data from the database cell by cell checking it then if edited by the user to update the database. Can this be done using telerik spell checker?

Thanks
Paul

5 Answers, 1 is accepted

Sort by
0
Paul
Top achievements
Rank 1
answered on 16 Jul 2008, 12:05 PM
I've been thinking about this more thoroughly. How about the user clicks the spell check button which takes the user to the textbox or text area within the website that needs to be checked. Can this be done?
0
Lini
Telerik team
answered on 18 Jul 2008, 03:38 PM
Hello Paul,

The RadSpell control is designed to check text content on a single web page. You can use it to check one or many controls but they all have to be on the same page. This means that in order to spell check all the text from the user, you will need to retrieve it from the DB and put it on the final page. You can do this with one or more hidden input elements and set the RadSpell control to check them. After the page has been submitted, you will need to update the DB with the value from the input element(s).


Greetings,
Lini
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center
0
Paul
Top achievements
Rank 1
answered on 21 Jul 2008, 09:49 AM
Hi Lini,

I've been asked by my supervisor to extract the text from the various web pages into a grid of 2 columns. The first column indicates which web page or field the text originated from and the second column displays the text to be checked. I was looking at spell checking a grid but in your examples have a spell check button for each row. That wouldn't make sense to use in my scenario.

This leaves me to use text areas (which would have to be dynamic as the number of text fields to check is not known at compile time) for each field to be checked and a textbox to indicate which field it originated from.

Would this be the ideal solution or can you think of another way?
0
Lini
Telerik team
answered on 28 Jul 2008, 07:31 AM
Hi Paul,

I think that with a bit of client-side JavaScript code, you can make a single RadSpell control check all the text boxes in the grid. For example, you can get the grid HTML element and find all its children, which are <input type="text">. Then create a spell checking source with all the text boxes and open the spell dialog. We have an example in our RadSpell online demos, which shows how to create a spell checking source with multiple HTML elements.

Kind regards,
Lini
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Paul
Top achievements
Rank 1
answered on 20 Aug 2008, 10:47 AM
Hi Lini,

I've looked into this and now thinking that a grid of 2 columns would have too many rows of data to spell check - possibly over a hundred rows. I'm now thinking of using a grid of just 2 cells. The first cell would still be the reference to the data in the second cell. When the user clicks the spell check button, each bit of data from the database is loaded into the second cell (with the corresponding reference in the first cell) and spell checked.

Does this make sense? Is this possible and how would I go about it?
Tags
Spell
Asked by
Paul
Top achievements
Rank 1
Answers by
Paul
Top achievements
Rank 1
Lini
Telerik team
Share this question
or