Thank you very much. This is code.. So the point where I have commented gives error (unfortunately app stops), when the comment is removed.
public class MainActivity extends AppCompatActivity {
DatabaseHelper myDb;
ListView lv;
SQLiteDatabase db;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
lv = (ListView)findViewById(R.id.ListView2);
myDb = new DatabaseHelper(this);
db=openOrCreateDatabase("BSR_DB",MODE_PRIVATE,null);
//show item name on ListView
/* Cursor c = db.rawQuery("select Name from bsr_civil",null);
ArrayList ar = new ArrayList();
while(c.moveToNext())
{
ar.add(c.getString(0)); //Some kind of error from here
}
ArrayAdapter ad = new ArrayAdapter(this,android.R.layout.simple_list_item_1,ar); */
lv.setAdapter(ad);
// select item and show data of selected item on Alert Dialog
lv.setOnItemClickListener(new AdapterView.OnItemClickListener() {
@Override
public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
Cursor cr=db.rawQuery("SELECT * FROM bsr_civil WHERE NAME='"+lv.getItemAtPosition(position).toString()+"'",null);
StringBuffer sb = new StringBuffer();
while(cr.moveToNext())
{
sb.append(cr.getString(0)+"\n");
sb.append(cr.getString(1)+"\n");
sb.append(cr.getString(2)+"\n");
sb.append(cr.getString(3)+"\n");
sb.append(cr.getString(4)+"\n");
sb.append(cr.getString(5)+"\n");
sb.append(cr.getString(6)+"\n");
sb.append(cr.getString(7)+"\n");
sb.append(cr.getString(8)+"\n");
}
AlertDialog.Builder al = new AlertDialog.Builder(MainActivity.this);
al.setTitle("Civil Items");
al.setMessage(sb.toString());
al.show();
}
});
Recommended editorial content
With your consent, external content is loaded here.
By clicking on the button above, you agree that external content may be displayed to you. Personal data may be transmitted to third-party providers in the process. You can find more information about this in our Privacy Policy.