Problem with insertion into SqLite Database..

by Raihan Jamal » Wed, 21 Apr 2010 06:22:00 GMT

Sponsored Links
 hanks for replying...
I am having one more problem now...
I am using this below java file to create a database and table on the
click event of Create DB Button[b][i]( till here it is working fine)[/
i] [/b]and then below this Create DB button, there is one more button
named Send Button... and on the click event of Send Button I am
opening another activity which contains a edit text and a button
called Insert[i][b](this is also working fine for me)[/b][/i] and on
the click event of this Insert Button... I have to insert the value
that we are typing into edit text box into the table that we have
created previously.... but I am not able to figure it out why it is
not inserting into table that we have created previously... what wrong
I am doing please let me know.... Below are the codes....
[size=18]This Code contains Create DB Button and Send Button and click
event also that are creating tables and database
package com.example.hw3;

import android.content.Intent;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;

public class HW3 extends Activity {
private Button b1;
private Button b2;
private A1 test;
private EditText text;

/** Called when the activity is first created. */
public void onCreate(Bundle savedInstanceState) {
text = (EditText) findViewById(;

protected void initControls()
b1 = (Button)findViewById(;
b2 = (Button)findViewById(;

b1.setOnClickListener(new Button.OnClickListener()
{ public void onClick (View v){ DoWork(); }});

b2.setOnClickListener(new Button.OnClickListener()
{ public void onClick (View v){
Intent myIntent = new Intent(HW3.this, A1.class);
// HW3.this.startActivity(myIntent);


protected void DoWork()

// SQLiteDatabase db=null;

// db1 = new HW3DbAdapter(this);
text.setText("Button 1 was clicked");

SQLiteDatabase myDB= null;
String TableName = "db_entry";

/* Create a Database. */
try {
myDB = this.openOrCreateDatabase("db_hw3", MODE_PRIVATE,
myDB.execSQL("DROP TABLE IF EXISTS db_entry" );
/* Create a Table in the Database. */
+ TableName
NULL,ph_location TEXT);");

catch(Exception e) {
Log.e("Error", "Error", e);
} finally {
if (myDB != null)


} [/code]

This is the Code for an Activity that contain edit text and Insert
Button....I think something wrong I am doing in the try block of this
code..... Please help[/size]

[code] package com.exampl

Other Threads

1. connection in sqlite

Hi guys,

                  i want to full deatails of how to get the url fields
from database to dispaly....

2. The G1 (RC30) K-9 eMail client

... has the same kinds of problems as the builtin eMail client. This
finding indicates problems with the underlying Android system.


3. Button issue..

4. See thru application

5. How to support VideoPhone ?

6. Problem with the sqlite database

7. About ZygoteInit.acceptCommandPeer