vinal s.sen

thanks Ulf!!!

I found solution.everytime i create a database,I give a new name then problem is solved.dunno why.as i am running out of time for finishing my project,as quick fix,I am changing the database name.

There is a form with 2 pages in it.When i click on next,it should go to next page,starting a new activity.but when i click on the button,android application stops working.please tell me what is the error in the code.

Mainscreen code

(Globalstate class is for saving the values so it could be retrieved from newly created activity)

public class Mainscreen3Activity extends Activity implements OnClickListener { /** Called when the activity is first created. */ String s1,s2,s3; GlobalState1 gs; public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); View v=findViewById(R.id.button1); v.setOnClickListener(this); } public void onClick(View v) { // TODO Auto-generated method stub EditText rname=(EditText) findViewById(R.id.editText1); EditText sname=(EditText)findViewById(R.id.editText2); EditText smailid=(EditText)findViewById(R.id.editText3); s1=rname.getText().toString(); s2=sname.getText().toString(); s3=smailid.getText().toString(); //obj1=new GlobalState(); // gs = (GlobalState) getApplication(); gs=new GlobalState1(); gs.setTestMe(s1,s2,s3); Toast.makeText(Mainscreen3Activity.this,"till globalstate",5000).show(); Intent intent=new Intent(Mainscreen3Activity.this,secondscreen.class); Toast.makeText(Mainscreen3Activity.this,"launching intent",5000).show(); Mainscreen3Activity.this.startActivity(intent); } } class GlobalState1 extends Application { public String rname,sname,smailid; public String getrname() { return rname; } public String getsname() { return sname; } public String getsmailid() { return smailid; } public void setTestMe(String rname,String sname,String smailid) { this.rname=rname; this.sname=sname; this.smailid=smailid; } }

android manifest file
<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
package="nithya.androidprojects"
android:versionCode="1"
android:versionName="1.0" >

<uses-sdk android:minSdkVersion="15" />

<application
android:icon="@drawable/ic_launcher"
android:label="@string/app_name" >
<activity
android:name=".Mainscreen3Activity"
android:label="@string/app_name" >
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>


<activity
android:name="secondscreen"
android:label="secondscreen">
</activity>
</application>

</manifest>


please help me...thanks in advance

vinal

Ulf,I tried doing the things you asked.no error shows up in my mobile.

Please explain more about database in mobile.I need to show my application completely in mobile(without rooting to pc) what is the class I should use..?

Is there any tutorial or book out there to help me completely deploy my application in mobile?

Please help me.me confused.

this is the code i am using.

public class SelectdataActivity extends Activity { /** Called when the activity is first created. */ SQLiteDatabase db; Button button1; public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); button1=(Button)findViewById(R.id.button1); try{ db=openOrCreateDatabase("StudentDB",SQLiteDatabase.CREATE_IF_NECESSARY,null); db.execSQL("Create Table Temp2(id integer,name text)"); }catch(SQLException e) { } button1.setOnClickListener(new View.OnClickListener() { public void onClick(View v) { // TODO Auto-generated method stub EditText eid=(EditText) findViewById(R.id.editText1); EditText ename=(EditText)findViewById(R.id.editText2); ContentValues values=new ContentValues(); values.put("id", eid.getText().toString()); values.put("name", ename.getText().toString()); if((db.insert("temp2", null, values))!=-1) { Toast.makeText(SelectdataActivity.this, "Record Successfully Inserted", 2000).show(); } else { Toast.makeText(SelectdataActivity.this, "Insert Error", 2000).show(); } eid.setText(""); ename.setText(""); //Cursor c=db.rawQuery("SELECT * FROM temp2",null); Cursor c=db.rawQuery("SELECT * FROM temp2 where name like 'vinal'",null); c.moveToFirst(); while(!c.isAfterLast()) { Toast.makeText(SelectdataActivity.this,c.getString(0)+ " "+c.getString(1),1000).show(); c.moveToNext(); } c.close(); } }); } @Override protected void onStop() { // TODO Auto-generated method stub db.close(); super.onStop(); } }

thanks Ulf for the reply.can you please tell me what class I should be using.

I am building a small project. I need to show application on my mobile.

you mean to say that I should be using some class to display the tableview of my database???

whether the phone is rooted or not, no rows are displayed.does it not mean the data is not stored on my mobile??

working fine in emulator.all rows are displayed using toast.

thanks

i created a small program for inserting data into the table.two textfields and a button present

it is running in the emulator.i could view the tables using sqlite data browser.

how do i view the same table in my mobile device?i am able to run my program in the device(with or without rooting to pc).in my mobile,record inserted successfully(output of the program) comes.but how do i check database.where it will be stored? do i have to install any data browsing application in my mobile device?

Please help i am new to this android.

thanks

thanks a lot,Ulf Dittmer....I have been struck with this 6 to 7 hours..was not able to solve it.

now it works

I went through net..could not find a solution.Is there any book that you will recommend?

once again,thanks

Sorry for me being vague. i try to input value to a textbox and based on that ,i want to get rows from the table..please help me..i am finding it difficult to use variable in a select statement...
EditText searchname=(EditText) findViewById(R.id.editText1); -------> String nn=searchname.getText().toString(); //Toast.makeText(Selectdata2Activity.this,searchname.getText().toString(),2000).show(); Toast.makeText(Selectdata2Activity.this,nn,2000).show(); // Cursor c=db.rawQuery("SELECT * FROM temp2 where name like 'mmm'",null); -------> Cursor c=db.rawQuery("SELECT * FROM temp2 where name like nn",null); c.moveToFirst(); while(!c.isAfterLast()) { Toast.makeText(Selectdata2Activity.this,c.getString(0)+ " "+c.getString(1),1000).show(); c.moveToNext(); } c.close(); } });


cursor does not return any values...no output produced on the screen.how do I use a variable???

(however if i supply the value directly,it is working and fine and comes up with data)

thanks in advance

hi all!!!


i am doing a project,for which I am trying to select only certain rows,using the condition where.

how to write sql statement and retrieve certain rows only.

EditText eid=(EditText) findViewById(R.id.editText); EditText ename=(EditText)findViewById(R.id.editText2); ContentValues values=new ContentValues(); values.put("id", eid.getText().toString()); values.put("name", ename.getText().toString()); if((db.insert("temp2", null, values))!=-1) { Toast.makeText(DatatestingActivity.this, "Record Successfully Inserted", 2000).show(); } else { Toast.makeText(DatatestingActivity.this, "Insert Error", 2000).show(); } eid.setText(""); ename.setText(""); //Cursor c=db.rawQuery("SELECT * FROM temp2",null); -------> Cursor c=db.rawQuery("SELECT * FROM temp2 where name='mmm'",null); c.moveToFirst(); while(!c.isAfterLast()) { Toast.makeText(DatatestingActivity.this,c.getString(0)+ " "+c.getString(1),1000).show(); c.moveToNext(); } c.close(); }

output is not right...... what is the method I should be using to select only certain rows.

thanks in advance