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. IllegalArgumentException occurs when passing url to post data ... plz help

Look at Uri.encode() or Uri.parse()


2. (WTA) Tsel flash unlimited 125k dan 225k

iya bro

sudah mulai di adakan lagi khusus kartu halo, tadi saya baru daftar di
grapari yang basic


3. Use soft keyboard all the time

4. (WTA) Setiap buka messaging minta force close?

5. Stk no icon

6. Oot ada yang di mega bazaar?

7. Override enableMyLocation in MyLocationOverlay