How to store the textbox data in local SQL Server db in blackberry application?

Question

I am having two controls on main screen one is text box and other is button.

On button click, i want to store textbox data into one of my sql server table.

As i am newbie in BB dev, so not sure which approach i have to follow to achieve this.

Any help or lights on this will be really appreciated.

Thanks in advance !!

score 0 · Answer 1 · answered Jun 17 '11 at 05:33

You can get data from textbox using textbox.getText();

Store it as string and then you can insert this data referring this code:

 try
        {
            URI myURI = URI.create("file:///SDCard/Databases/SQLite_Guide/" +
                                   "MyTestDatabase.db"); 
            d = DatabaseFactory.open(myURI);

            Statement st = d.createStatement("INSERT INTO People(textboxid) " +
                                             "VALUES (textbox.getText())");
            st.prepare();
            st.execute();
            st.close();
            d.close();

        }
        catch ( Exception e ) 
        {         
            System.out.println( e.getMessage() );
            e.printStackTrace();
        }

How to store the textbox data in local SQL Server db in blackberry application?

1 Answers1