How I get Data from th SQLite Database to a EditText?

Question

hi i want to get data from the sqlite database. I want to use a method to load data in my Edittext.

private void ladeDaten(String tbname,String fach)
    {
        String select = "SELECT info FROM "+tbname+" WHERE name='"+fach+"'";

        String info = ""; // how I can 

        ((EditText)(findViewById(R.id.txtContacto))).setText(info);
    }

What can I do?

http://www.vogella.com/articles/AndroidSQLite/article.html is a good tutorial for Sqlite. — David M, Jan 24 '13 at 13:40
An example of what you looking for can be found in
http://stackoverflow.com/questions/12015731/android-sqlite-example — joey.enfield, Jan 24 '13 at 13:40
Where does `fach` come from? Alway keep [little Bobby tables](http://xkcd.com/327/) in mind. — jlordo, Jan 24 '13 at 16:02

score 0 · Answer 1 · answered Jan 24 '13 at 13:42

Solution for you :

public int GetDeptID(String Dept)
  {
   SQLiteDatabase db=this.getReadableDatabase();

   Cursor c=db.rawQuery("SELECT "+colDeptID+" as _id FROM "+deptTable+" WHERE "+colDeptName+"=?",
new String []{Dept});
   c.moveToFirst();
   return c.getInt(c.getColumnIndex("_id"));

  }

Read more here : http://mobileorchard.com/android-app-development-using-sqlite-database/

ITS ONLY EXAMPLE

How I get Data from th SQLite Database to a EditText?

1 Answers1