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();
}
});