Android listview with database and fixed values

Question

I'm quite beginner with android and I have problem with my listview.

So I'm getting listview values from database and thats working fine. But I want to edit one of those values before showing it to user and after many failures I kindly ask your advice.

Here is my code for fetching data and showing it in listview

listSquad=(ListView)findViewById(R.id.listview);            

        String[] arrayColumns = new String[]{"sq_pos", "sq_name", "sq_born", "sq_gam", "sq_goal"};

        int[] arrayViewID = new int[]{R.id.pos,R.id.name,R.id.age,R.id.games,R.id.goals};

            DBAdapter db = new DBAdapter(this);
            db.open();
            Cursor c;
            c = db.doQuery("squad", null, null, null, null, null, "sq_name");

            SimpleCursorAdapter adapter = new SimpleCursorAdapter(this, R.layout.team_list_lay, c, arrayColumns, arrayViewID);
            listSquad.setAdapter(adapter);

So I would like to take value of "sq_born" column and alter it and then show up in listview. That column is integer.

please refer to the following [link][1] [1]: http://stackoverflow.com/questions/4776936/modifying-simplecursoradapters-data — Aditya Rai, Aug 21 '13 at 19:39

score 1 · Accepted Answer · answered Aug 22 '13 at 14:40

Like suggested by Aditya Rai, I used viewbinder like below:

adapter.setViewBinder(new SimpleCursorAdapter.ViewBinder() {
            public boolean setViewValue(View view, Cursor cursor, int column) {
                if( view.getId() == R.id.age){
                    //do something here
                    TextView text = (TextView)view;
                    //set text in here                      
                    text.setText("blaah");                                                                        
                    return true;
                }
                return false;
            }
        });

Android listview with database and fixed values

1 Answers1