[jess2705]

i am trying to add the data from the database to listview but the error is dispaly.
My code at a database site is

Cursor getAllLoginInfo()
		 {
			 SQLiteDatabase db=this.getReadableDatabase();
			 Cursor cur=db.rawQuery("SELECT * from Login",new String [] {});		 
			 return cur;
		 }

and the code for adding data in the listview:-

package com.database.login;

import java.util.ArrayList;

import android.app.Activity;
import android.content.Intent;
import android.database.Cursor;
import android.os.Bundle;
import android.util.Log;
import android.view.Menu;
import android.view.MenuInflater;
import android.view.MenuItem;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.SimpleCursorAdapter;

public class temp extends Activity{
	
	public ListView lv1=(ListView)findViewById(R.id.List_data);
	@Override
	public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.temp_logininfo);
        
        DatabaseHelper dbHelper = null;        
        ArrayList<String> results = new ArrayList<String>();
        
     
        
        Cursor cs=dbHelper.getAllLoginInfo();
        
        if(cs.moveToFirst()){
            
        	SimpleCursorAdapter cs1=new SimpleCursorAdapter(this,R.layout.subjectspinnerrow, cs, new String [] {DatabaseHelper.rBranchId,"_id"}, new int []{R.id.txtDeptName});		
        	lv1.setAdapter(cs1);
            cs.moveToNext();
            //cursor.moveToPosition(1);
        }   

     
	}
	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
	    MenuInflater inflater = getMenuInflater();
	    inflater.inflate(R.menu.loginmenu, menu);
	    return true;
	}
	
	@Override
	public boolean onOptionsItemSelected(MenuItem item) {
	    // Handle item selection
	    switch (item.getItemId()) {
	    case R.id.item01:
	        newuser();
	        return true;
	    
	    default:
	        return super.onOptionsItemSelected(item);
	    }
	}
	
	void newuser()
	{
		
		try
		{
			startActivity(new Intent("com.database.login.dbLogin"));
			//startActivity(new Intent("com.database.login.scrolling"));
		}
		catch(Exception ex)
		{
			Log.e("Error",null);
		}
	}
}

[mi14chal]

What errors are you getting?

[jess2705]

mi14chal, on 09 April 2011 - 04:55 PM, said:

What errors are you getting?

Actually no particular error is there, as it starts terminate automatically.
And, the data should be fetched from database but didn't workout. I tried so many things like ArrayList, ListView, TextView to fetch the data but no output.

[mi14chal]

Well, you will have to debug your application.