Spell checking SQL Databases

6 posts, 0 answers
  1. Paul
    Paul avatar
    19 posts
    Member since:
    Jul 2007

    Posted 15 Jul 2008 Link to this post

    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
  2. Paul
    Paul avatar
    19 posts
    Member since:
    Jul 2007

    Posted 16 Jul 2008 Link to this post

    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?
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Lini
    Admin
    Lini avatar
    2144 posts

    Posted 18 Jul 2008 Link to this post

    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
  5. Paul
    Paul avatar
    19 posts
    Member since:
    Jul 2007

    Posted 21 Jul 2008 Link to this post

    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?
  6. Lini
    Admin
    Lini avatar
    2144 posts

    Posted 28 Jul 2008 Link to this post

    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.
  7. Paul
    Paul avatar
    19 posts
    Member since:
    Jul 2007

    Posted 20 Aug 2008 Link to this post

    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?
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017